Which field data type property in MS Access is ideal for fields that store long descriptions or logs that exceed 255 characters? MCQ with Answer and Explanation

Which field data type property in MS Access is ideal for fields that store long descriptions or logs that exceed 255 characters?
A. OLE Object Data Type
B. Hyperlink text block
C. Short Text
D. Long Text
Answer: Option D
Solution (By JKExamLibrary)
In modern versions of MS Access, the 'Long Text' data type (previously known as Memo) stores up to 1 gigabyte of alphanumeric characters, whereas 'Short Text' is capped at 255 characters.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
What is the shortcut key to increase the indent of a paragraph in MS Word?
A. Ctrl + T
B. Ctrl + M
C. Tab key
D. Ctrl + Shift + M

Correct Answer: Option B


Explanation:
Ctrl + M increases the left indent of a paragraph. Ctrl + T creates a hanging indent. Ctrl + Shift + M decreases indent. Tab key indents only the first line (or entire paragraph if selected).

This question belongs to: Computer Microsoft Office
Question #2
In MS Access, which of the following is NOT a valid section in a report?
A. Navigation Pane
B. Detail
C. Report Footer
D. Page Header

Correct Answer: Option A


Explanation:
Navigation Pane is an interface element, not a report section. Sections include Report Header, Page Header, Group Header, Detail, Group Footer, Page Footer, Report Footer.

This question belongs to: Computer Microsoft Office
Question #3
In MS Access, what does the 'Format' property of a field do?
A. Restricts data entry to a pattern
B. Sets the maximum number of characters
C. Specifies the data type
D. Controls how data is displayed, not how it is stored

Correct Answer: Option D


Explanation:
Format property customizes display (e.g., date format).

This question belongs to: Computer Microsoft Office