| A | B |
|---|
| Query | A database object created by placing filters and selecting multiple criteria to extract information from one or more tables. |
| Filter | one time deal, that allows application of a set of selection criteria and sorting instructions to the records in a table. |
| <= | Less than or equal to |
| >= | Greater than or equal to |
| <> | Not equal to |
| < | Less than |
| > | Greater than |
| = | Equal to |
| And | reduces the number of records because both conditions must be met. |
| Or | Increases the number of records because one or the other condition must be met. |
| Form | A database object that is used to create a user-friendly format for data entry and retrieval. |
| Subforms | Forms within and related to a main form through a common field. |
| Report | Used to organize, summarize, and print some or all of the data from one or more database table or query. |
| Lines and borders | Used for decoration |
| Controls | text boxes for displaying numbers, names, or labels |
| Labels | Used to display descriptive text that identifies a text box. |
| Text boxes | Used to display data and may contain expressions for data calculation. |
