Deck 5: Data Validation and Data Analysis: Hands-On-Exercise Videos

Question 1

The ________ function is used to check whether a field contains no value.

A) IsNull
B) Concat
C) IIf
D) IsNumeric

Answer 1

A

Question 2

When most people in a database reside in New York,you should make NY the ________ value for the State field.

A) data validation rule
B) default
C) lookup field
D) input mask

Answer 2

B

Question 3

When one IIf function is used within another IIf function,they are referred to as nested IIf functions.

Answer 3

True

Question 4

You would use the ________ function to calculate the current date.

A) Now()
B) Today()
C) Present()
D) Date()

Question 5

When data is entered,a(n)________ is used to have a consistent format.

A) data macro
B) field property
C) data validation rule
D) input mask

Question 6

When creating a parameter query,the prompt is enclosed in ________.

A) parentheses ( )
B) braces { }
C) brackets [ ]
D) quotations " "

Question 7

The Validation Text property is used to display a message when the corresponding validation rule is not met.

Question 8

When creating a parameter query,you are limited to a single parameter in the Criteria row for a given field.

Question 9

When a field is designated as required,it CANNOT be left blank.

Question 10

If a validation rule is not met,you CANNOT continue until the data value meets the rule.

Question 11

Validation rules are entered in the ________ pane.

A) Field Properties
B) Validation
C) Rules
D) Data macro

Question 12

The table that contains the values for a lookup field CANNOT be modified.

Question 13

The DatePart function has ________ required parameters.

A) 1
B) 2
C) 3
D) 4

Question 14

A(n)________ allows the user to select a field value from a list of options.

A) input mask
B) lookup field
C) field property
D) data macro

Question 15

When a field is required,it must have a default value.

Question 16

Using the Round function with only one parameter rounds the numerical value of the parameter to the nearest ________.

A) whole number
B) tenth
C) hundredth
D) thousandth

Question 17

(___)___-____ is an example of a(n)________.

A) data validation rule
B) default value
C) input mask
D) lookup field

Question 18

The IIf function requires ________ parameters.

A) 0
B) 1
C) 2
D) 3