Scribd
Upload
106 views2 pages

Microsoft Access Data Types Guide

Microsoft Access has several data types for storing different types of information: 1) Text can store up to 255 characters, while Memo can store larger amounts of text up to 65,536 characters but cannot be sorted. 2) Numeric data types like Integer, Long, Single, and Double store different ranges of whole numbers and decimals. Currency handles monetary values. 3) Date/Time stores dates and times, AutoNumber automatically numbers records, and Yes/No represents true/false values. 4) Other data types include Byte, Ole Object, Hyperlink, and Lookup which let users select from a list.

Uploaded by

Varuna Prabhakar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
106 views2 pages

Microsoft Access Data Types Guide

Microsoft Access has several data types for storing different types of information: 1) Text can store up to 255 characters, while Memo can store larger amounts of text up to 65,536 characters but cannot be sorted. 2) Numeric data types like Integer, Long, Single, and Double store different ranges of whole numbers and decimals. Currency handles monetary values. 3) Date/Time stores dates and times, AutoNumber automatically numbers records, and Yes/No represents true/false values. 4) Other data types include Byte, Ole Object, Hyperlink, and Lookup which let users select from a list.

Uploaded by

Varuna Prabhakar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Microsoft Access Data Types

Data type

Text

Memo

Description

Stora
ge

Use for text or combinations of text and


numbers.
255 characters maximum
Memo is used for larger amounts of text.
Stores up to 65,536 characters.
Note: You cannot sort a memo field.
However, they are searchable

1
byte
Allows whole numbers between -32,768 and 2
Integer
32,767
bytes
Allows whole numbers between
4
Long
-2,147,483,648 and 2,147,483,647
bytes
Single precision floating-point.
4
Single
Will handle most decimals
bytes
Double precision floating-point.
8
Double
Will handle most decimals
bytes
Use for currency. Holds up to 15 digits of
whole dollars, plus 4 decimal places.
8
Currency
Tip: You can choose which country's
bytes
currency to use
AutoNumber fields automatically give each 4
AutoNumber
record its own number, usually starting at 1 bytes
8
Date/Time Use for dates and times
bytes
A logical field can be displayed as Yes/No,
True/False, or On/Off. In code, use the
constants True and False (equivalent to -1
Yes/No
1 bit
and 0).
Note: Null values are not allowed in Yes/No
fields
Can store pictures, audio, video, or other
up to
Ole Object
BLOBs (Binary Large OBjects)
1GB
Byte

Allows whole numbers from 0 to 255

Hyperlink
Lookup
Wizard

Contain links to other files, including web


pages
Let you type a list of options, which can then 4
be chosen from a drop-down list
bytes

You might also like