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

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?

A required field can be left blank when entering a record.

A field with a number of repeated values may be better suited as what kind of field?

Which data validation method enables you to execute programming tasks whenever data in a table is changed?

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

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

In Access,there are several ________ methods to help minimize data entry errors into tables and forms.

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

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