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

A ________ rule limits the type of data a user can enter into a field.

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

When using the Lookup Wizard to create a lookup field,Access creates a hidden relationship between two tables-the table that contains the lookup field and the table that holds the options.

Assuming a hire date of 7/31/2016,which of the following would be the correct DatePart Function for the correct day of the week?

Which data validation method forces data entry in a field?

A lookup list accepts multiple values in a single field.

Validation rules limit the type or range of data a user can enter into a field.

A parameter query is similar to creating most other query types.

When using an input mask,parentheses and hyphens are automatically stored with the data.

If you want to see records with a field within a certain date range,you could use the Between operator.

________ affects the display of the date without affecting the underlying value.

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

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

When two functions are not sufficient to evaluate an expression,you may need to use a(n):

A query where the user provides the criterion at run time is called a(n)________ query.

What can you use to create an expression to calculate lapsed time?

When you violate a validation rule,Access allows you to continue entering the record.

An input mask forces users to conform to a specific data-entry format for a given field.

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