Term
|
Definition
adds records from one table to the end of another table |
|
|
Term
|
Definition
when Access allows a deletion of a record but also deletes all the related records |
|
|
Term
|
Definition
the value that Access displays in a particular field before the user begins adding a record |
|
|
Term
|
Definition
a query that will delete all the records satisfying the criteria entered in the query |
|
|
Term
|
Definition
to have only the records that satisfy a criteria appear |
|
|
Term
|
Definition
a field in one table whose values are required to match the primary key of another table |
|
|
Term
|
Definition
is created based on a field or combination of fields |
|
|
Term
|
Definition
allows users to choose from a list of values |
|
|
Term
|
Definition
one record in a table is related to, or matches, many records in a second table |
|
|
Term
|
Definition
the property that ensures that the value in a foreign key must match that of another table's primary key |
|
|
Term
|
Definition
a field in which the user MUST enter data |
|
|
Term
|
Definition
an index whose key is in a single field |
|
|
Term
|
Definition
a datasheet that appears below the plus sign of a related table |
|
|
Term
|
Definition
allows you to make changes to all records satisfying some criterion |
|
|
Term
|
Definition
rules that a user must follow when entering data |
|
|