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

How can you see relationships created with a Lookup Wizard?

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

A parameter query prompt is enclosed in parentheses.

Which data validation method forces data entry in a field?

The Date function calculates the current date.

Match the following terms with their meanings: I.data validation II.validation rule III.input mask IV.lookup field A.enables you to restrict the data being input into a field by specifying the exact format of the data entry B.restricts the data values that can be entered into a field C.provides the user with a finite list of values to choose from in a menu D.a set of constraints or rules that help control how data is entered into a field

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

Explain the difference between validation rule and validation text.

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

To ensure the integrity of records in a table,you should set the required property to Yes for critical fields.

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

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

Which of the following enables you to create mathematical functions in Access?

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

If you add a validation rule to a table with existing records,some data in those records may violate the rule.

When using the Lookup Wizard to create a lookup field,Access creates a hidden relationship between two tables-the table that contains the lookup field and the table that holds the options.

Which data validation method forces users to conform to a specific data-entry format for a given field?