A | B |
Criteria | A set if conditions that limits the records included in a query |
Data Type | Defines the kind of information to be stored in a field |
Field | A category of information for each record in a table |
Field Properties | Define the characteristics of data to be entered in a field |
Filter | A selected criterion placed on records in a datasheet or a form to temporarily display a subset of the records |
Form | Object in a database that provides a convenient way to enter and edit data in tables |
Input Mask | Field property that establishes the pattern for data entered in the field |
Primary Key | Field that uniquely identifies a record in a table |
Query | Object in a database used to extract specific information from a table |
Record | Complete set of fields containing information about an item, such as a person or a product |
Referential Integrity | Used to ensure that relationships in tables are valid |
Relationship | Links identical fields between two tables |
Report | Object in a database that is used to summarize data from a table or query and present it attractively for printing and/or review |
Table | Object in a database in which data is stored |