Understanding Data Types

Leave a Comment
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.


If You Enjoyed This, Take 5 Seconds To Share It

0 comments:

Post a Comment

Enter your comments to JoxTech