Data Types in MS Access

Question 1

Use for text and for numbers that are not used in mathematical calculations. It can store up to 255 characters.

Answer 1

Text/Short Text

Question 2

Use for long pieces of text. It can store up to 64,000 characters.

Answer 2

Memo/Long text

Question 3

Numeric data. Use for numbers you want to use in mathematical calculations.

Answer 3

Number

Question 4

Used for dates and times.

Answer 4

Date/Time

Question 5

Used for currency. It prevents rounding during calculation.

Answer 5

Currency

Question 6

Unique sequential numbers or random numbers automatically inserted when you create a record. Use to create a primary key.

Answer 6

AutoNumber

Question 7

Logical data. It is used when only one of two values is valid. Yes/No, True/False, etc.-

Answer 7

Yes/No

Question 8

Used to store hyperlinks.

Answer 8

Hyperlink

Question 9

Used to store attachments.

Answer 9

Attachment

Question 10

Used to attach an OLE object such as a Word document, Excel spreadsheet, or PowerPoint presentation.

Answer 10

OLE Object