Unit Test — Unit test Answers

Which term refers to a value in a table that is a reference to the unique values in a corresponding table in a relational database?

Lana needs to create forms for tables in her database to ensure consistency with data entry. What is the easiest way to achieve this goal, assuming Lana wants to select the fields to be included?

Which object is a storage container that contains data in rows and columns and is the primary element of Access databases?

Which field property is used to check the data that is entered to ensure it is in compliance with configured rules?

Which source is not valid for a Lookup list?

Which view is used to enter data into an Access table by default?

Which option should be used to access the Replace functionality immediately to replace values in a table with another value?

Which LIKE operator would match a single character?

Which feature in Access is used to control data entry into database tables to help ensure consistency and reduce errors?

Dan wants to create a report that contains all the fields from a table. Which option on the Create tab should he utilize?

Which statement best describes a characteristic of a relational database?

Which section available in the Design view for the form actually includes the record data itself?

Which option is typically only used when utilizing self joins?

Keisha is creating an input mask and needs to ensure that the user will only enter digits into the field. Which two characters do NOT enforce this rule?

Marcus needs to add a query for multiple tables in his database. He is using Access 2016. Which tab should he use to add the query?

Brendan is examining a report using the Design view. Which section in the Design view is going to appear only once on the first page and could contain logos and title information?

Xavier is using a query that includes a LIKE comparison operator with the value of A[a-n]*. Which option would match this operator?

Which tool is an easy way to navigate between rows of data in an Access table and is found in the status bar?

Which type of join is most commonly performed using standard queries in Access?

Where is the Quick Search capability found in Access 2016?