Question

Name any four data type available in Microsoft access.

Answer 1

Autonumber
Memo
Text
Currency

Answer 2

Answer:

Any four data types in Microsoft Access are:-

• Autonumber

It is a field that providesa unique value that serves no other purpose than to make each record unique. It automatically generate numbers based on option, increment or random specified by the user. It is usually used as a primary key. The field size vary from 4 to 16 bytes.

• Yes/No

It is used at the places where the field can have only one possible value. It can be either yes or no, on or off, true or false. Displayed as a checkbox in MS Access.

• Text

This type is used for short text fields of limited length and can contain up to 255 characters.

• Attachment

This type of data type allows user to attach a document like an image.