Microsoft Access Data Types

Data Type Description Limit
Text Allows for Text characters as well as a combination of Text and Number 255 characters
Memo Allows for a large storage of Text 65,536 charatcers
Number Depending on the field size, allows for various lengths of integers and decimals
Date/Time Allows for usage of dates and timestamps
Currency Allows for Currency usage 15 digits / 4 decimal
AutoNumber Adds a number to each record in a sequential order typically starting at 1
Yes/No Logic field Yes/No, True/False, and
On/off
OLE Object Can store pictures, video, audio and other objects
Hyperlink Contains links to other files or webpages
Attachment Allows for the storage of files
Calculated Set up a formula in the table
Lookup Wizard… Set up a list of options which can be chosen from a dropdown
Show Buttons
Hide Buttons
%d bloggers like this: