| A | B |
|---|
| Text | used for entering information such as a name or street address. Maximum length is 255 characters. |
| Memo | use tis for storing longer descriptions, up to 65,535 characters. |
| Number | use this to store raw numbers. Can be used for calculations. |
| Date/time | Use this to store dates such as Sales Date or Birth Date or times such as Ending Time or Manufacturing time. |
| Currency | Use this to store raw numbers, but format the numbers as currency with dollar signs. |
| Autonumber | Use this for Access to create sequentially unique numbered fields. |
| Yes/No | Yse this for storing information that answers the questions Yes or No, On or Off, or True of False. |
| OLE Object | Use this to embed information from an outside source, such as a photo, or auxiliary Word or Excel document. |
| Hyperlink | Use this field type to store hyperlinks to other documents or Websites. |
| Attachment | Use this to create an attachment to an outside document. |
| Calculated | Use this if you need a calculation derived from at least one numeric field in the same table. |
| Lookup Wizard | Use this for providing a drop-down menu with choices to select from. |
