| A | B |
| Data Types | Used to control how data in a particular field will be searched, sorted or calculated |
| Text | Used for data that will be sorted in alphabetical order or listed randomly |
| Memo | Data Type used for lenghty entries that allow combinations of text and numbers |
| Number | Used for data that may be calculated, sorted or filtered |
| Data/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 automatically assign a number to each record and prevent duplication of data |
| Yes/No | Data type in toggle format |
| Yes/No | Allows a user to select a yes or no value in a database cell |
| Yes/No | Default setting is No |
| LookUp Wizard | Data type used to define preset values for database entries |
| LookUp Wizard | This feature increases productivity and accuracy by reducing the amount of data entry |