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

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

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

________ enable you to execute programming tasks whenever data in a table is changed.

When creating a parameter query, the prompt is enclosed in ________.

The Access feature that helps you to keep track of parameter queries ________.

Validation text restricts the data value that can be entered into a field.

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

The data validation method that causes fields to be limited to predefined list of values is a:

If you run a query and a dialog box appears asking you to enter data, it is a ________.

________ is similar to a validation rule except the logic is more complex and the actions taken are more powerful when table data is changed.

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

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

By creating an input mask you can further restrict the data being input into a field by specifying the exact format of the data entry.

When there is more than one parameter in a query, Access asks for the information starting from the left and moving to the right.

The ________ function returns a number rounded to a specific number of decimal places.

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?

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

Using the Round function with only one parameter rounds the numerical value of the parameter to the nearest ________.

A(n) ________ is a set of constraints or rules that help control how data is entered into a field.