May 16, 2021 MS Access
Each field in the table has properties that define the properties and behavior of the fields. se. he data type of the field determines what type of data it can store. M S Access supports different types of data, each with a specific purpose.
Here are some of the most common data types used in a typical Microsoft Access database.
| The data type | Describe | Range |
|---|---|---|
| Short Text | Text or a combination of text and numbers, including numbers that do not need to be calculated, such as phone numbers. | Up to 255 characters. |
| Long Text | Long text or a combination of text and numbers. | Up to 63 characters, 999 characters |
| Number | The numeric data used in mathematical calculations. | 1, 2, 4, or 8 bytes (16 bytes if set to copy ID). |
| Date/Time | Date and time values from 100 to 9999. | 8 bytes |
| Currency | Monetary values and numeric data used in mathematical calculations involving 1 to 4 digits of data. | 8 bytes |
| AutoNumber | When you add a new record to a table, a unique sequence (incremented by 1) or random number assigned by Microsoft Access. | 4 bytes (16 bytes if set to copy ID). |
| Yes/No | Yes and No contain only one of the two values (Yes /No, True/False or On/Off) and fields. | 1 bit |
If you use previous versions of Access, you'll find that the two data types are different.
In Access 2013, we now have two data types - short text and long text. In previous versions of Access, these data types were called text and memos.
Text fields are called short text, and your notes fields are now called long text.
Here are some other, more specialized data types that you can choose from.
| The data type | Describe | Range |
|---|---|---|
|
Attachment |
Files, such as digital photos. Y ou can attach more than one file per record. This data type was not available in earlier versions of Access. |
Up to about 2 GB. |
|
OLE objects |
OLE objects can store pictures, audio, video or other BLOBs (binary large objects) |
Up to about 2 GB. |
|
Hyperlink |
Text or a combination of text and numbers is stored as text and used as a hyperlink address. |
Up to 8,192 (each part of the hyperlink data type can contain up to 2048 characters). |
|
Lookup Wizard |
A simple find field uses the contents of another table or list of values to verify the contents of a single value for each row. Complex lookup fields allow you to store multiple values of the same data type in each row.
|
Depends on the type of data that finds the field. |
|
Calculated |
You can create expressions that use data from one or more fields. You can specify different result data types from expressions. |
You can create expressions that use data from one or more fields. You can specify different result data types from expressions. |
These are all the different data types that you can select when you create fields in a Microsoft Access table.