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

An input mask with a 0 character indicates that only a digit can be entered as the value and that the entry is optional . ____________________

Valid values that may be entered in a field are specified using the ____________________ propoerty.

Which of the following pattern match selection criteria would return zip codes with the characters 704 in the first three spaces.

A ____ query uses functions, such as Sum and Count, to perform arithmetic operations on selected records.

Validation Rules are entered in the ____

The format field command freezes a field (column)in a datasheet so that the field stays visible when the user scrolls to the right while viewing the datasheet. ____________________

Any type of Access object may be deleted from the Tables Pane using the Delete command on the shortcut menu. ____________________

Joining two or more fields in a calculated field using an expression such as  =Title " " FirstName " " LastName is an example of concatenation . ____________________

Yes/No field values are stored in an Access database as a --1 for a checked value and a 0 for an unchecked value.

The value of a field containing no information is a ____ value.

Table Validation Rules are entered using the ____________________ for a table.

The Like comparison operator is used to select records by matching field values to a specific pattern that includes one or more of the wildcard characters (*, ?, #)in a query. ____________________

Fields and criteria that will be used in a query are contained in the ____________________ when creating a query.

Which of the following is an example of a parameter query prompt criterion?

The ____________________ button in the Sort Filter group on the Home tab is used to remove the current filter in a dataset or to reapply a filter.

Which comparison operator defines a condition with a list of two or more values for a field and includes records when the field matches one value from the list in the query results?

Crosstab queries may use which of the following aggregate functions?

Setting the ____ field property to Yes instructs Access to keep an historical record of all versions of the Long Text field value.