Exam 6: Data Validation and Data Analysis

You can use the word Like in a data validation rule.

Storing the characters in an input mask requires more disk space,so it is not recommended.

When is the criterion entered in a parameter query?

To make sure that data entry personnel can only pick from existing items in a lookup field,you would check the Enable ________ Integrity check box.

Access allows for the creation of custom input masks.

Which of the following would not be a valid parameter query criterion?

The ________ value is entered automatically when a new record is created.

The Lookup ________ helps you create a lookup field.

When you change the lookup field's source table,the options will be updated when the user tries to change data in the future.

Which feature limits the data that is allowed to be entered into a field?

Reports cannot be based on parameter queries.

A(n)________ query relies on the user providing the criterion when the query is run.

The Date function calculates the current date.

To enable the Input Mask Wizard,you press the Build button.

The default setting for the Required field property for most fields is ________.

A(n)________ field is a predefined list of values.

When the Enable Data Integrity check box in the Lookup Field Wizard is checked ________.

A parameter query is not a type of select query.

The Input Mask ________ allows you to create a custom input mask without having to understand complicated codes.