How can we help?

You can also find more resources in our Help Center.

10 terms

Access Data Types

Access Data Types and Examples
STUDY
PLAY
Attachment
Files, such as digital photos. Multiple files can be attached per record. This data type is not available in earlier versions of Access.
AutoNumber
Numbers that are automatically generated for each record.
Currency
Monetary values.
Date/Time
Stores dates and times or a combination of both.
Hyperlink
Hyperlinks, such as e-mail addresses and webpages.
Memo
Long blocks of text and text that use text formatting. A typical use of a Memo field would
be a detailed product description. Contains up to 65,500 characters
Number
Numeric values, such as distances, that can be used in math (no letters). Note that there is a separate data type for currency.
OLE Object
Stores graphics, sounds, and objects such as spreadsheets in a field. Objects can be linked or embedded.
Text
Short, alphanumeric values, such as a last name or a street address.
Yes/No
Stores yes/no, true/false, or on/off values