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

If the value of ____ displays between the input mask characters ;; this indicates that literal display characters should not be stored in the database.

A find unmatched query searches for duplicate values based on the fields you select as you answer the Query Wizard's questions.

The item in the figure above is the ____________________ list box.

Which of the following is a literal display character?

Of the aggregate functions shown in the figure above the ____ function returns the lowest of the field values in a selection of records.

A(n)______________________________ query is a select query that locates duplicate records in a table or query.

The In comparison operator is roughly equivalent to the use of several And conditions in the design grid.

Press ____ to highlight the entire condition in a text box.

If you convert an Access database to SQL-Server your ____ queries will most likely not work.

The Freeze command is available in the ____ group on the Home tab under the More button.

The capability to update field properties in objects automatically when you modify a table field property is called ____________________.

The ____ represents any string of characters

As shown in the figure above a prompt query prompts you for information when the query runs.

The ____ property for a query lets you limit the number of records in the query results.

As shown in the above figure a ____ query prompts you for information when the query runs.

When you click the Input Mask text box in the Field Properties pane a ____ button appears to the right of the Input Mask text box.

An easy way to create an input mask is to use the Input Mask Wizard.

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

The ____ comparison operator selects records by matching field values to a specific pattern that includes one or more of these wildcard characters: # * and ?.