Question

What is data type in M.S. Access ? Write its types with example.​

Answer 1

data type is a type of data. ... Some common data types include integers, floating point numbers, characters, strings, and arrays. They may also be more specific types, such as dates, timestamps, boolean values, and varchar (variable character) formats.

Answer 2

Answer:

The answer to the given question is:

Data types that are the building blocks of databases

Explanation:

Every table in Access is made up of fields. Attributes of a field describe the characteristics and behavior of the data added to that field. The data type of the field is the most important property because it determines the type of data the field can store. This article describes the data types and other field properties that are available in Access and includes additional information on the data type in-depth reference.

Data types for Access desktop databases:

• Data types Dimensions used
• Number Numeric data. 1, 2, 4, 8, or 16 bytes.
• Date/Time Date and time. 8 bytes.
• Currency data Currency is stored to 4 decimal places precision. 8 bytes.

#SPJ3