NEW
Font size
WorksheetsMicrosoft Access (Data Types)
Total questions: 10
Worksheet time: 5mins
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 -263 to 263-1.
AutoNumber
Number
Large Number
Currency
