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

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

A lookup list accepts multiple values in a single field.

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

Reports can be created based on the results of a parameter query.

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

The ________ function checks if a field does not contain a value

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

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

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

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

Which data validation property specifies a value that is automatically entered into a field?

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

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

A Multivalued Lookup field accepts numerous options instead of just one field choice.

The ________ Wizard restricts how data is entered into a field.