AUTONUMBER — Used for indexing records in tables.

CURRENCY — Used for monetary calculations.

DECIMAL — An exact numeric data type that holds values from –10^28 – 1 to 10^28 – 1.

FLOAT — Stores double-precision floating-point values.

INTEGER — Also called INT. Stores a long integer from –2,147,483,648 to 2,147,483,647.

NUMBER — Numerical data that can be used in all forms of calculations except those dealing with money. The Field size property determines the number of bytes used to store the number and, subsequently, the number range.

REAL — Stores single-precision floating-point values.

SMALLINT — Stores an integer from –32,768 to 32,767.

TINYINT — Stores an integer from 0 to 255.

CHAR — Stores a combination of text and numbers up to 255 characters.

MEMO — Variable-length text fields from 1 to 65,536 characters in length.

TEXT — Stores a combination of text and numbers up to 255 characters.

BINARY — Enables you to store any type of data in a field. No transformation of the data is made in this type of field.

BIT — Used to store one of two types of values. For example, true/false, yes/no, or on/off.

COUNTER — Stores a long integer value that automatically increments whenever a new record is inserted.

DATETIME — Stores date and time values for the years 100 through 9999.

HYPERLINK — Links to a file, web address, or other location. Just like Internet links, the hyperlink is a stored string which, when clicked, will redirect the program to the address referenced by the hyperlink.

IMAGE — Used to store Object Linking and Embedding (OLE) objects, such as pictures, audio, and video.

MONEY — Stores currency values and numeric data used in mathematical calculations.

OLE OBJECT — Any linked or embedded object including such things like images, Excel spreadsheets, Word documents, or virtually anything else.

UNIQUEIDENTIFIER — A unique identification number used with remote procedure calls.

YES/NO — Boolean values that have only two states like yes/no, true/false, or on/off.