In MS Access, which action query adds records from a query result to an existing table? MCQ with Answer and Explanation

In MS Access, which action query adds records from a query result to an existing table?
A. Update query
B. Make-Table query
C. Delete query
D. Append query
Answer: Option D
Solution (By JKSSB Mock Tests)
Append query inserts rows.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
In MS Word, the 'Ctrl + K' shortcut inserts:
A. A bookmark
B. A hyperlink
C. A comment
D. A cross-reference

Correct Answer: Option B


Explanation:
Ctrl+K inserts hyperlink.

This question belongs to: Computer Microsoft Office
Question #2
In MS Access, a single piece of information in a table is stored in a:
A. Query
B. Record
C. Report
D. Field

Correct Answer: Option D


Explanation:
A field represents a column (single data item). A record is a complete row of fields.

This question belongs to: Computer Microsoft Office
Question #3
Which of the following is a built-in Excel tool to perform what-if analysis by changing multiple inputs?
A. Data Table
B. Goal Seek
C. Solver
D. Scenario Manager

Correct Answer: Option D


Explanation:
Scenario Manager stores sets of input values. Goal Seek changes one variable to reach target, Solver optimizes, Data Table shows results of one or two variables.

This question belongs to: Computer Microsoft Office