| A | B |
|---|
| Active field | The field in Design view that contains the insertion point and displays to the left of its row. |
| Active record | The record in a datasheet that displays to the left of its row. |
| And | Used to describe criteria that requires a record to contain more than one value. |
| AutoNumber field | A field that automatically stores a numeric value that is one greater than that in the last record added. |
| Boundary | The bar separating the field names at the top of a table. |
| Columnar form | A form that displays a record with one field below the other in a column. |
| Complex query | A query that checks records for more than one value. |
| Computerized database | Used to store related information. |
| Criteria | The data a record must contain in order to be displayed by a filter. |
| Currency field | A field that stores dollar amounts. |
| Data | A piece of information in a database. |
| Datasheet | A table in datasheet view. |
| Datasheet view | The view used for displaying records in rows one after the other. |
| Date/Time field | A field that stores a date or time. |
| Design view | The table view that shows the field definitions for a table. |
| Field | Used to store data in a database. |
| Filter | Used to query an Access database. |
| Filter by Form view | The view used for creating a filter. |
| Fixed | A field format that displays a value to a specified number of decimal places. |
| Form | A window that contains the fields of a table. Used for entering and viewing records. |
| Format | The way in which data in a field is displayed. |
| General number | A field format that displays a number exactly as entered. |
| Hidden records | Records that have not been deleted, but are no longer displayed. |
| Long form | A date/time format that displays data in a form similar to Friday, May 9, 2003 or 10:12:30 AM. |
| Long integer | A field size that indicates a whole number. |
| Medium form | A date/time format that displays data in a form similar to 24-June-03 or 10:12 AM. |
| Memo field | A field that stores several lines of text. |
| Microsoft Access | The database application in Microsoft Office. |
| Number field | A field that stores only numeric values. |
| Or | Used to describe criteria that requires a record to contain one value or another. |
| Percent | A field format that multiplies the value entered by 100 and displays it with a % sign. |
| Primary key | A field designated to contain unique data. |
| Query | Used to limit the records displayed to those that meet certain criteria. |
| Record | Data for a set of fields. |
| Record controls | Used for displaying a specific record in a table. Located at the bottom of a form. |
| Record selector | A gray box clicked to select a record in a datasheet. Located to the left of each record. |
| Required option | Used to require data in the primary key field of a table. Located in the Field Properties part of a table in Design view. |
| Short form | A date/time format that displays data in a form similar to 6/24/03 or 10:12. |
| Single | A field size that indicates a number with a decimal portion. |
| Size | The number of characters or the type of number a field can store. |
| Standard | A field format that displays a value with the thousands separator, usually a comma. |
| Table | A group of related fields. |
| Text field | A field that stores characters (letters, symbols, words, a combination of letters and numbers). |
| Apply Filter button | Applies a filter. Also used to remove a filter. Found on the toolbar. |
| Close button | Closes a table. Found in the upper-right corner of a table. |
| Close command | Closes a database. Found in the File menu. The Close button in the Database window can be used instead of the command. |
| Exit command | Quits Access. Found in the File menu. The Close button in the upper-right corner of the application window can be used instead of the command. |
| Filter By Form button | Displays a form or table in Filter by Form view. Found on the toolbar. |
| New Office Document command | Displays the New Office Document dialog box. Found in the Start menu. |
| Open button | Opens a selected form, table, or query. Found on the Database window toolbar. |
| Open command | Displays a dialog box used to select a database to open. Found in the File menu. The Open button on the toolbar can be used instead of the command. |
| Open Office Document command | Displays the Open Office Document dialog box. Found in the Start menu. |
| Page Setup command | Displays a dialog box with print orientation options. |
| Primary Key command | Makes the active field the primary key. Found in the Edit menu. The Primary Key button on the toolbar can be used instead of the command. |
| Print command | Displays a dialog box used for printing a datasheet or form. Found in the File menu. The Print button on the toolbar can be used instead of the command. |
| Save As Query button | Displays a dialog box for saving a filter. Found on the toolbar. |
| Save command | Saves a table. Found in the File menu. The Save button on the toolbar can be used instead of the command. |
| View button | Switches a table between Design view and Datasheet view. Found on the toolbar. |
