Question 1

Which of the following input masks would produce the following formatting: the letters AC followed by a plus sign following by four required numbers?

Accepted Answer

A)  AC+0000 
B)  "AC+"0000 
C)  "AC+"9999 
D)  AC+9999

Question 2

Which of the following is not true about validation text?

Accepted Answer

A)  It displays when a data violation has occurred. 
B)  It displays anytime a field is entered to aid in data entry. 
C)  It provides feedback on what was wrong with the data. 
D)  It is considered a custom error message.

Question 3

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 4

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 5

You cannot change the Required field property after data has been entered.

Accepted Answer

A) True 
 B)False

Question 6

Match the following results with the proper DatePart formulas (assume a BirthDate of December 26, 1959 at 10:30 AM):
I. 1959
II. 12
III. 26
IV. 7
V. 10
A. =DatePart("h",[BirthDate])
B. =DatePart("w",[BirthDate])
C. =DatePart("d",[BirthDate])
D. =DatePart("m",[BirthDate])
E. =DatePart("yyyy",[BirthDate])

Accepted Answer

The answer of Match the following results with the proper...

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

When is validation text displayed?

Accepted Answer

A)  Whenever a field with a validation rule applied is entered 
B)  Each time there is not a validation rule violation 
C)  When a validation rule violation occurs 
D)  If the user presses F1 during data entry

Question 9

To define how many decimal places should display, you can use the ________ function.

Accepted Answer

The answer of To define how many decimal places should...

Question 10

The default setting for the Required field property for most fields is ________.

Accepted Answer

The answer of The default setting for the Required field...

Question 11

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 12

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 13

If you wanted to display just the month in a date, you would use the ________ function.

Accepted Answer

The answer of If you wanted to display just the...

Question 14

Match the following DatePart arguments with the data they would return:
I. "yyyy"
II. "n"
III. "h"
IV. "m"
V. "w"
A. Minute
B. Month
C. Year
D. Day of the Week
E. Hour

Accepted Answer

The answer of Match the following DatePart arguments with the...

Question 15

A field with a limited number of values is well suited for what type of field?

Accepted Answer

A)  Short Text 
B)  Calculated field 
C)  Lookup field 
D)  Hyperlink

Exam 5: Data Validation and Data Analysis

Which of the following input masks would produce the following formatting: the letters AC followed by a plus sign following by four required numbers?

Which of the following is not true about validation text?

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

Data validation is a ________.

You cannot change the Required field property after data has been entered.

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

When is validation text displayed?

To define how many decimal places should display, you can use the ________ function.

The default setting for the Required field property for most fields is ________.

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

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

If you wanted to display just the month in a date, you would use the ________ function.

Match the following DatePart arguments with the data they would return: I. "yyyy" II. "n" III. "h" IV. "m" V. "w" A. Minute B. Month C. Year D. Day of the Week E. Hour

A field with a limited number of values is well suited for what type of field?