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

When building a table, you can set up a(n) ________ to restrict the data values that the user can enter into a field.

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

If a validation rule is not met, you CANNOT continue until the data value meets the rule.

Match the following terms with their meanings: I. Round function II. IsNull function III. IIF function IV. Nesting functions A. using one function within another function B. returns a number rounded to a specific number of decimal places C. checks whether a field has no value D. evaluates an expression and displays one value when the expression is true and another value if the expression is false

A(n) ________ rule limits the type of data a user can enter into a field.

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

A field that cannot be left blank when you create a new record is a:

When using an input mask, parentheses and hyphens are automatically stored with the data.

Explain the difference between validation rule and validation text.

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

An Access function that examines a date and returns a portion of the date is:

When most people in a database reside in New York, you should make NY the ________ value for the State field.

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

The ________ function checks if a field does not contain a value

The ________ function is used to check whether a field contains no value.

When a field is designated as required, it CANNOT be left blank.

A lookup list accepts multiple values in a single field.

A(n) ________ sets the property of a field to force data entry.

When a report has been created and used in Access, it can be formatted and laid out differently than the original design.

Match the following terms with their meanings: I. Date arithmetic II. Date formatting III. Date function IV. DatePart function A. affects the date's display without changing the actual underlying value in the table B. an Access function that examines a date and returns a portion of the date C. used to create expressions to calculate lapsed time D. calculates the current date