Deck 8: Data Validation and Data Analysis: Hands On Exercise Videos

Question 1

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 1

B

Question 2

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

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

Answer 2

C

Question 3

The DatePart function has ________ required parameters.

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

Answer 3

B

Question 4

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

Question 5

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

Question 6

Validation rules are entered in the ________ pane.

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

Question 7

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

Question 8

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 9

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

Question 10

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

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

Question 11

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

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

Question 12

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 13

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

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

Question 14

The IIf function requires ________ parameters.

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

Question 15

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

Question 16

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

Question 17

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