| A | B |
|---|
| Text | Used for data that will be sorted in alphabetical order or listed randomly, but will not be used in mathematical calculations. |
| Memo | A data type for lenghty 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. The default format for currency is two decimal places. |
| 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. |
