Exam 5: Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

When entering data into a table or form, the ________ key is a required field.

Instead of modifying the query grid each time a new criteria is needed, a parameter query can be created to enter the criteria.

A parameter query is similar to creating most other query types.

When creating a parameter query, the text phrase should be enclosed in which of the following?

The Date function is commonly used as a default value for a date field.

Which fields in a table are required fields by definition?

When you violate a validation rule, Access allows you to continue entering the record.

If a field in a table has a ________ a drop down menu will appear in the field.

In the criteria of a query, Access encloses date fields with & symbols.

A parameter query prompt is enclosed in parentheses.

When using the Lookup Wizard to create a lookup field, Access creates a hidden relationship between two tables-the table that contains the lookup field and the table that holds the options.

For phone numbers, the input mask helps ensure consistency in data entry.

The IIf function requires ________ parameters.

________ functions refers to using one formula within another one.

You would use the ________ function to calculate the current date.

Match the following terms with their meanings: I. data validation II. validation rule III. input mask IV. lookup field A. enables you to restrict the data being input into a field by specifying the exact format of the data entry B. restricts the data values that can be entered into a field C. provides the user with a finite list of values to choose from in a menu D. a set of constraints or rules that help control how data is entered into a field

Validation rules are entered in the ________ pane.

A query where the user provides the criterion at run time is called a(n) ________ query.

The Validation Text property is used to display a message when the corresponding validation rule is not met.