Question 1

Validation ________ helps the data entry person know why the entry is being rejected.

Accepted Answer

The answer of Validation ________ helps the data entry person...

Question 2

You can restrict the data type that will be accepted in a parameter query by ________.

Accepted Answer

A)  limiting the number of parameters in a query 
B)  choosing a data type for each parameter 
C)  choosing the field for the parameter query carefully 
D)  You cannot restrict what a user enters in a parameter query.

Question 3

What is not a reason for avoiding making the state field a two-character lookup field?

Accepted Answer

A)  You might miss states that have more than one abbreviation. 
B)  You might miss areas like the District of Columbia. 
C)  You might miss other countries with two letter abbreviations recognized by the post office. 
D)  You might miss abbreviations for military areas.

Question 4

Which of the following provides for uniformity and consistency of data?

Accepted Answer

A)  Lookup field 
B)  Cell validation 
C)  Field validation 
D)  One-to-One relationships

Question 5

Which of the following is not true about the Date function?

Accepted Answer

A)  Access updates it every time the system date changes. 
B)  It requires no arguments. 
C)  It takes the form Date(Now) 
D)  It can be entered directly in a field row of a query.

Question 6

If you wanted a parameter query to prompt for a partial value, you can use the ________ operator.

Accepted Answer

The answer of If you wanted a parameter query to...

Question 7

You can use the word Like in a data validation rule.

Accepted Answer

A) True 
 B)False

Question 8

Which of the following features helps to ensure that improper information is not entered in a field?

Accepted Answer

A)  Cell validation 
B)  Data validation 
C)  Field validation 
D)  AutoCorrect Data

Question 9

Data validation is a ________.

Accepted Answer

A)  set of rules or constraints 
B)  set of formatting codes 
C)  set of masking characters 
D)  set of drop down options

Question 10

Match the following types of data with the appropriate input masks:
I. Phone number
II. Long Time
III. Zip Code
IV. Short Time
V. Social Security Number
A. 00:00
B. 000-00-0000
C. 00000-9999
D. !(999) 000-0000
E. 99:00:00 >LL

Accepted Answer

The answer of Match the following types of data with...

Question 11

When you change the lookup field's source table, the options will be updated when the user tries to change data in the future.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A)  Int 
B)  Decimal 
C)  Round 
D)  Currency

Question 13

A(n) ________ query relies on the user providing the criterion when the query is run.

Accepted Answer

The answer of A(n) ________ query relies on the user...

Question 14

Which of the following data types cannot have an input mask applied?

Accepted Answer

A)  Number 
B)  Long Text 
C)  Short Text 
D)  Date/Time

Question 15

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

Accepted Answer

A)  NameMonth(1) 
B)  MonthName(1) 
C)  Month(1) 
D)  MonthName(January)

Question 16

When using the Lookup Field Wizard, how wide should the columns be?

Accepted Answer

A)  You cannot adjust the column width from the wizard. 
B)  Up to the maximum width of the field 
C)  To display neatly on the screen 
D)  To display the longest value

Question 17

Data ________ is the process of controlling the data that is entered into a field.

Accepted Answer

The answer of Data ________ is the process of controlling...

Question 18

In the Round function, if you leave the precision level blank, Access will default to how many decimal places?

Accepted Answer

A)  0 
B)  1 
C)  2 
D)  You cannot leave the precision level argument blank.

Question 19

Between [Enter Start Date] And [Enter End Date] is a valid statement to use in a parameter query.

Accepted Answer

A) True 
 B)False

Question 20

In a parameter query, if you do not specify a comparison operator, Access will assume equal to.

Accepted Answer

A) True 
 B)False

Exam 6: Data Validation and Data Analysis

Validation ________ helps the data entry person know why the entry is being rejected.

You can restrict the data type that will be accepted in a parameter query by ________.

What is not a reason for avoiding making the state field a two-character lookup field?

Which of the following provides for uniformity and consistency of data?

Which of the following is not true about the Date function?

If you wanted a parameter query to prompt for a partial value, you can use the ________ operator.

You can use the word Like in a data validation rule.

Which of the following features helps to ensure that improper information is not entered in a field?

Data validation is a ________.

Match the following types of data with the appropriate input masks: I. Phone number II. Long Time III. Zip Code IV. Short Time V. Social Security Number A. 00:00 B. 000-00-0000 C. 00000-9999 D. !(999) 000-0000 E. 99:00:00 >LL

When you change the lookup field's source table, the options will be updated when the user tries to change data in the future.

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

A(n) ________ query relies on the user providing the criterion when the query is run.

Which of the following data types cannot have an input mask applied?

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

When using the Lookup Field Wizard, how wide should the columns be?

Data ________ is the process of controlling the data that is entered into a field.

In the Round function, if you leave the precision level blank, Access will default to how many decimal places?

Between [Enter Start Date] And [Enter End Date] is a valid statement to use in a parameter query.

In a parameter query, if you do not specify a comparison operator, Access will assume equal to.