In MS Access, what is the default data type for a new text field (Short Text)? MCQ with Answer and Explanation

In MS Access, what is the default data type for a new text field (Short Text)?
A. Currency
B. Number
C. Short Text
D. Memo
Answer: Option C
Solution (By JKExamLibrary)
In Access 2013/2016, the default data type for a text field is Short Text (previously Text).

This question belongs to: Computer Microsoft Office

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1 Report Error
In PowerPoint, the 'Gridlines' option helps to:
A. Draw shapes
B. Align objects precisely on the slide
C. Add a chart
D. Create a table

Correct Answer: Option B


Explanation:
Gridlines are non-printing lines for alignment.

This question belongs to: Computer Microsoft Office
Question #2 Report Error
What is the function of the '$' sign in Excel formulas?
A. It denotes a currency format
B. It indicates a named range
C. It is used for concatenation
D. It creates an absolute reference

Correct Answer: Option D


Explanation:
The dollar sign ($) is used to create absolute references (e.g., $A$1) that do not change when the formula is copied. It can also be used for currency formatting when applied as a number format, but in formulas it's for absolute references.

This question belongs to: Computer Microsoft Office
Question #3 Report Error
In Excel, the VLOOKUP function's fourth argument (range_lookup) set to FALSE indicates:
A. Exact match
B. Closest match
C. Approximate match
D. Descending order

Correct Answer: Option A


Explanation:
FALSE requires an exact match. TRUE or omitted allows approximate match.

This question belongs to: Computer Microsoft Office