Describe four data types available in MS Access.
Home
/
Computer Science
/
Describe four data types available in MS Access.
Describe four data types available in MS Access.
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
Explanation:
Data types for Access desktop databases
Data Type Usage Size
Number Numeric data. 1, 2, 4, 8, or 16 bytes.
Date/Time Dates and times. 8 bytes.
Currency Monetary data, stored with 4 decimal places of precision. 8 bytes.
AutoNumber Unique value generated by Access for each new record. 4 bytes (16 bytes for ReplicationID).
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...
HOPE U GETT IT!