Data types in Access 2016

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.

1. The data type determines the type of value that users can store in the fields.
2. Each field can store data that includes only one type of data.

Here are some of the most common data types used in Microsoft Access databases.

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 bit

If 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.

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