Exam 6: Data Validation and Data Analysis

Which of the following is often not true about tables used to supply data in a lookup field?

The Input Mask ________ allows you to create a custom input mask without having to understand complicated codes.

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

A parameter query is not a type of select query.

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

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

The ________ function evaluates whether an expression is true or false.

The Lookup ________ helps you create a lookup field.

The function, MonthName(DatePart("m",12/26/1959)), would give the answer ________.

When the Enable Data Integrity check box in the Lookup Field Wizard is checked ________.

If you wanted to display just the month in a date, you would use the ________ function.

If you used a lookup field for a field named State, the book recommends that you have fifty menu options available to anyone doing data entry.

Which of the following comparative operators cannot be used in a data validation rule?

How will the parameter query request display when the query is run?

An input mask is used to consistently format data.

The ________ function check to see if a field has had no value entered into it.

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

Which of the following is not true about validation text?

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

What is a primary reason for setting up a default value?