Access - Ch 5

Question 1

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

Answer 1

Data Validation

Question 2

Specifies a value that is automatically entered into a field when a new record is added

Answer 2

Default Value

Question 3

Limits the data values a user can enter into a field

Answer 3

Validation Rule

Question 4

Provides a custom error message when user enters incorrect data into field

Answer 4

Validation Text

Question 5

Restricts data being put into a field by specifying the exact format of the data entry

Answer 5

Input Mask

Question 6

Used to generate data restrictions for a field

Answer 6

Input Mask Wizard

Question 7

Provides the user with a predefined list of values to choose from in a menu (drop down)

Answer 7

Lookup Field

Question 8

Creates the menu of predefined values by asking you questions and using the answers to create an options list

Answer 8

Lookup Wizard

Question 9

User provides the criterion at run time; enables you to create a generic query and generate results based on user’s response

Answer 9

Parameter Query