Exam 1: Access: Creating Advanced Queries and Enhancing Table Design

You must use the Input Mask Wizard in ____ view.

Which of these steps is incorrect in the use of the Find Duplicates Query Wizard? In the Other group on the Create tab Calvin clicks the Query Wizard button. He clicks Find Duplicates Query Wizard and then clicks the OK button. Calvin completes the Wizard dialog boxes by selecting the table or query on which to base his query. He selects the fields to check for duplicate values selects the additional fields to include in his query results enters the name for the query and then clicks the Finish button.

The aggregate function First returns the first field value in a selection of records.

The input mask character ____ is a placeholder character.

You can change a select query to a crosstab query in Design view using the Crosstab button in the Database group on the Query Tools Design tab.

A table ____________________ rule compares one field value in a table record to another field value in the same record to verify their relative accuracy.

The ampersand wildcard character represents any single character.

The quickest way to create a crosstab query is to use the Crosstab Query ____.

You can change a select query to a crosstab query in Design view using the Crosstab button in the Query Type group on the ____ tab.

A(n)____ exists between two objects when a change to the ____ of data in one object affects the properties of data in the other object.

You perform a pattern match using the ____ comparison operator.

Aggregate functions like those shown in the above figure perform ____ operations on selected records in a database.

A(n)____________________ exists between two objects when a change to the properties of data in one object affects the properties of data in the other object.

Using a pattern match is similar to using an exact match except that a pattern match includes ____ characters.

A(n)____ match selects records whose value for the selected field matches one of two or more simple condition values.

The Top Values property must be an integer.

The ____ comparison operator lets you define a condition with two or more values.

A(n)____________________ is a predefined format used to enter and display data in a field.