Technology · Reference dataset
Microsoft Access Data Types
Microsoft Access data types, with descriptions and storage requirements.
Download options
Preview the records
The 10 most recently added of 17 records · Select a column heading to sort.
| ID | Data type | Description | Storage |
|---|---|---|---|
| 17 | Date/Time Extended | Dates and times. | 42 bytes |
| 16 | Large Number | Numeric data. | 8 bytes |
| 15 | Number | Numeric data. | 1, 2, 4, 8, or 16 bytes |
| 14 | Lookup Wizard | Let you type a list of options, which can then be chosen from a drop-down list | 4 bytes |
| 13 | Hyperlink | Contain links to other files, including web pages | |
| 12 | Ole Object | Can store pictures, audio, video, or other BLOBs (Binary Large OBjects) | Up to about 2 GB |
| 11 | Yes/No | 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 and 0). Note: Null values are not allowed in Yes/No fields | 1 byte |
| 10 | Date/Time | Use for dates and times | 8 bytes |
| 9 | AutoNumber | AutoNumber fields automatically give each record its own number, usually starting at 1 | 4 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 |
CSV / JSON / XML
Put this data to work.
All 17 records, in your choice of format.
- This dataset and the rest of the catalog
- Complete CSV, JSON, and XML files
- Category ZIPs and API access
365 days of access to the catalog. One payment, no automatic renewal.
Your key arrives by email after payment. Use it here to download the complete file.
Already have a pass?
Your key is used for this request and is not saved by this page.
Commercial use is allowed, free or paid.
Downloaded a CSV? Convert CSV to JSON, generate SQL inserts, remove duplicate lines, or sort a list with the free tools.
Scope and sources
Last checked against sources: October 15, 2026.
Last changed: October 15, 2026. This is when we last changed the data or its description. It doesn’t mean the data runs up to that date.
A complete download includes all 17 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.