| 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. |
| Change Help Location Menu | A menu that enables you to choose between searching help topics online and help topics offline. |
| Composite Key | Two or more primary keys used in a table. |
| Data Type | The kind of information a field contains—whether text, number, date/time, or some other type. |
| Database | A tool for collecting and organizing information. |
| Datasheet | A visual representation of the data contained in a table or of the results returned by a query. |
| Descending | A sort order that sorts data from the end to the beginning, such as Z to A or 99 to 0. |
| Dialog Box Launcher | A small arrow in the lower-right corner of a group that you click to launch a dialog box. |
| Field | A column in a database table. |
| 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. |
| Form | A database object that simplifies the process of entering, editing, and displaying data.” |
| Groups | Collections of records separated visually and displayed with its introductory or summary information. |
| Innermost Field | A secondary sort field in a multifield sort. |
| Keytip | Small letters and numbers that display on the Ribbon when you press Alt; used for executing commands with the keyboard. |
| Normal Forms | The standards and guidelines of database design that can be used to determine if a database is structured correctly. |
| Normalization | The process of applying rules to a database design to ensure that information is divided into the appropriate tables. |
| Objects | Database elements, such as tables, queries, forms, and reports. |
| Outermost Field | The primary sort field in a multifield sort. |
| Primary Key | The column in a database that uniquely identifies each row. |
| Query | A database object that enables stored data to be searched and retrieved. |
| 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. |
| Record | A row in a database table. |
| Redundant Data | Duplicate information in a database. |
| Referential Integrity | A rule that prevents orphaned records. |
| Relational Database | A group of database tables that is connected or linked by a defined relationship that ties the information together. |
| Report | A database object that presents information in a format that is easy to read and print. |
| Ribbon | A graphic band across the top of the screen that contains tabs and groups of commands. |
| Table | The most basic database object; stores data in categories. |
| Template | A ready-to-use database that contains all of the tables, queries, forms, and reports needed for performing a specific task. |
| Wildcard | A character used to find words or phrases that contain specific letters or combinations of letters. |
