Access because that mmsanotherstage2019.com 365 accessibility 2021 access 2019 access 2016 accessibility 2013 access 2010 accessibility 2007 More...Less

When producing tables in Access, you require to pick a data kind for each shaft of data. The brief Text data type is a popular choice since it allows you enter nearly any character (letter, symbol, or number). However, careful choice of data varieties can assist you take advantage of more Access features (such as data validation and functions), and improves the accuracy the the details you’re storing. The table listed below gives summary of the data species available in Access desktop computer databases (.accdb and .mdb).

You are watching: Text that is in excess of 255 characters of alphanumeric data can be entered into this data type

For a comprehensive list of all the various field properties easily accessible for the various data types, see development to data varieties and ar properties.


Newer versionsOffice 2007 - 2010

The complying with table perform the data species available in desktop databases in accessibility 2013 and later versions.

Data Type

Usage

Size

Short text (formerly well-known as “Text”)

Alphanumeric data (names, titles, etc.)

Up come 255 characters.

Long text (formerly recognized as “Memo”

Large quantities of alphanumeric data: sentences and also paragraphs. Watch The Memo data form is now called “Long Text” for more information ~ above the lengthy Text details.

Up to around 1 gigabyte (GB), yet controls to screen a lengthy text are restricted to the first 64,000 characters.

Number

Numeric data.

1, 2, 4, 8, or 16 bytes.

Large Number

Numeric data.

8 bytes.

For much more information, see using the big Number data type.

Date/Time

Dates and also times.

8 bytes.

Date/Time Extended

Dates and times.

Encoded cable of 42 bytes

For much more information, see making use of the Date/Time expanded data type.

Currency

Monetary data, stored v 4 decimal locations of precision.

8 bytes.

AutoNumber

Unique value created by accessibility for each brand-new record.

4 bytes (16 bytes because that ReplicationID).

Yes/No

Boolean (true/false) data; accessibility stores the numeric worth zero (0) because that false, and also -1 because that true.

1 byte.

OLE Object

Pictures, graphs, or various other ActiveX objects from one more Windows-based application.

Up to around 2 GB.

Hyperlink

A link address to a paper or file on the Internet, on an intranet, on a local area network (LAN), or top top your local computer

Up to 8,192 (each component of a Hyperlink data type can contain as much as 2048 characters).

Attachment

You can affix files such together pictures, documents, spreadsheets, or charts; every Attachment ar can save an unlimited variety of attachments per record, approximately the storage border of the size of a database file. Note, the attachment data type isn\"t accessible in MDB document formats.

Up to about 2 GB.

Calculated

You can develop an expression that uses data native one or much more fields. You deserve to designate different result data types from the expression. Note, the calculate data kind isn\"t available in MDB file formats.

Dependent top top the data kind of the Result kind property. Brief Text data form result can have as much as 243 characters. Long Text, Number, Yes/No, and Date/Time should enhance their particular data types.

Lookup Wizard

The Lookup Wizard entry in the Data kind column in architecture view is no actually a data type. Once you select this entry, a wizard beginning to aid you specify either a simple or complicated lookup field. A straightforward lookup ar uses the contents of an additional table or a worth list come validate the components of a solitary value every row. A complicated lookup field allows you to keep multiple worths of the same data form in every row.

Dependent on the data kind of the lookup field.


The adhering to table lists the data species available in desktop databases in access 2010 and accessibility 2007.

Data Type

Usage

Size

Text

Alphanumeric data (names, titles, etc.)

Up come 255 characters.

Memo

Large quantities of alphanumeric data: sentences and also paragraphs.

Up to about 1 gigabyte (GB), yet controls to screen a lengthy text are limited to the very first 64,000 characters.

Number

Numeric data.

1, 2, 4, 8, or 16 bytes.

Date/Time

Dates and times.

8 bytes.

Currency

Monetary data, stored v 4 decimal places of precision.

8 bytes.

AutoNumber

Unique value generated by access for each brand-new record.

4 bytes (16 bytes because that ReplicationID).

Yes/No

Boolean (true/false) data; accessibility stores the numeric worth zero (0) because that false, and also -1 because that true.

1 byte.

OLE Object

Pictures, graphs, or various other ActiveX objects from an additional Windows-based application.

Up to about 2 GB.

Hyperlink

A link address to a file or file on the Internet, on an intranet, ~ above a regional area network (LAN), or ~ above your regional computer

Up to 8,192 (each part of a Hyperlink data type can contain as much as 2048 characters).

Attachment

You can affix files such as pictures, documents, spreadsheets, or charts; every Attachment field can contain an unlimited number of attachments per record, approximately the storage limit of the size of a database file. Note, the attachment data form isn\"t obtainable in MDB document formats.

Up to about 2 GB.

Calculated

You can produce an expression that uses data native one or more fields. You can designate different result data varieties from the expression. Note, the calculation data type isn\"t available in MDB record formats.


Dependent on the data type of the Result type property. Short Text data form result have the right to have approximately 243 characters. Long Text, Number, Yes/No, and Date/Time should complement their corresponding data types.

See more: Can You Get Worms From Eating Raw Potatoes Cause Worms? Raw Potatoes Poisonous

Lookup Wizard

The Lookup Wizard entry in the Data kind column in design view is no actually a data type. Once you pick this entry, a wizard beginning to assist you define either a simple or complex lookup field. A straightforward lookup field uses the components of another table or a value list to validate the components of a solitary value per row. A facility lookup field enables you to keep multiple values of the exact same data kind in each row.