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

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

When creating a lookup list for the State field,what must you also consider?

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

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

________ functions refers to using one formula within another one.

When using an input mask,parentheses and hyphens are automatically stored with the data.

A lookup list accepts multiple values in a single field.

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

Which fields in a table are required fields by definition?

Which of the following function checks to see if a field has no value?

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.

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

An Access expression that calculates lapsed time is called ________.

A(n)________ accepts two or more options in a lookup field.

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

For phone numbers,the input mask helps ensure consistency in data entry.

A required field can be left blank when entering a record.

When two functions are not sufficient to evaluate an expression,you may need to use a(n):

________ is similar to a validation rule except the logic is more complex and the actions taken are more powerful when table data is changed.