Term
|
Definition
| Collection of related data |
|
|
Term
|
Definition
| Collection of related fields |
|
|
Term
|
Definition
|
|
Term
|
Definition
| Categories of information stored in a database |
|
|
Term
|
Definition
| Lists all of the objects in a database |
|
|
Term
|
Definition
| A complete set of data for one item |
|
|
Term
|
Definition
| Allows you to view multiple records at once, where you set up a table |
|
|
Term
|
Definition
| Field designated to contain a unique entry for each record |
|
|
Term
|
Definition
| Where you define field properties and change the way that fields store data |
|
|
Term
|
Definition
| Used to ask the database questions about the information stored within it. |
|
|
Term
|
Definition
| Changing the order in which records appear in a database |
|
|
Term
|
Definition
| Temporarily shows specific records that meet certain conditions |
|
|
Term
|
Definition
| Tables that share common fields |
|
|
Term
|
Definition
| The specific information we are looking for when we query a database |
|
|
Term
|
Definition
| Shows information related to a current record from a different table. Opened by clicking the + sign next to the record. |
|
|
Term
|
Definition
| Where we create a multi-table query |
|
|
Term
|
Definition
| Allows us to change the size and format of all fields in a table. |
|
|
Term
|
Definition
| Allows us to store fields containing letters, numbers, spaces, and symbols. |
|
|
Term
|
Definition
| Accepts monetary values and displays them with a dollar sign |
|
|
Term
|
Definition
| Stores values, usually used in calculations |
|
|
Term
|
Definition
| Adds a unique numeric field value to a each new record in a table. |
|
|
Term
|
Definition
| Accepts field values contain a variety of information. Can store up to 65,535 characters. |
|
|
Term
|
Definition
| This field is created by the completion of a mathematical operation of two existing fields |
|
|
Term
|
Definition
| Allows us include functions at the bottom of a table in datasheet view. |
|
|
Term
|
Definition
| Selects records that meet at least one of the conditions in a query. |
|
|
