Access because that civicpride-kusatsu.net 365 accessibility 2021 accessibility 2019 access 2016 access 2013 accessibility 2010 access 2007 More...Less

When creating tables in Access, you require to choose a data kind for each obelisk of data. The quick Text data form is a popular selection since it allows you enter practically any personality (letter, symbol, or number). However, careful an option of data species can help you take benefit of much more Access features (such together data validation and functions), and improves the accuracy the the information you’re storing. The table listed below gives review of the data varieties available in Access desktop computer databases (.accdb and also .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 every the various field properties easily accessible for the miscellaneous data types, see introduction to data species and ar properties.


Newer versionsOffice 2007 - 2010

The complying with table list the data varieties available in desktop computer databases in access 2013 and also later versions.

Data Type

Usage

Size

Short text (formerly known as “Text”)

Alphanumeric data (names, titles, etc.)

Up to 255 characters.

Long text (formerly recognized as “Memo”

Large amounts of alphanumeric data: sentences and paragraphs. View The Memo data form is now called “Long Text” for more information ~ above the long Text details.

Up to about 1 gigabyte (GB), however controls to display a long text are minimal to the very first 64,000 characters.

Number

Numeric data.

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

Large Number

Numeric data.

8 bytes.

For more information, see making use of the large Number data type.

Date/Time

Dates and also times.

8 bytes.

Date/Time Extended

Dates and also times.

Encoded wire of 42 bytes

For an ext information, see making use of the Date/Time extended data type.

Currency

Monetary data, stored through 4 decimal places of precision.

8 bytes.

AutoNumber

Unique value generated by access for each new record.

4 bytes (16 bytes for ReplicationID).

Yes/No

Boolean (true/false) data; accessibility stores the numeric worth zero (0) for false, and -1 for 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 resolve to a document or paper on the Internet, on an intranet, top top a local area network (LAN), or ~ above your neighborhood computer

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

Attachment

You can affix files such as pictures, documents, spreadsheets, or charts; each Attachment ar can contain an unlimited variety of attachments every record, up to the storage border of the dimension of a database file. Note, the attachments data form isn"t obtainable in MDB document formats.

Up to around 2 GB.

Calculated

You can create an expression that provides data from one or more fields. You deserve to designate different result data species from the expression. Note, the calculate data form isn"t available in MDB file formats.

Dependent ~ above the data type of the Result kind property. Short Text data kind result can have as much as 243 characters. Long Text, Number, Yes/No, and Date/Time should complement their respective data types.

Lookup Wizard

The Lookup Wizard entry in the Data kind column in architecture view is no actually a data type. As soon as you pick this entry, a wizard beginning to aid you define either a an easy or facility lookup field. A straightforward lookup ar uses the contents of one more table or a worth list to validate the contents of a solitary value per row. A facility lookup field enables you to keep multiple worths of the exact same data kind in every row.

Dependent on the data type of the lookup field.


The complying with table perform the data types available in desktop computer databases in access 2010 and access 2007.

Data Type

Usage

Size

Text

Alphanumeric data (names, titles, etc.)

Up to 255 characters.

Memo

Large amounts of alphanumeric data: sentences and paragraphs.

Up to around 1 gigabyte (GB), but controls to display screen a long text are minimal to the an initial 64,000 characters.

Number

Numeric data.

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

Date/Time

Dates and also times.

8 bytes.

Currency

Monetary data, stored with 4 decimal areas of precision.

8 bytes.

AutoNumber

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

4 bytes (16 bytes for ReplicationID).

Yes/No

Boolean (true/false) data; access stores the numeric worth zero (0) because that false, and -1 for 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 deal with to a file or document on the Internet, on one intranet, top top a local area network (LAN), or on your neighborhood computer

Up come 8,192 (each component of a Hyperlink data form can contain approximately 2048 characters).

Attachment

You can attach files such together pictures, documents, spreadsheets, or charts; every Attachment field can contain an unlimited variety of attachments every record, up to the storage border of the dimension of a database file. Note, the attachment data form isn"t available in MDB paper formats.

Up to about 2 GB.

Calculated

You can produce an expression that provides data from one or more fields. You can designate different an outcome data types from the expression. Note, the calculate data type isn"t obtainable in MDB file formats.


Dependent top top the data form of the Result kind property. Quick Text data type result deserve to have approximately 243 characters. Lengthy Text, Number, Yes/No, and also Date/Time should complement their corresponding data types.

See more: How Long Does A Middle School Football Game Last ? How Long Is A Football Game

Lookup Wizard

The Lookup Wizard entry in the Data kind column in architecture view is not actually a data type. As soon as you pick this entry, a wizard beginning to aid you define either a an easy or complicated lookup field. A straightforward lookup ar uses the contents of an additional table or a value list to validate the components of a solitary value every row. A facility lookup field allows you to save multiple worths of the exact same data kind in each row.