Exam 34: Access: Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

A(n)________ forces users to conform to a specific data entry format for a given field.

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

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

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

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

Validation text restricts the data value that can be entered into a field.

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

If you run a query and a dialog box appears asking you to enter data,it is a ________.

A parameter query prompt is enclosed in parentheses.

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

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

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

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

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

When a report has been created and used in Access,it can be formatted and laid out differently than the original design.

A field with a number of repeated values may be better suited as what kind of field?

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

When using an input mask,data is still not necessarily consistent.

Which data validation method forces users to conform to a specific data-entry format for a given field?