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

The ____ logical operator negates a criterion.

Which of the following Top Values properties would display the first half of the records in a query?

The aggregate function ____ returns the total of the field values in a selection of records.

The input mask character ____ indicates that only a digit can be entered.

After you set field ____ rules Access will prevent users from entering an invalid field value for example in all current and future queries and forms.

The ____ Mask Wizard is an Access tool that guides you in creating a predefined format for a field.

Access detects ____ validation rule violations immediately after you finish all changes to the current record and advance to another record.

You need to perform an aggregate function in a crosstab query. Your functions needs to calculate the number of the nonnull field values in your spreadsheet. Which aggregate function will you use?

A(n)____________________ field lets the user select a value from a list of possible values.

Double-click the ____________________ of a field list in Design view to highlight all the fields.

Figurative display characters are the special characters that automatically appear in specific positions of a field value.

The Validation Text property value specifies the valid values that users can enter in a field.

What you could accomplish with several Or conditions in the design grid you can do more easily with the ____ comparison operator.

Make sure you type ____ enclosing field names when you enter values in the Validation Rule text box.

A lookup manager lets the user select a value from a list of possible values.

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