Exam 6: Data Validation and Data Analysis

A(n)________ mask specifies the exact formatting of data entry.

The Required field property only applies to new data,not to existing data.

The Lookup ________ creates the menu of predefined values (lookup fields)by asking you questions and using your answers to create the options list.

You do not have to set the Required field property for AutoNumber fields.

If you wanted to display the day of the week using the DatePart function,you would put ________ in the interval argument.

Which of the following functions required no arguments?

If you wanted a parameter query to prompt for a partial value,you can use the ________ operator.

Data validation is a ________.

You can restrict the data type that will be accepted in a parameter query by ________.

Which of the following is not true about a parameter query?

Data ________ is the process of controlling the data that is entered into a field.

What is a predefined list of values?

In the Round function,if you leave the precision level blank,Access will default to how many decimal places?

Which of the following features helps to ensure that improper information is not entered in a field?

To display the minute portion of a date,what would you put in the interval argument in the DatePart function?

A(n)________ rule limits the values that can be entered in a field.

A field with a limited number of values is well suited for what type of field?

The default setting for the Required field property for most fields is "Yes".