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

You create the selection criterion for a nonmatching value using the ____________________ logical operator.

The default character display is left to right but the ! input mask character can be used to reverse that display.

If you want to display all students who have the same phone number you would use a ____________________ query.

If you need to store and display phone numbers zip\postal codes and other fields in a variety of formats it's best to define them as Text fields with an input mask instead of letting users enter field values and the literal display characters.

A ____ field lets the user select a value from a list of possible values.

To include literal display characters you need to create a(n)____ mask.

A(n)exact match like the one shown in Figure AC5-1 selects records with a value for the selected field that matches the pattern of the simple condition value.

A(n)____________________ selects records with a value for the selected field that matches the pattern of the simple condition value.

The above figure shows a(n)____________________ Enter the city.

____ between Access objects can occur in various ways.

The aggregate function ____________________ returns the number of the nonnull field values in a selection of records.

In the Object Dependencies pane you can click the expand indicator for the collapsible list of dependencies to show or hide different levels of dependencies.

A(n)____ query performs aggregate function calculations on the values of one database field and displays the results in a spreadsheet format.

Property propagation does not occur with queries automatically.

When you finish all changes to the current record and advance to another record Access detects field validation rule violations.

Press and hold down the ____ key to select multiple columns.

= are examples of ____ operators.

If you want to display all non-degree students who are not currently enrolled in classes you would use a(n)find duplicates query.

If you want to display all products that have the same description you would use a(n)find unmatched query.