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

When you use the ________ operator,each criterion must be true for the compound criterion to be true.

________ functions refers to using one formula within another one.

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

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

Validation rules limit the type or range of data a user can enter into a field.

Why is it easier to create a parameter query instead of multiple queries using the same field?

An Access expression that calculates lapsed time is called ________.

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

When using an input mask,data is still not necessarily consistent.

A query where the user provides the criterion at run time is called a(n)________ query.

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

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

When creating a lookup list for the State field,what must you also consider?