| A | B |
| Caption | A display name. A field’s column heading in a datasheet View. The text in a label control |
| Control | An object on a form or report that displays data such as a text box or check box, or a button that lets users control a program |
| Crosstab Query | Calculates a sum, average, count, or other type of total for data that is grouped by two fields – one across the top of the datasheet, the other in each row of the datasheet |
| Data Access Page | Allows users to use databases with a web browser and to add to add, change, and view records in a database |
| Data Type | Tells what type of data a field can hold. For instance, a number field can store numbers only |
| Database template | A sample database used by the database wizard to create a new database |
| Design view | The view that allows you to change the structure of a database object |
| Duplicate query | Finds records with the same record view |
| Form view | The view that allows you to view, add, delete, and change data, usually one record at a time |
| Input mask | Allows users to apply a specific type of format to data by choosing from a list |
| Wizard | A series of dialog boxes that guides you through a task |
| Value | Data in a field. You might key 16 as the value for the age field |
| Unmatched query | Finds records |
| Report preview | Shows how a report will look when printed |
| Relationship | A link between two tables based on a common field |
| Referential integrity | Prevents conflicting data between two tables by enforcing a relationship |
| Property Sheet | A window listing the properties for an object |
| Property | A detail about an object, such as the size or default value |
| Page View | Shows how a page will look in a Web browser |
| Lookup Field | Displays input choices from another table so you can enter data by choosing from a list |