Access Chapter 5 Flashcards
a query where the user provides the criterion at run time
parameter query
a set of constraints or rules that help control data entered into a field
data validation
a tool that helps you create a menu of predefined values by asking you questions and using your answers to create the options list
lookup wizard
a setting that limits that data values a user can enter into a field
validation rule
a setting that provides a custom error message to the user when incorrect data is entered
validation text
a way to provide the user with a predefined list of values to choose from in a menu
lookup field
a setting the restricts the data being input into a filed by specifying the exact format of the data entry
input mask
a way to specify what value is automatically entered into a field when a new record is added to a table
default value
a tool used to generate data restrictions for a field
input mask wizard