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. Memo
B. Attachment
C. OLE Object
D. Hyperlink
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 MS Access, what is the purpose of a 'Query'?
A. To create user interface forms
B. To store data
C. To retrieve and manipulate data from tables
D. To print reports

Correct Answer: Option C


Explanation:
Queries are used to retrieve, update, delete, or analyze data from tables based on specified criteria. They do not store data permanently (except make-table queries).

This question belongs to: Computer Microsoft Office
Question #2
In MS Word, which feature allows you to insert a preformatted cover page?
A. Insert -> Cover Page
B. Design -> Page Background
C. References -> Index
D. Layout -> Breaks

Correct Answer: Option A


Explanation:
Cover Page is under Insert tab.

This question belongs to: Computer Microsoft Office
Question #3
In Excel, to quickly sum a range of numbers, use the shortcut:
A. Alt + =
B. Ctrl + +
C. Ctrl + Shift + $
D. Alt + Shift + =

Correct Answer: Option A


Explanation:
Alt + = inserts the AutoSum function.

This question belongs to: Computer Microsoft Office