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

A(n)________ helps to reduce editing time when there is a common value in a field.

The data validation method that causes fields to be limited to predefined list of values is a:

________ function checks to see if a field does not contain a value.

What data validation method is designed to restrict the data values entered into a field?

Like any other field,a calculated field using DatePart can have criteria applied to it.

An input mask can be used when there is a common value in many records.

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

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

An Access function that examines a date and returns a portion of the date is:

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

A required field indicates that a value for the field must be entered.

Why would you set a default value for a field?

Which fields in a table are required fields by definition?

By creating an input mask you can further restrict the data being input into a field by specifying the exact format of the data entry.

Validation rules prevent invalid data from being entered into a field.