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

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

The data validation method that causes fields to be limited to predefined list of values is a:

A parameter query is similar to creating most other query types.

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

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

Assuming a hire date of 7/31/2016,which of the following would be the correct DatePart Function for the correct day of the week?

After setting a required property to an existing table,what does Access do to the existing records if the field is blank?

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

When creating a parameter query,the text phrase should be enclosed in which of the following?

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

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

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

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

Why would you set a default value for a field?

Explain the difference between validation rule and validation text.

________ is the correct syntax for the Round function.

Which data validation method forces data entry in a field?

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

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

When you violate a validation rule,Access allows you to continue entering the record.