| A | B |
| database | A tool for collecting and organizing information |
| table | The most basic database object; stores data in categories |
| 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 |
| field | A column in a database 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 |
| 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 |
| 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 |
| database management system (DBMS) | A system for managing data that allows the user to store, retrieve, and analyze information |