Question

list two types of data types available in microsoft Access, and state their purpose​

Answer 1

Access: Data Types

TEXT. Short Text (formerly Text) is a simple data type. ...

NUMBER. For Number, the critical distinction is made in the Field Size property: Byte, Integer, Long Integer, Single, Double, Replication ID, and Decimal. ...

DATE/TIME. Date/Time is stored as a number. ...

CURRENCY. ...

YES/NO. ...

OLE OBJECT. ...

HYPERLINK. ...

ATTACHMENT.

Answer 2

$\huge\bigstar\mathtt{\color{red} {A}\color{orange}{N}\color{yellow}{S} \color{lightgreen}{W} \color{blue}{E} \color{indigo}{R}} \bigstar$

Access: Data Types

TEXT. Short Text (formerly Text) is a simple data type.

NUMBER. For Number, the critical distinction is made in the Field Size property: Byte, Integer, Long Integer, Single,

Double, Replication ID, and Decimal.

DATE/TIME. Date/Time is stored as a number.

CURRENCY.

YES/NO.

OLE OBJECT.

HYPERLINK.

ATTACHMENT.