Question

Explain the various types of MS Access Database​

Answer 1

Answer:

1. Short Text

Text or combinations of text and numbers, including numbers that do not require calculating (e.g. phone numbers). It size is Upto 255 characters.

2. Long Text

Lengthy text or combinations of text and numbers. It size upto 63,999 characters.

3. Number

Numeric data used in mathematical calculations.1,2,4 or 8 bytes (16 bytes if set to Replication ID).

4. Date/ Time

Date and time values for the years 100 through 9999. It is upto 8 bytes.

5. Currency

Currency values and numeric data used in mathematical calculations involving data with one to four decimal places.It is upto 8 bytes.

6. Auto number

A unique sequential ( incremented by 1) number or random number assigned by Microsoft Access whenever a new record is added to table.It has 4 bytes ( 16 bytes if set to Replication ID).

7. Yes / No

Yes and No values and fields that contain only one of two values ( Yes/ No, True/False, or On /Off).It has 1 bit.