In MS Access, to permanently remove a table and all its data, you should: MCQ with Answer and Explanation

In MS Access, to permanently remove a table and all its data, you should:

A. Use a Delete query

B. Use a Make-Table query

C. Delete the table object

D. Clear all records

Answer: Option C

Deleting the table object removes structure and data. Delete query only removes records.

This question belongs to: Computer Microsoft Office

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

Question #1 Report Error

In MS PowerPoint, what is the shortcut key combination used to insert a brand new hyperlink on a selected object or text string?

A. Ctrl + K

B. Ctrl + M

C. Ctrl + L

D. Ctrl + H

Correct Answer: Option A

Explanation:
Ctrl + K opens the Insert Hyperlink dialog box across MS Word, Excel, and PowerPoint.

This question belongs to: Computer Microsoft Office

Question #2 Report Error

In MS Access, to sort records in ascending order in a query, use:

A. Both A and B

B. Group By

C. ORDER BY ASC in SQL

D. Ascending order in the Sort row of the query design grid

Correct Answer: Option A

Explanation:
Both design grid sort and SQL ORDER BY ASC work.

This question belongs to: Computer Microsoft Office

Question #3 Report Error

In MS Access, what is the maximum size of an OLE Object field?

A. 2 GB

B. Limited by database size

C. 256 MB

D. 1 GB

Correct Answer: Option D

Explanation:
OLE Object fields can store up to 1 GB of data.

This question belongs to: Computer Microsoft Office