In MS Access, which data type can store up to 1 GB of data for attachments? MCQ with Answer and Explanation

In MS Access, which data type can store up to 1 GB of data for attachments?
A. Hyperlink
B. Attachment
C. Memo
D. OLE Object
Answer: Option B
Solution (By JKSSB Mock Tests)
Attachment data type stores multiple files up to 2 GB total, but each file can be up to 256 MB, overall database limit. OLE Object also stores objects but is older.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
In PowerPoint, which option allows you to save a presentation as a video?
A. Save As -> MP4
B. Both A and B
C. File -> Export -> Create a Video
D. Slide Show -> Record -> Export

Correct Answer: Option B


Explanation:
Both Export and Save As can create a video file.

This question belongs to: Computer Microsoft Office
Question #2
Which section reference indicator in MS Word is placed at the absolute trailing end of an entire document file to compile long-form reference bibliography source origins?
A. Caption citation
B. Footnote
C. Header line text
D. Endnote

Correct Answer: Option D


Explanation:
Endnotes compile at the very end of a document or section block to document source citations. Footnotes appear at the bottom margin of the page where the reference was cited.

This question belongs to: Computer Microsoft Office
Question #3
Which Access object is used to automate repetitive tasks without writing code?
A. Macro
B. Query
C. Module
D. Report

Correct Answer: Option A


Explanation:
Macros automate tasks via a simplified interface. Modules contain VBA code.

This question belongs to: Computer Microsoft Office