Access Ch. 5

Question 0

Validation Rule

Answer 0

Designed to restrict the data values that can be entered into a field

Question 1

Data Validation

Answer 1

Set of constraints or rules that help control how data is entered into a field

Question 2

Input Mask

Answer 2

Used to restrict the data being input into a field by specifying the exact format of the data entry

Question 3

Input Mask Wizard

Answer 3

Generates data restrictions for field based on responses to a few questions

Question 4

Lookup Field

Answer 4

Provides user with a finite list of values to choose from in a menu

Question 5

Parameter Query

Answer 5

A select query where the user provides the criterion at run time

Question 6

IsNull Function

Answer 6

Checks whether a field has no value

Question 7

IIf Function

Answer 7

Evaluates an expression and displays one value when the expression is true and another value when the expression is false

Question 8

Nesting Functions

Answer 8

Using one function within another function

Question 9

Date Formatting

Answer 9

Affects the date’s display without changing the actual underlying value in the table

Question 10

Date Arithmetic

Answer 10

Creates expressions to calculate lapsed time

Question 11

DatePart Function

Answer 11

Examines a date and returns a portion of the date