In MS Access, which data type is ideal for fields that store long strings of alphanumeric characters, sentences, or paragraphs exceeding 255 characters? MCQ with Answer and Explanation

In MS Access, which data type is ideal for fields that store long strings of alphanumeric characters, sentences, or paragraphs exceeding 255 characters?
A. Short Text
B. Hyperlink
C. OLE Object
D. Long Text
Answer: Option D
Solution (By JKSSB Mock Tests)
In modern versions of MS Access, 'Long Text' (previously called Memo) stores up to about 1 gigabyte of text, 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
Which of the following field types in MS Access supports linking external multimedia structures, files, or objects created in third-party software applications directly into a table row?
A. Calculated field type
B. OLE Object
C. Hyperlink
D. Attachment

Correct Answer: Option B


Explanation:
OLE Object (Object Linking and Embedding) allows files like spreadsheets, images, sounds, or document structures created in external applications to be embedded inside Access databases.

This question belongs to: Computer Microsoft Office
Question #2
In MS PowerPoint, which feature allows you to animate the text in a bulleted list one bullet at a time?
A. Animation Pane
B. Rehearse Timings
C. Trigger
D. Effect Options

Correct Answer: Option D


Explanation:
After applying an animation, you can use Effect Options to set the sequence (e.g., 'By Paragraph' for bullets) so each bullet animates separately.

This question belongs to: Computer Microsoft Office
Question #3
In Excel, the function =NETWORKDAYS(start, end) returns:
A. Days including holidays
B. Number of calendar days
C. Number of working days (excluding weekends) between dates
D. Total days between dates

Correct Answer: Option C


Explanation:
NETWORKDAYS excludes Saturdays and Sundays and optionally holidays.

This question belongs to: Computer Microsoft Office