Exam 5: Data Validation and Data Analysis

Which of the following is not a way to address data validation violations?

The DatePart function always returns a number.

Where would you go to set up validation fields?

If you used a lookup field for a field named State, the book recommends that you have fifty menu options available to anyone doing data entry.

The function, MonthName(DatePart("m",12/26/1959)), would give the answer ________.

What function would you use to display the word January instead of the number 1 which is what the DatePart function would display?

Which feature limits the data that is allowed to be entered into a field?

The ________ value is entered automatically when a new record is created.

The ________ function check to see if a field has had no value entered into it.

Match the following terms with their descriptions: I. Data validation II. Validation text III. Validation Rule IV. Default value V. Input Mask Wizard A. Provides custom error message when incorrect data is entered B. Value entered automatically when a record is created C. A setting that limits what values can be entered in a field D. Set of rules that help control the accuracy of data entry E. Tool used to help create consistent formatting of data

In the Round function, the precision cannot be a negative number.

The ________ function evaluates whether an expression is true or false.

Match the following terms with their descriptions: I. Input mask II. Lookup field III. Lookup Wizard IV. Parameter query V. Input Mask Wizard A. Predefined list of values presented in a menu B. Criterion is provided when query is run C. Took used to help create consistent formatting of data in a field D. Helps create a list of predefined values E. Setting that guarantees consistent formatting of data in a field

Match the following functions with when they would be used: I. Date II. DatePart III. IIf IV. Round V. IsNull A. When you need to use today's date B. When you need to display a number to four decimal places C. When you need to do one action if a condition is true and another if a condition is false D. When you need to see if a field was skipped in data entry E. When you need to use only the month within a date

To make sure that data entry personnel can only pick from existing items in a lookup field, you would check the Enable ________ Integrity check box.

Reports cannot be based on parameter queries.

To select to how many decimal places a value will display; you would use which function?

Which of the following is considered a custom error message?

Validation rules serve as warnings; they do not actually prevent invalid data entry.

Although you can type an input mask manually, it is easier to use the Input Mask ________.