Which of the following field properties in MS Access determines the maximum number of characters that can be stored in a 'Short Text' data type field? MCQ with Answer and Explanation

Which of the following field properties in MS Access determines the maximum number of characters that can be stored in a 'Short Text' data type field?
A. Field Size
B. Input Mask
C. Format
D. Validation Rule
Answer: Option A
Solution (By JKSSB Mock Tests)
The Field Size property specifies the upper limit of character storage for a Short Text field, which defaults to 255 characters but can be set to any value between 1 and 255.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
In MS PowerPoint, which of the following is a valid file format for saving a presentation for easy sharing?
A. .pptx
B. All of the above
C. .pdf
D. .jpg

Correct Answer: Option B


Explanation:
You can save as .pptx (editable), .pdf (for sharing), and .jpg (as images). So all are valid.

This question belongs to: Computer Microsoft Office
Question #2
Which function in Excel returns the average of cells that meet a given condition?
A. AVERAGEIF()
B. SUMIF()
C. COUNTIF()
D. AVERAGE()

Correct Answer: Option A


Explanation:
AVERAGEIF averages based on a criterion. AVERAGEIFS for multiple criteria.

This question belongs to: Computer Microsoft Office
Question #3
What is the function of the shortcut key combination Ctrl + Spacebar when text is highlighted in MS Word?
A. Highlights the entire document page layout
B. Applies double line spacing to the paragraph
C. Inserts a non-breaking space character
D. Clears all manual character formatting from the selected text

Correct Answer: Option D


Explanation:
Ctrl + Spacebar removes all manual character-level formatting (such as bold, italic, or custom font colors) from the selected text, resetting it to the default style.

This question belongs to: Computer Microsoft Office