| A | B |
|---|
| Attachment Field | A field that allows you to attach an external file such as a Word document, PowerPoint presentation, Excel workbook, or image file to a record. |
| Caption | A field property that determines the default field name at the top of the field column in datasheets as well as in labels that describe fields on forms and reports. |
| Format Property | A field property that controls how information is displayed and printed. |
| Input Mask | A field property that determines display format and limits the type of data that can be entered; makes data entry faster and more precise. |
| Junction Table | A table that provides a link between two tables that have a many-to-many relationship. The junction table has a one-to-many relationship with each of the two tables it links. |
| Key Field Combination | Two or more fields that as a group contains unique information for each record. |
| Lookup Field | A field that contains Lookup Properties |
| Lookup Properties | Field properties that allow you to supply a drop-down list of values for a field. The values can be stored in another table or directly stored in the Row Source lookup property of the field. |
| Lookup Wizard | A tool used in Table Design View which allows one field to “look up” values from another table or entered list. |
| Multi-valued Field | A field that allows you to make more than one choice from a drop-down list. |
| Required Property | A field property that can be used to determine if an entry is required for this field. |
| Row Source | The Lookup property that defines the list of values for the Lookup field. |
| Smart Tag | A button that provides a small menu of options and automatically appears under certain conditions to help you work with a task, such as correcting errors or updating property changes. |
| Validation Rule | A field property that helps eliminate unreasonable entries by establishing criteria for an entry before it is accepted into the database. |
| Validation Text | A field property that determines what message appears if a user attempts to make a field entry that does not pass the validation rule for that field. |
