| A | B |
|---|
| Database | A tool used to organize, store, retrieve, and communicate groups of related information |
| Tables | The building blocks of all databases. An arrangement of columns and rows |
| Entry | A single piece of data in a databse table |
| Field | A grouping or category of similar information contained in a table |
| Record | A complete description of all the fields related to one item in a table |
| Yes/No | A data type in toggle format that allows a user to select a value |
| Caption | A field property used for column nameing that allows a more user friendly and properly formatted field name than that stored in the database design |
| Lookup Wizard | A data type used to define preset values for database entries |
| Memo | A data type used for lengthy entries that allows combinations of text and numbers |
| Input Mask | A template-like field property that regulates how data is entered in a cell |
| Currency | Data type used to format numbers as decimal values with a dollar sign |
| Date | Data type used to arrange and sort data chronologically |
| Time | Data type used to arrange and sort data chronologically |
| Auto Number | Used to automatically assign a number to each record and to assist in preventing duplication of data |
| Primary Key | Used to format each record in a database as a unique entity |
| Filters | Allow for the retrieval of information that meets specific criteria |
| Sorts | Allow for information to be arranged in a specific order such as alphabetical, chronological, ascending, or descending |
| Relationships | A link between two or more tables in a database |
| One-to-One | when only one record is linked to a record in another table |
| One-to-Many | when a record in one table i linked to more than one record in another table |
