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. Memo
B. Number
C. Short Text
D. Currency
Answer: Option C
Solution (By JKSSB Mock Tests)
In Access 2013/2016, the default data type for a text field is Short Text (previously Text).

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
In Excel, what does the 'PMT' function calculate?
A. The present value of an investment
B. The interest rate of a loan
C. The future value of an annuity
D. The payment for a loan based on constant payments and interest rate

Correct Answer: Option D


Explanation:
PMT computes the periodic payment for a loan or annuity with constant payments and a fixed interest rate. PV calculates present value, FV future value, RATE calculates interest rate.

This question belongs to: Computer Microsoft Office
Question #2
In Excel, which function calculates the total of a range but ignores error values?
A. SUMIF
B. SUM
C. SUMPRODUCT
D. AGGREGATE

Correct Answer: Option D


Explanation:
The AGGREGATE function can perform various operations (like SUM) while ignoring error values, hidden rows, etc. SUM will return an error if any cell in the range has an error. SUMIF and SUMPRODUCT also do not ignore errors.

This question belongs to: Computer Microsoft Office
Question #3
Which feature in MS Word allows users to create standardized form letters or labels by combining a master template document with an external address list database?
A. Track Changes framework
B. Style Separator compilation
C. Mail Merge
D. Quick Parts automation

Correct Answer: Option C


Explanation:
Mail Merge is an automation tool that merges a standardized template document with an external data source (such as an Excel spreadsheet or Access table) to bulk-generate personalized mass mailings or labels.

This question belongs to: Computer Microsoft Office