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

A(n)________ forces users to conform to a specific data entry format for a given field.

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

A Multivalued Lookup field accepts numerous options instead of just one field choice.

A(n)________ property sets the property of a field to force 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.

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

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

When creating a lookup field,it is important to only allow options from the lookup table.

________ function checks to see if a field does not contain a value.

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

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

How can you see relationships created with a Lookup Wizard?

You can use Date()in the default value property to insert the current date when a new record is added.

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

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

What are the three options that need to be filled in for an IIF function to give correct results?

What does a IsNull function do?

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

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