In MS Access, which of the following is a valid query type that adds records from one table to another? MCQ with Answer and Explanation

In MS Access, which of the following is a valid query type that adds records from one table to another?
A. Update Query
B. Make-Table Query
C. Delete Query
D. Append Query
Answer: Option D
Solution (By JKSSB Mock Tests)
Append Query adds records from one table to another. Update modifies existing, Delete removes, Make-Table creates a new table.

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 is the file extension for an MS Word template?
A. .dotm
B. .dotx
C. .docx
D. .docm

Correct Answer: Option B


Explanation:
.dotx is the extension for a Word template (macro-free). .docx is a document, .docm is macro-enabled document, .dotm is macro-enabled template.

This question belongs to: Computer Microsoft Office
Question #2
In MS Access, a 'Macro' is used to:
A. Import external data
B. Store data
C. Automate a series of actions without writing VBA code
D. Create reports

Correct Answer: Option C


Explanation:
Macros provide a simplified automation tool.

This question belongs to: Computer Microsoft Office
Question #3
To go to the previous page in a Word document, press:
A. Ctrl + Page Up
B. Ctrl + Up Arrow
C. Page Up
D. Alt + Page Up

Correct Answer: Option A


Explanation:
Ctrl+Page Up moves to the top of the previous page. Page Up scrolls up.

This question belongs to: Computer Microsoft Office