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

Question

Share Report Error

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

A. Delete Query

B. Make-Table Query

C. Update 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.

This question belongs to: Computer Microsoft Office

Request complete Subject PDF

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1

In MS Access, SQL View is used to:

A. View the output of a query in a datasheet

B. Write or edit SQL statements for a query

C. Run a macro

D. Design the table structure

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
SQL View shows the query's SQL code.

This question belongs to: Computer Microsoft Office

Question #2

In MS Access, a query that prompts for input each time it runs is a:

A. Crosstab query

B. Select query

C. Parameter query

D. Action query

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Parameter query asks for criteria.

This question belongs to: Computer Microsoft Office

Question #3

In Excel, the 'Trace Precedents' feature shows:

A. Errors in the formula

B. Arrows indicating which cells provide data to the selected formula

C. Cells that depend on the selected cell

D. The formula in a separate window

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Trace Precedents (Formulas tab) draws arrows from cells that feed into the active cell.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs