Term
|
Definition
| Rearranging the records in a table in alphabetical or numerical order. |
|
|
Term
|
Definition
| Alphabetically from A-Z or numerically from 0-9 |
|
|
Term
|
Definition
| Alphabetically from Z-A or numerically from 9-0 |
|
|
Term
|
Definition
| The field that is the primary sort field when sorting on multiple fields. |
|
|
Term
|
Definition
| The field that is the secondary sort field when sorting on multiple fields. |
|
|
Term
|
Definition
| displays only the records that meet the criteria that you specify. |
|
|
Term
|
Definition
| conditions that must be met for a record to be displayed. |
|
|
Term
|
Definition
| a database object that extracts data from one or more tables in a database according to criteria that you set. |
|
|
Term
|
Definition
| a query that retrieves or selects data from one or more tables or queries according to your criteria. |
|
|
Term
|
Definition
| the lower pane of the query design view, use the cells in this grid to specify fields and their criteria for the current query. |
|
|
Term
|
Definition
| specify a relationship between two or more tables; your tables must share a common field, and that field must be the primary key field in one of the tables. |
|
|
Term
|
Definition
| where the primary key field in one table is associated with multiple records in a second table; most common type of relationship. |
|
|
Term
|
Definition
| the common field in the second table that is shared with the common field in the first table. |
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
| protects the database by compacting and scrambling the database file if it is opened by a utility program or other program. |
|
|
Term
|
Definition
| a sequence of characters users must type in a dialog box in order to open the database file. |
|
|
Term
|
Definition
| in this mode no other users have access to the file while it’s open. |
|
|
Term
|
Definition
| reverses the encrypting process. |
|
|
Term
|
Definition
| What you set between two tables so that you can use the fields from both tables in a query |
|
|
Term
|
Definition
| Used to filter records that are greater than, less than, or equeal to a specific number, or between two different numbers. |
|
|
Term
|
Definition
| A field in a table that uniquely identifies a record |
|
|
Term
|
Definition
|
|
