| A | B |
|---|
| Relationship | Database Tools ribbon defines how data in database tables are correlated |
| Linking | option allows data to remain connected to its original source |
| Tabular Layout | layout arranges controls horizontally with the labels across the top of the con |
| Stacked Layout | layout arranges controls vertically with labels to the left of the control |
| Control Layout | name of the set of controls grouped together so they can be manipulated as a single unit |
| Subdatasheet | datasheet appears within related tables |
| One to Many | type of relationship means that a record in the first table is related or matches more than one record in the second table |
| Referential Integrity | property ensures that the value of a foreign key must match that of another table's primary key |
| Default Value | displays in a particular field on screen before a user begins adding a record |
| Validation | rules that a user must follow when entering data into a table |
| Delimited | type of file is created so that each record is on a separate line and the fields are separated by a special character |
| Outer | type of join displays all records from one table and the common records from another table |
| Inner | join that finds records from two tables with identical values in matching fields |
| Flat | collection of data that is NOT related to any other collection of data |
| Join | must be done to include multiple tables that contain identical values in matching fields |
| Exporting | copying data from an Access database for use in another application program |
