Access Data Types

Created by JASpann 

Upgrade to
remove ads

10 terms · Access Data Types and Examples

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

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

NEW! Voice Recording

Click the mic to start.

Create Set