What is the maximum number of characters that can be stored in a 'Text' field in MS Access (Short Text)? MCQ with Answer and Explanation

What is the maximum number of characters that can be stored in a 'Text' field in MS Access (Short Text)?
A. 255
B. 256
C. 64,000
D. 1 GB
Answer: Option A
Solution (By JKSSB Mock Tests)
Short Text field in Access can store up to 255 characters. Long Text can store up to 65,535 characters.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
In MS Access, the 'RunSQL' macro action is used to:
A. Open a report
B. Execute an SQL statement
C. Close a form
D. Run a query

Correct Answer: Option B


Explanation:
RunSQL executes action queries.

This question belongs to: Computer Microsoft Office
Question #2
Which feature in MS Word allows you to automatically add a reference list at the end of a document for cited sources?
A. Table of Contents
B. Cross-reference
C. Bibliography
D. Index

Correct Answer: Option C


Explanation:
The Bibliography feature in Word creates a list of sources cited in the document. Table of Contents lists headings, Index lists keywords, Cross-reference links to other parts.

This question belongs to: Computer Microsoft Office
Question #3
What is the purpose of the HLOOKUP function in Excel?
A. Performs a case-sensitive search
B. Looks up a value in the top row of a table and returns a value from a specified row below it
C. Searches horizontally for the maximum value
D. Looks up a value in the leftmost column and returns from a column to the right

Correct Answer: Option B


Explanation:
HLOOKUP searches for a value in the first row and returns from a specified row. VLOOKUP searches in first column.

This question belongs to: Computer Microsoft Office