Data Types
Text	Any field that does not fit criteria for one of the other data types. This includes not only text, but also formatted numbers like zip codes and phone numbers.
Memo	Text descriptions longer than 255 characters.
Number	Quantities; values that will have mathematical calculations performed on them.
Date/Time	Dates and times. There are a variety of date and time formats to choose from. Although you can enter dates and times as text data types, you must use the date/time data type if you want to sort the values.
Currency	Money amounts. There are a variety of currency formats to choose from. You can perform mathematical calculations on currency values.
AutoNumber	Primary Keys or other ID fields.
Yes/No	Fields to which there is only a yes or no response.
OLE Object	Pictures or other graphics. Links to other files such as Word or Excel documents.
Hyperlink	Email or web site addresses.
Lookup Wizard...	Limits the data in the field to values in a list (either from another table for from a list that you create).