| A | B |
| database | A tool used to organize, store, retrieve, and communicate groups of related information. |
| fields | is a grouping or category of similar information contained in a table; a unique identifier for a category of information. |
| record | is a group of fields such as all the information about the person, including first name and last name, addres, postal code, telephone number, and so forth. |
| field name | to help identify the fields. |
| design view | allows you to work with the underlying structure of your tables, queries, forms, and reports. ... |
| datasheet view | displays data in a row-and-column format. |
| cell | the intersection of a row and a column is called a |
| entry | when you enter data into a cell. |
| field properties | specifications that allow you to customize a field beyond chosing a data type. |
| tables | where all database information is stored, and stores data in columns and rows. |
| queries | search for and retrieve data from tables based on specified criteria. |
| forms | allow you to enter records in a custom format. |
| reports | display data in a custom format. |
| pages | enables you to design other database objects so they can be published on the web. |
| macros | enables you to perform a series of operations with a single command. |
| Filter | allows for retrieval of information that meets specific criteria |
| Filter by selection | filters for information related to an active cell |
| Filter/Advanced Sort | type of filter that defines specific search criteria |
| Sorts | enables information to be arranged in a specific order such as alphabetically, chronologically, ascending, descending...... |
| Field size | used to control the size of the field, measured in characters |
| Format | used to control the layout of the field, such as one or two decimal places |
| input mask | a field property that regulates how data is entered in a cell. |
| Caption | field property for column naming that allows a more user-friendly and properly formatted field name |