In MS Access, what type of query can combine fields from multiple tables by matching data across shared key rows, without altering the underlying raw data? MCQ with Answer and Explanation

In MS Access, what type of query can combine fields from multiple tables by matching data across shared key rows, without altering the underlying raw data?
A. Update Query
B. Delete Query
C. Select Query
D. Append Query
Answer: Option C
Solution (By JKExamLibrary)
A Select Query extracts and displays information from one or more tables based on user-defined criteria without modifying the source data records.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
In PowerPoint, the 'Action' button can be used to:
A. Add animation
B. Change slide layout
C. Hyperlink to another slide, file, URL, or run a program
D. Insert a video

Correct Answer: Option C


Explanation:
Action buttons are interactive.

This question belongs to: Computer Microsoft Office
Question #2
To select an entire paragraph in MS Word, you can:
A. Double-click the paragraph
B. Triple-click anywhere in the paragraph
C. Ctrl + Click
D. Shift + Click

Correct Answer: Option B


Explanation:
Triple-click selects the whole paragraph.

This question belongs to: Computer Microsoft Office
Question #3
In MS Access, which SQL statement query mode is used to permanently remove specified records from an underlying data table row range?
A. Delete Query
B. Remove Rows Macro
C. Truncate Action
D. Drop Table Query

Correct Answer: Option A


Explanation:
A Delete Query matches target row entries using defined criteria limits and permanently removes those records from the table database.

This question belongs to: Computer Microsoft Office