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

[Enter city] on the criteria line of a query is an example of the criteria in a parameter query.

An Access expression that calculates lapsed time is called ________.

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

What does a IsNull function do?

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

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

When creating a lookup list for the State field,what must you also consider?

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

A(n)________ accepts two or more options in a lookup field.

The ________ function checks if a field does not contain a value

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.

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

After setting a required property to an existing table,what does Access do to the existing records if the field is blank?

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

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?

Instead of modifying the query grid each time a new criteria is needed,a parameter query can be created to enter the criteria.

A required field is one that cannot be left blank when you create a new record.

For phone numbers,the input mask helps ensure consistency in data entry.

________ functions refers to using one formula within another one.