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

In the criteria of a query,Access encloses date fields with & symbols.

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

Which data validation method provides an error message when a validation rule has been broken?

A required field indicates that a value for the field must be entered.

How can you see relationships created with a Lookup Wizard?

A lookup field can be used when there is repetitive data in a field.

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

If a field in a table has a ________ a drop down menu will appear in the field.

When entering data into a table or form,the ________ key is a required field.

The Date function is commonly used as a default value for a date field.

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

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

________ is the correct syntax for the Round function.

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

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

The default Required setting for all fields except the primary key field is Yes.

Which of the following forces you to enter the phone number in a consistent manner in the database table?

Explain the difference between validation rule and validation text.

Validation rules prevent invalid data from being entered into a field.

The ________ function evaluates an expression and displays one value when the expression is true and another when the expression is false.