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

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

[Enter city] on the criteria line of a query is an example of the criteria in a parameter query.

Which of the following forces you to enter the phone number in a consistent manner in the database table?

A required field is one that cannot be left blank when you create a new record.

A ________ rule limits the type of data a user can enter into a field.

The Access feature that helps you to keep track of parameter queries ________.

To ensure the integrity of records in a table,you should set the required property to Yes for critical fields.

________ is the first method for controlling data input in a field of a table.

If you add a validation rule to a table with existing records,some data in those records may violate the rule.

When you use the ________ operator,each criterion must be true for the compound criterion to be true.

What is the purpose of adding an input mask to a field?

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.

Which of the following enables you to create mathematical functions in Access?

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

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

A(n)________ forces data entry into a table or form to conform to a specific format.

A(n)________ sets the property of a field to force data entry.

When building a table,you can set up a(n)________ to restrict the data values that the user can enter into a field.

A field that cannot be left blank when you create a new record is a: