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

Why is it easier to create a parameter query instead of multiple queries using the same field?

What are the three options that need to be filled in for an IIF function to give correct results?

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

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

The Date function calculates the current date.

The user provides the criterion at run time when using a lookup list.

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

A(n)________ forces data entry into a table or form to conform to a specific format.

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

When you use the ________ operator,each criterion must be true for the compound criterion to be true.

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

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

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

In Access,there are several ________ methods to help minimize data entry errors into tables and forms.

Why would you set a default value for a field?

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

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

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

Which fields in a table are required fields by definition?

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