Question 1

How will the parameter query request display when the query is run?

Accepted Answer

A) Pop-up message 
B) Status Bar message 
C) Pop-up menu of options 
D) Help message box

Question 2

Match between columns
                        Premises: Lookup field
Lookup Wizard
Input Mask Wizard
Input mask
Parameter query

Accepted Answer

The Answer of Predefined list of values presented in a is...

Question 3

Access automatically validates some data entry.

Accepted Answer

A) True 
 B)False

Question 4

Which of the following is not a way to address data validation violations?

Accepted Answer

A) Press the "Allow This Exception" button and keep going. 
B) Correct the data. 
C) Cancel the record entry. 
D) Change the data validation rule.

Question 5

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 6

Which of the following is considered a custom error message?

Accepted Answer

A) Caption text 
B) Required text 
C) Default text 
D) Validation text

Question 7

Which of the following is not affected by inconsistent data?

Accepted Answer

A) Sorting 
B) Filtering 
C) Queries 
D) File size

Question 8

Which of the following functions evaluates whether a value has been entered into a field?

Accepted Answer

A) IsEmpty 
B) IsVoid 
C) IsNull 
D) Null

Question 9

Match between columns
                        Premises: Long Time
Zip Code
Short Time
Phone number
Social Security Number

Accepted Answer

The Answer of !(999)000-0000 and 99:00:00 >LL and 00000-9999 and is...

Question 10

If you used a lookup field for a field named State,the book recommends that you have fifty menu options available to anyone doing data entry.

Accepted Answer

A) True 
 B)False

Question 11

The ________ function calculates the current date.

Accepted Answer

The answer of The ________ function calculates the current date....

Question 12

Match between columns
                        Premises: IsNull function
Round function
Date function
IIf function
DatePart function

Accepted Answer

The Answer of Evaluates a comparison as correct or incorrect is...

Question 13

Input masks can restrict the number of characters allowed in a field.

Accepted Answer

A) True 
 B)False

Question 14

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 15

Which of the following is often not true about tables used to supply data in a lookup field?

Accepted Answer

A) It has no relationship set up. 
B) It has no primary key. 
C) It may just have one field. 
D) It is locked so no additional entries can be made.

Question 16

Tables are a good source for data in a lookup field.

Accepted Answer

A) True 
 B)False

Question 17

To create a parameter query,you would put the desired text in parenthesis in the criterion row of the desired field.

Accepted Answer

A) True 
 B)False

Question 18

The Date function is entered as Date().

Accepted Answer

A) True 
 B)False

Question 19

The function,MonthName(DatePart("m",12/26/1959)),would give the answer ________.

Accepted Answer

The answer of The function,MonthName(DatePart("m",12/26/1959)),would give the answer ________....

Question 20

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)

Exam 6: Data Validation and Data Analysis

How will the parameter query request display when the query is run?

Match the following terms with their descriptions:

Access automatically validates some data entry.

Which of the following is not a way to address data validation violations?

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

Which of the following is considered a custom error message?

Which of the following is not affected by inconsistent data?

Which of the following functions evaluates whether a value has been entered into a field?

Match the following types of data with the appropriate input masks:

If you used a lookup field for a field named State,the book recommends that you have fifty menu options available to anyone doing data entry.

The ________ function calculates the current date.

Match the following terms with their descriptions:

Input masks can restrict the number of characters allowed in a field.

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

Which of the following is often not true about tables used to supply data in a lookup field?

Tables are a good source for data in a lookup field.

To create a parameter query,you would put the desired text in parenthesis in the criterion row of the desired field.

The Date function is entered as Date().

The function,MonthName(DatePart("m",12/26/1959)),would give the answer ________.

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