| A | B |
|---|
| Design view | In Access, an object view that allows you to design and change tables, queries, forms, reports, and other objects. |
| Database | A collection of data related to a particular topic. An Access database is a single file that contains all the tables, queries, forms, and reports for that collection of information. |
| Form | An Access database object that holds controls for entering, editing, and displaying data from an underlying table or query. |
| Foreign Key field | The field in the “many” table that links the table to the primary key field in the “one” side of a “one” to “many” relationship. |
| Datasheet view | In Access, an object view that displays records in a row-and-column format similar to a spreadsheet. Datasheet view allows you to see many records at the same time. |
| Navigation Pane | A pane in the Access Window which provides a way to move between objects (tables, queries, forms, reports, macros and modules) |
| Database object | Tables, queries, reports, forms, and other objects that are the functional parts of an Access database. |
| Query | In Access, a database object that shows specific data you want to work with. The data may be drawn from multiple related tables, may have several filters applied, and may include calculated expressions. |
| Data type | In access, a field property that determines what type of data the field can contain (for example Number, Text, Date/Time, or Yes/No). |
| Database Template | A tool that can be used to quickly create a new database based on a particular subject such as assets, contacts, events, or projects. |
| Field | The smallest unit of data organization. Consists of specific categories of data and is displayed as a column in Datasheet view. |
| Record selector | In Access, the gray box at the left side of each record in Datasheet view or in Form view. Used to select the entire record. |
| Primary Key field | a field that contains unique information for each record and cannot contain a null value. Used to relate one table to another. |
| Form view | In Access, an object view that usually displays data one record at a time, with added graphical elements for easier reading. This view is convenient for entering and editing data in tables. |
| Relational database | A type of database in which information is stored in separate but related tables, which allows for non-redundant, more efficient data storage and retrieval. |
| Report | In Access, a database object that presents data organized and formatted to your specifications. |
| Table | In Access, a collection of data with the same subject or topic. Data are stored in records (rows) and fields (columns). |
| Record | A group of related fields that describe a person, place, or thing. A set of information that belongs together, such as a customer's name and address information, or details about a product. |
| Navigation Buttons | buttons in the lower left corner of a datasheet or form that allow you to quickly navigate between the records as well as add a new record. |
| Table Template | A tool you can us to quickly create a single table within an existing database by providing a set of fields that describe a particular subject, such as contacts or tasks, which can be used or modified to meet your needs. |
