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.
| 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.
| 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. |
| 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. |