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

A parameter query prompt is enclosed in parentheses.

When entering data into a table or form,the ________ key is a required field.

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

The Date function calculates the current date.

If a field in a table has a ________ a drop down menu will appear in the field.

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

Using the example of a hire date of October 5,2017,what would the DatePart function be for the quarter?

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

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

The ________ function evaluates an expression and displays one value when the expression is true and another when the expression is false.

Assuming a hire date of February 15,2017,which of the following date part functions would return the number of days since the beginning of the current year?

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

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

Which data validation method provides an error message when a validation rule has been broken?

The options for a lookup field can be stored in a separate table.

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

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

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

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

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