| A | B |
| Ascending | A sort order that sorts data from beginning to end. |
| Composite Key | Two or more primary keys used in a table. |
| Descending | A sort order that sorts data from the end to the beginning |
| Filter | A set of rules for determining which records will be displayed. |
| Foreign key | A primary key from one table that is used in another table. |
| Innermost Field | A secondary sort field in a multifield sort. |
| Outermost Field | The primary sort field in a multifield sort. |
| Referential Integrity | A rule that prevents orphaned records. |
| Sort | To arrange data alphabetically |
| Wildcard | Characters used to find words or phrases that contain specific letters or combinations of letters. |