| A | B |
|---|
| database | A collection of data organized as meaningful information that can be accessed, managed, stored, queried, sorted, and reported. |
| DBMS | Database management system (DBMS)–A software system that provides the tools needed to create, maintain, and use a database. |
| datasheet view | A grid containing fields (columns) and records (rows) used to view, add, edit, and delete records. |
| design view | A view which gives users a detailed view of the table’s structure and is used to create and modify a table’s design by specifying the fields it will contain, the fields’ data types, and their associated properties. |
| field | The smallest data element contained in a table, such as first name, last name, address, and phone number. |
| field property | A characteristic of a field that determines how it will look and behave. |
| filter | A feature which allows users to specify conditions to display only those records that meet those conditions. |
| form | A database object that is used to add data into or edit data in a table. |
| macro | A stored series of commands that carry out an action; often used to automate simple tasks. |
| navigation pane | An Access interface element that organizes and lists the objects in an Access database. |
| object | A component created and used to make the database function (such as a table, query, form, or report). |
| primary key | The field (or combination of fields) that uniquely identifies each record in a table. |
| query | A question about the data stored in a database with answers provided in a datasheet. |
| record | A group of related fields representing one entity, such as data for one person, place, event, or concept. |
| relationship | A connection between two tables using a common field. |
| sort | A feature which lists records in a specific sequence. |
| table | The location where all data is stored in a database; organizes data into columns and rows. |
| template | A predefined database that includes professionally designed tables, forms, reports, and other objects that you can use to jumpstart the creation of your database. |
