Microsoft Access Data Types
Microsoft Access Data Types, with data type, description, and storage.
Look inside
Showing 10 of 14 records. Sort the preview by selecting a column heading.
| ID | DataType | Description | Storage |
|---|---|---|---|
| 1 | Text | Use for text or combinations of text and numbers. 255 characters maximum | |
| 2 | Memo | 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 | |
| 3 | Byte | Allows whole numbers from 0 to 255 | 1 byte |
| 4 | Integer | Allows whole numbers between -32,768 and 32,767 | 2 bytes |
| 5 | Long | Allows whole numbers between -2,147,483,648 and 2,147,483,647 | 4 bytes |
| 6 | Single | Single precision floating-point. Will handle most decimals | 4 bytes |
| 7 | Double | Double precision floating-point. Will handle most decimals | 8 bytes |
| 8 | Currency | Use for currency. Holds up to 15 digits of whole dollars, plus 4 decimal places. Tip: You can choose which country's currency to use | 8 bytes |
| 9 | AutoNumber | AutoNumber fields automatically give each record its own number, usually starting at 1 | 4 bytes |
| 10 | Date/Time | Use for dates and times | 8 bytes |
Free sample files (up to 10 rows): CSV JSON XML
Scope and sources
Last changed: July 17, 2026. This may reflect a change to the data or its description; it is not a coverage-through date.
No source links are listed for this dataset. Ask about its coverage before using it where accuracy or recency matters.
A complete download includes all 14 records currently held in this dataset. Check the description and sources to decide whether its scope fits your project.
Use this dataset through the API
GET https://mysafeinfo.com/api/data/microsoftaccessdatatypesChoose a format, sort, or request fewer rows. A pass key gives access to the complete dataset. See the examples and parameters.
Without a pass, sorting and randomization apply only to the fixed 10-row sample.