Question

explain different data type used in Microsoft Access

Answer 1

Text, date and time, memo, number etc.

Answer 2

Every field in a table has properties and these properties define the field's characteristics and behavior. The most important property for a field is its data type. A field's data type determines what kind of data it can store. MS Access supports different types of data, each with a specific purpose.

The data type determines the kind of the values that users can store in any given field.

Each field can store data consisting of only a single data type.

Here are some of the most common data types you will find used in a typical Microsoft Access