Question 1

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 2

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 3

The Lookup ________ creates the menu of predefined values (lookup fields) by asking you questions and using your answers to create the options list.

Accepted Answer

The answer of The Lookup ________ creates the menu of...

Question 4

Match the following with where they are found:
I. Parameters
II. Run (a query)
III. Criteria (in a query)
IV. Input Mask
V. Validation Text
A. Table Tools tab; Design tab; Field Properties; Input Mask row
B. Query Tools tab; Design tab; Show/Hide group
C. Table Tools tab; Design tab; Field Properties; Validation Text row
D. Query Tools tab; Design tab; Criteria row
E. Query Tools tab; Design tab; Results group

Accepted Answer

The answer of Match the following with where they are...

Question 5

Match the following terms with their descriptions:
i. Date function
II. Round function
III. DatePart function
IV. IIf function
v. IsNull function

Accepted Answer

The answer of Match the following terms with their descriptions:
i....

Question 6

The ________ function evaluates whether an expression is true or false.

Accepted Answer

The answer of The ________ function evaluates whether an expression...

Question 7

Match the following results with the proper formulas:
I. January
II. Wednesday
III. December
IV. Saturday
V. 1
A. =MonthName(1)
B. =WeekdayName(4)
C. =MonthName(12)
D. =WeekdayName(7)
E. =DatePart("m",#01/16/1959#)

Accepted Answer

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

Question 8

The ________ function check to see if a field has had no value entered into it.

Accepted Answer

The answer of The ________ function check to see if...

Question 9

Match the following terms with their descriptions:
I. Data validation
II. Validation text
III. Validation Rule
IV. Default value
V. Input Mask Wizard
A. Provides custom error message when incorrect data is entered
B. Value entered automatically when a record is created
C. A setting that limits what values can be entered in a field
D. Set of rules that help control the accuracy of data entry
E. Tool used to help create consistent formatting of data

Accepted Answer

The answer of Match the following terms with their descriptions:
I....

Question 10

Match the following functions with when they would be used:
i. Date
II. DatePart
III. IIf
IV. Round
v. IsNull

Accepted Answer

The answer of Match the following functions with when they...

Question 11

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 12

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 13

Match the following terms with their descriptions:
I. Input mask
II. Lookup field
III. Lookup Wizard
IV. Parameter query
V. Input Mask Wizard
A. Predefined list of values presented in a menu
B. Criterion is provided when query is run
C. Took used to help create consistent formatting of data in a field
D. Helps create a list of predefined values
E. Setting that guarantees consistent formatting of data in a field

Accepted Answer

The answer of Match the following terms with their descriptions:
I....

Question 14

Match the following results with the proper comparison operators: I. Does not equal 5000 II. Is less than 5000 III. Is less than or equal to 5000 IV. Is greater than 5000 V. Is greater than or equal to 5000 A. <5000 B. <=5000 C. >=5000 D. >5000 E. <>5000

Accepted Answer

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

Question 15

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 16

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...

Quiz 6: Data Validation and Data Analysis

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

The Lookup ________ creates the menu of predefined values (lookup fields) by asking you questions and using your answers to create the options list.

Match the following terms with their descriptions: i. Date function II. Round function III. DatePart function IV. IIf function v. IsNull function

The ________ function evaluates whether an expression is true or false.

Match the following results with the proper formulas: I. January II. Wednesday III. December IV. Saturday V. 1 A. =MonthName(1) B. =WeekdayName(4) C. =MonthName(12) D. =WeekdayName(7) E. =DatePart("m",#01/16/1959#)

The ________ function check to see if a field has had no value entered into it.

Match the following functions with when they would be used: i. Date II. DatePart III. IIf IV. Round v. IsNull

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

Match the following results with the proper comparison operators: I. Does not equal 5000 II. Is less than 5000 III. Is less than or equal to 5000 IV. Is greater than 5000 V. Is greater than or equal to 5000 A. <5000 B. <=5000 C. >=5000 D. >5000 E. <>5000

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

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