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 |
|
|
