Wikipedia defines data type as
“In computer science and computer programming, a data type or simply type is a classification of data which tells the compiler or interpreter how the programmer intends to use the data.”
In short data types are nothing but information that are easy to identify either as text (words or sentence) or numbers or any other type such as boolean (Binary 0 or 1), Date/Time, Currency etc.
By segregating or classifying the data or information in one of the types we help the software or the computer/system to help us process the information efficiently and help us to achieve our desired results on the information that we have.
Pasted below is the standard data types that are available in excel or any standard spreadsheet applications.
Summarized below are some of the commonly used data types in excel and access:
Hope you have understood the basics of data types that are commonly used. I will dive deeper as I progress and as and when needed.
Excel to Access 