| A | B |
|---|
| table | the fundamental building block of all databases. |
| Entry | a single piece of data in a database table. |
| Field | category of similar information contained in a table; |
| Record | complete description of all of the fields related to one item |
| Text | used for data that will be sorted in alphabetical order or listed randomly |
| Memo | data type used for lengthy entries |
| Number | used for data that may be calculated |
| Date/time | data type used to arrange and sort data chronologically |
| Currency | data type used to format numbers as decimal values with a dollar sign. |
| Auto Number | used to assign a number to each record. |
| Yes/No | data type in toggle format |
| Lookup Wizard | data type used to define preset values for database entries. |
| Field properties | used to control how data is entered in a field |
| Field size | measured in characters |
| Caption | used for user-friendly column naming |
