Question

Briefly explain all the data types available in Access 2010.

Answer 1

Answer:

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

Answer:

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.