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

Which of the following function checks to see if a field has no value?

When two functions are not sufficient to evaluate an expression,you may need to use a(n):

If you want to see records with a field within a certain date range,you could use the Between operator.

What can you use to create an expression to calculate lapsed time?

In the criteria of a query,Access encloses date fields with & symbols.

The options for a lookup field can be stored in a separate table.

A(n)________ forces data entry into a table or form to conform to a specific format.

A(n)________ forces users to conform to a specific data entry format for a given field.

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

The user provides the criterion at run time when using a lookup list.

When entering data into a table or form,the ________ key is a required field.

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

Using the example of a hire date of October 5,2017,what would the DatePart function be for the quarter?

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

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?

For phone numbers,the input mask helps ensure consistency in data entry.

A required field is one that cannot be left blank when you create a new record.