Question 1

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

Accepted Answer

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

Question 2

If you wanted to display the day of the week using the DatePart function,you would put ________ in the interval argument.

Accepted Answer

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

Question 3

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 4

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 5

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 6

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 7

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 8

Match between columns
                        Premises: January
December
1
Saturday
Wednesday

Accepted Answer

The Answer of =WeekdayName(7) and =DatePart("m",#01/16/1959#) and =WeekdayName(4) and =MonthName(1) is...

Question 9

Match between columns
                        Premises: 10
26
7
1959
12

Accepted Answer

The Answer of =DatePart("h",[BirthDate]) and =DatePart("d",[BirthDate]) and =DatePart("w",[BirthDate]) and =DatePart("m",[BirthDate]) is...

Question 10

Match between columns
                        Premises: "h"
"w"
"n"
"m"
"yyyy"

Accepted Answer

The Answer of Year and Minute and Month and Day is...

Question 11

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 12

Match between columns
                        Premises: Is greater than 5000
Is less than or equal to 5000
Does not equal 5000
Is greater than or equal to 5000
Is less than 5000

Accepted Answer

The Answer of <5000 and >=5000 and <>5000 and >5000 is...

Question 13

Match between columns
                        Premises: Validation Text
Run (a query)
Parameters
Criteria (in a query)
Input Mask

Accepted Answer

The Answer of Query Tools tab; Design tab; Show/Hide group is...

Question 14

Match between columns
                        Premises: IIf
IsNull
Round
DatePart
Date

Accepted Answer

The Answer of When you need to do one action is...

Question 15

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 16

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 17

Match between columns
                        Premises: Default value
Input Mask Wizard
Validation Rule
Validation text
Data validation

Accepted Answer

The Answer of Tool used to help create consistent formatting is...

Quiz 6: Data Validation and Data Analysis

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

If you wanted to display the day of the week using the DatePart function,you would put ________ in the interval argument.

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

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

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

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

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 results with the proper formulas:

Match the following results with the proper DatePart formulas (assume a BirthDate of December 26,1959 at 10:30 AM):

Match the following DatePart arguments with the data they would return:

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

Match the following results with the proper comparison operators:

Match the following with where they are found:

Match the following functions with when they would be used:

Match the following terms with their descriptions:

Match the following terms with their descriptions:

Match the following terms with their descriptions: