Queries
Validation Rules
Back up & Recovery
Format
Filter & Fields
100
allows you to delete all the records satisfying some criterion
What is Delete query
100
-field in which a user actually must enter data
What is Required field
100
copying this the backup copy over the actual database
What is Live database
100
affects the way the data appears
What is Format
100
one the record or records that satisfy the criterion appear
What is Filter
200
add the results to a new table
What is Make-table query
200
rules that a user must follow when entering the data
What is Validation rules
200
returning the database to the correct state
What is Recover
200
design of a table
What is Layout
200
field in which a user actually must enter data
What is Required field
300
add the results of a query to an existing table
What is Append query
300
validation rules can make sure a users entry lies
What is Range of values
300
periodically making a copy of the database
What is Backing up
300
changing the size
What is Resizing
300
an example of the data you want by selecting the data within the table
What is Filter by Selection
400
adds, deletes, or changes data in a table
What is Action query
400
the message that will appear if a user violates the validation rule
What is Validation text
400
allows you to find duplicate records
What is Duplicates Query Wizard
400
a special symbol
What is Format symbol
400
restricts the records that appear
What is Filter by Form
500
allows you to make the same change to all records
What is Update query
500
a value that access will display on the screen in a particular field before the user begins adding a record
What is Default value
500
allows you to find the unmatched records
What is Find Unmatched Query Wizard
500
assign names and types to all the fields
What is Structure
500
allows the user to select from a list of values
What is Lookup field
M
e
n
u