Understanding Data Types
In Access, you use data types to specify the type of data each field can capture.
| Data Types | ||
| Data Type | Use | Notes |
| Text | Alphanumeric data. Use for text and for numbers that are not used in mathematical calculations. Use for names, addresses, and other relatively short pieces of text. Can store up to 255 characters. | . |
| Memo | Long text. Use for long pieces of text, such as notes and long descriptions. Can store up to 64,000 characters. | |
| Number | Numeric data. Use for numbers you want to use in mathematical calculations. | If you are working with currency, use the currency type. |
| Date/Time | Use for dates and times. | |
| Currency | Use for currency. | Prevents rounding during calculation. |
| AutoNumber | Unique sequential numbers or random numbers automatically inserted when you create a record. Use to create a primary key. | |
| Yes/No | Logical data. Use when only one of two values is valid. Yes/No, True/False, etc. | |
| Hyperlink | Use to store hyperlinks. | |
| Attachment | Use to store attachments. | |
| OLE Object | Use to attach an OLE object such as a Word document, Excel spreadsheet, or PowerPoint presentation. | |
Post a Comment