| A | B |
|---|
| Text | Used for data that will be sorted in alphabetical order or listed randomly. Will NOT be used for mathematical calculations |
| Memo | Data type used for lengthy entries that allows combinations of text and numbers |
| Number | Data type used for data that may be calculated, sorted, or filtered |
| Data/Time | Data type used to arrange and sort data chronologically. |
| Currency | Used to format numbers as decimal values with a dollar sign ($). |
| AutoNumber | Data type used to automatically assign a number to each record and to assist in preventing duplicates. |
| Yes/No | Data type in toggle format that allows a user to select a "yes" or "no" value. |
| Lookup Wizard | Data type used to define present values for database entries |
| Field Size | Set the maximum size for data stored as a Text, Number, or AutoNumber data type. |
| Format | Customize the way that the field appears by default when it is displayed or printed |
| Input Mask | Display editing characters to guide data entry. |
| Caption | Set the text displayed by default in labels for forms, reports, and queries |
