Microsoft Access (Data Types)

What are the best match for below data type description?

A simple alphanumeric data type such as names, titles, etc. which is limited to a maximum of 255 characters in length, which is controlled by field size.

• Short Text

• Long Text

• Number

• Currency

What are the best match for below data type description?

A simple data to store integer or numeric data such as 1, -100, 1000 etc.

• Short Text

• Number

• Date/Time

• Currency

What are the best match for below data type description?

Large amounts of alphanumeric data: sentences and paragraphs such as memo that support up to 64,000 characters.

• Short Text

• Long Text

• Date/Time

• Currency

What are the best match for below data type description?

Data values for the years 100 through 9999.

• Short Text

• Long Text

• Date/Time

• Currency

What are the best match for below data type description?

Monetary data, stored with 4 decimal places of precision.

• Short Text

• Long Text

• Date/Time

• Currency

What are the best match for below data type description?

Unique value generated by Access for each new record.

• AutoNumber

• Long Text

• Date/Time

• Currency

What are the best match for below data type description?

Boolean (true/false) data; Access stores the numeric value zero (0) for false, and -1 for true.

• AutoNumber

• Long Text

• Yes/No

• Currency

What are the best match for below data type description?

Text or combinations of text and numbers stored as text and used as a hyperlink address.

• AutoNumber

• Long Text

• Yes/No

• Hyperlink

What are the best match for below data type description?

Store data attachment files such as pictures, documents, spreadsheets, or charts in the database.

• AutoNumber

• Attachment

• Yes/No

• Hyperlink

What are the best match for below data type description?

Data type that can handle bigger numbers than the standard Number data type with the range of -2⁶³ to 2^63-1.

• AutoNumber

• Number

• Large Number

• Currency