Explain any three data types available in MS-Access.
Answers
Answered by
6
Explanation:
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.
ur answer......:)
Answered by
10
Answer:
Long text - it is used text fields .It can store upto 65,535 alphanumeric characters.
Short text- it is used for text fields which doesnot require any calculations like phone numbers, etc.
Currency - it is used foe decimal values with upto 15 digits to left of the decimal point and up to 4 digits to right .
Similar questions