| A | B |
| Application Parts | A gallery that you can use to insert predefined templates consisting of objects like tables, forms, and reports into a preexisting database. |
| 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, such as Z to A or 99 to 0. |
| 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. |
| Quick Start | A collection of predefined objects that you can add to your database arranged by parts for tracking things such as comments, contacts, and issues. |
| referential integrity | A rule that prevents orphaned records. |
| sort | To arrange data alphabetically, numerically, or chronologically. |
| template | A ready-to-use database that contains all of the tables, queries, forms, and reports needed for performing a specific task. |
| wildcard | Characters used to find words or phrases that contain specific letters or combinations of letters. |