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

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

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

The table that contains the values for a lookup field CANNOT be modified.

The default Required setting for all fields except the primary key field is Yes.

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

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

A lookup field can be used when there is repetitive data in a field.

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

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

How can you see relationships created with a Lookup Wizard?

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

Which data validation method enables you to execute programming tasks whenever data in a table is changed?

The ________ creates a menu of finite values by asking you questions and using your answers to create the options list.

(___) ___-____ is an example of a(n) ________.

Explain the difference between a lookup list and a multiple-value list.

If you want to see records with a field within a certain date range, you could use the Between operator.

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

A(n) ________ performs calculations on an entire column of data and returns a single value.

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

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