|1)||Text Handles strings that contain less than 256 characters. Used for data containing alphanumeric characters such as names, addresses, zip codes. Also used for numbers such as phone numbers that don’t require calculations.|
Used for text values greater than 256 characters. This would mainly be used for large strings such as comments and long descriptions.
Used for numbers that require calculations.
Used for date and time values.
Used for currency values and calculated values with one to four decimal places.
Either a sequential or a random number generated by Access for the purpose of creating a unique value in a record.
Contains one of two values from the following choices: Yes/No, True/False, or On/Off
An object linked or embedded in an Access table. This could be an Excel spreadsheet, Word document, or other type of binary data.
Text or a combination of numbers and text used as a hyperlink address.
This sets the data type, based on the data used when you create the list box or combo box used for looking up values in another table.