| A | B |
|---|
| Database | A computer application that is used to organize and store related data. |
| Field | Represents a piece of data in a record. |
| Record | Data for a grouped set of fields |
| Form | A window that contains the fields of a table. Used for entering and viewing data one record at a time |
| Query | Used to limit the records displayed to those that meet certain criteria |
| Long integer | A field size that stores only whole numbers. |
| Primary key | A field or fields designated to have unique entries in order to make each record of a table unique. |
| Report | Used to present data for printing in an organized manner with a descriptive title and headings |
| AutoNumber field | A field type that automatically generates a numeric value that is one greater than that in the last record added. |
| Currency field | A field type that stores only dollar amounts. |
| Datasheet | a table dispalyed as rows and columns of data where each row corresponds to a record and each column corresponds to a field. |
| Design view | The table view that shows the field definitions for a table |
| Filter | A query method that displays specific records in a table |
| Criteria | The data a record must contain in order to be displayed by a filter |
| Data | A piece of information in a database |
| Date/Time Field | A field that stores a date or a time |
| Number Field | A field that stores only numerical values |
| Text Field | A field that stores characters (letters, symbols, numbers, etc.) |
| Asterisk | (*) a wildcard character that matches any number of characters in query criteria |
| Design Grid | The part of Select Query Design view that contains fields and criteria |
| Relational Operators | Used in select query criteria to compare values (including =,<,>,<=,>=, and <>) |
| Select Query | A query that uses the relationships between tables to determine the data to display |
| Sorting | Placing records in a specific order |
| Subdatasheet | Shows records from another table that are related to a particular record |
| Calculated Field | Displays the result of a mathematical expression that is defined in a select query |
