Question

What is data type in M.S. Access ? Write its types with example.​

Answer 1

Answer:

Explanation:

Here are some of the most common data types you will find used in a typical Microsoft Access database.

Types, description and sizes

Short Text Text or combinations of text and numbers, including numbers that do not require calculating. Up to 255 characters.

Long Text Lengthy text or combinations of text and numbers. Up to 63, 999 characters.

Number Numeric data used in mathematical calculations. 1, 2, 4, or 8 bytes.

Date/Time Date and time values for the years 100 through 9999. 8 bytes

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

AutoNumber A unique sequential number or random number assigned by Microsoft Access whenever a new record is added to a table. 4 bites.

Yes/No Yes and No values and fields that contain only one of two values  1 bit.

I HOPE IT IS USEFUL, THANKYOU

Answer 2

Answer:

short type(formely known as text)

Long text (formerly known as memo )

Number

large number

Date/time

Date/time extend

currency

auto number

yes/no

OLE object

hyper link

Attachment

calculated

look-up wizard..

thank you.. pls mark me as brain list