| A | B |
|---|
| Backstage view | Contains many of the commands that were on the File menu in previous versions of Microsoft Access and enables you to create a new database, create a database from a template, open an existing database, view and edit database properties, manage user accounts, and perform many database maintenance tasks. |
| Command | A tool (such as an icon, a button, or a list) that tells Access to perform a specific task. Each tab provides commands that are relevant to the kind of task you are performing. |
| Database | A tool for collecting and organizing information. |
| Database management system (DBMS) | A system for managing data that allows the user to store, retrieve, and analyze information. |
| Datasheet | A visual representation of the data contained in a table or of the results returned by a query. |
| Data type | The kind of information a field contains—whether text, number, date/time, or some other type. |
| 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. |
| File tab | A tab that displays the Backstage view and contains a menu of commands that you can use for the common tasks performed with your database files—such as opening, saving, and printing. |
| 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. |
| 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. |
| 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 Access Toolbar | A toolbar at the top left of the screen that contains the commands that you use most often—such as Save, Undo, Redo, and Print. |
| Record | A row in a database table. |
| Redundant data | Duplicate information in a database. |
| 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. |
| Tab | An area of activity on the Ribbon. |
| Table | The most basic database object; stores data in categories. |
