Access Chapter 2
When entering, deleting, or editing table data:
The table must be in Datasheet view.
A row in the query design grid that determines which records will be selected.
g. criteria row
An illustration of a one-to-many relationship would be:
a customer may have more than one account in accounts table
Returns only records that meet all criteria.
a. "and" logical operator
A number that automatically increments each time a new record is added.
b. AutoNumber
Used to create a more readable label that displays in the top row in Datasheet view and in forms and reports.
c. Caption property
an option to direct Access to automatically update all foreign key values in a related table when a primary key value is modified in a primary table
e. Cascade update related fields
Which of the following determines the amount of space a field uses in a database?
field size
The unnecessary storing of duplicate data in two or more tables.
h. data redundancy
Determines the type of data that can be entered and the operations that can be performed on that data.
i. data type
Characteristic of a field that determines how it looks and behaves
j. field properties
A field in one table that is also the primary key of another table
k. foreign key
Simplifies data entry by providing literal characters that are typed for every entry
l. input mask
The main reason to set a validation rule in Access is
limit the entry of incorrect values into the table
Connects two tables together by their common field in the Relationships window
m. join line
When the primary key value in the primary table can match many of the foreign key values in a related table
n. one-to-many relationship
Which of the following is true for the query wizard?
no criteria can be added as you step through the wizard
Returns records meeting any of the specified criteria.
o. "or" logical operator
Enables you to ask questions about the data stored in a database and provide answers to the questions in a datasheet.
p. query
It is more efficient to make a copy of an existing query rather than create a new query when which of the following is true?
the existing query and new query use the same tables and fields.
Rules in a database that are used to preserve relationships between tables when records are added, deleted or changed.
q. referential integrity
checks the data for allowable value when the user exits the field
s. validation rule
Use greater than (>), less than (<), greater than or equal to (>=) or less than or equal to (<=) to limit query results that meet these criterion.
f. comparison operators
Provides a step-by-step guide to help you through the query design process
r. simple query wizard
Special character that can represent one or more characters in the criterion of a query.
t. wildcards
When the primary key value is deleted in a primary table, Access will automatically delete all foreign key values in a related table
d. Cascade delete related records
