Each field in a table has attributes and these attributes determine the characteristics and behavior of the field. The most important attribute in a field is its data type - data type . The data type of the field determines what kind of data can be stored.
MS Access supports different types of data, each with a specific purpose.
Here are some of the most common data types used in Microsoft Access databases.
Datatypes
Describe
Size
Short Text Text or number combination text, including numbers that do not require calculations (eg phone numbers, postal codes .), often used to store personal names, addresses, and street names , street name . Up to 255 characters Long Text Long text or combination of text and numbers, consistent with descriptions that require a large amount of text (such as product descriptions). From 63 to 999 charactersNumberDigital data, can be used for calculation, suitable for storing data such as the number of a product, distance, number of students, number of customers . 1, 2 , 4 or 8 bytesDate / TimeDate value / time to store time data from 100 to 9999. 8 bytesCurrency Value for currency and digital data is used with calculations of one to four decimal digits Stool, suitable for storing the amount of money of a given currency. 8 bytesAutoNumberA unique sequence number (increment 1) or random number specified by Microsoft Access every time a new record is added to the table. 4 bytesYes / No Data type Yes / No is suitable for answers or fields that only need to store values with or without 1 bitIf you use previous versions of Access, there will be a slight difference in the name of the data types.
From Access 2013, there are short text and long text data types, and in previous versions, it is called text and memo.
There are also some other specialized data types, you can choose in Access.
Here are some of the most common data types used in Microsoft Access databases.
Datatypes
Describe
Size
Attachment
Attached files such as digital images are suitable for storing attachments on each record. This data type is not available in previous versions of Access.
Up to 2 GB
OLE objects
OLE objects are used to store images, audio, video or large binary objects (Binary Large Object).
Up to 2 GB
Character string is used as a hyperlinked address
Dark 2048 characters
Lookup Wizard
Lookup Wizard is not really a data type. When you select this item, the wizard starts to help you identify a simple or complex lookup field.
The lookup field simply uses the contents of another table or value list to authenticate the content of a value on each row. The complex lookup field allows you to store multiple values of the same data type in each row.
Depends on the data type of the lookup field
Calculated
It is possible to create an expression that uses data from one or more fields. You can specify different result data types from expressions.
These are all the different data types you can choose when creating fields in the Microsoft Access table.
Previous article: Create Database (Database) in Access 2016
Next lesson: Create Table (Table) in Access 2016
ncG1vNJzZmismaXArq3KnmWcp51ksaLAwGarsqiVqHqquoyampydo6h6c3yQbw%3D%3D