| A | B |
|---|
| Active field | The field that contains the cursor and has the right arrow symbol to the left of its row in Design view. |
| Active record | The record in Datasheet view that displays the right arrow symbol to the left of its row. |
| AutoNumber field | A field type that automatically generates a numeric entry that is one greater than that in the last record added. |
| Boundary | The bar separating the column letters at the top of a table. |
| Columnar form | Displays a record with one field right after the other in a column. |
| Complex query | A query that checks records for more than one entry. |
| Criteria | The required data that a record must contain in order to be displayed by a query. |
| Currency field | A field type that stores only dollar amounts. |
| Database | A computer application that is used to organize and store related data. |
| Datasheet view | A table displayed as rows and columns of data where each row corresponds to a record and each column corresponds to a field. |
| Date/time field | A field type that stores only a date or time. |
| Design view | The view used for defining the fields of a table. |
| Entry | The data stored in an individual field of a single record. |
| Field | Represents a piece of data in a record. |
| Filter | A query method that displays specific records in a table. |
| Filter by Form view | Used to enter query criteria. |
| Fixed | A field format that displays a field's entry to a specific number of decimal places. |
| Form | A way to view one record of a table at a time. Also used to add a record. |
| Format | The way in which field contents are displayed. |
| General Number | The default field format that displays a number exactly as entered. |
| Hidden records | Records that do not meet query criteria and are therefore no longer displayed. |
| Long integer | A field size that stores only whole numbers. |
| Memo field | A field type that stores several lines of text. |
| Microsoft Access | The relational database application in the Microsoft Office package. |
| Number field | A field type that stores only numberic values. |
| Or tab | Tab at the bottom of the Filter by Form view window that displays another Filter by Form view for entering additional query criteria. |
| Primary key | A field or fields designated to have unique entries in order to make each record of a table unique. |
| Percent | A field format that multiplies the value entered by 100 and displays it with a % sign. |
| Query | Limits the records displayed to htose which meet certain criteria. |
| Record | A set of data about one item. |
| Record controls | Provided at the bottom of a form to scroll records. |
| Record selector | The gray box tot he left of each record in Datasheet view that when clicked selects that record. |
| Relational database | A database in which data is separated into tables of related records. |
| Relational Database Management System (RDBMS) | The objects that make up the relational database, such as tables, forms, queries, and reports. |
| Report | Data that is organized and formatted for printing. |
| Required | Option in the Field Properties part of the table Design view window that should be set to Yes for the primary key. |
| Single | A field size that can store numbers with a decimal portion. |
| Size | The number of characters stored in a text field or type of numerical value stored in a number field. |
| Standard | A number field format that displays a thousands separator, usually a comma. |
| Table | Contains a set of records organized into rows and columns. |
| Text field | A field type that stores characters (letters, symbols, word, a combination of letters and numbers). |
| Type | The classification of a field based on the kind of data it stores. |
