| A | B |
|---|
| Table | An arrangement of columns and rows. It is the fundamental building block of all databases |
| Entry | A single piece of data in a database table |
| Field | A grouping or category of similar information contained in a table; a unique identifier for a category of information |
| Record | A complete description of all of the fields related to one item in a table |
| Text | Used for data that will be sorted in alphabetical order or listed randomly; will not be used in mathematical calculations |
| Memo | Data type used for lengthy entries that allows combinations of text and numbers |
| Number | Used for data that may be calculated, sorted, or filtered |
| Date/Time | Data type used to arrange and sort data chronologically, often used with the input mask field property |
| Currency | Data type used to format numbers as decimal values with a dollar sign |
| Auto Number | Used to automatically assign a number to each record and to assist in preventing duplication of data |
| Yes/No | A data type in toggle format that allows a user to select a yes or no value in a database cell. The default setting is NO |
| Lookup Wizard | A data type used to define preset values for database entries. This feature increases productivity and accuracy by reducing the amount of data entery requirec. |
