In Access, which query type is used to display data from multiple tables based on a common field? MCQ with Answer and Explanation

Question

Share Report Error

In Access, which query type is used to display data from multiple tables based on a common field?

A. Parameter Query

B. Crosstab Query

C. Action Query

D. Select Query

Answer: Option D

Solution (By JKSSB Mock Tests)

Select queries can join multiple tables to display data. Action queries modify data, Parameter queries prompt for criteria, Crosstab summarizes data.

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 Excel, what is the result of the formula =LEFT(Microsoft,3)?

A. Microsoft

B. Soft

C. Mic

D. Micro

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
LEFT extracts a specified number of characters from the left side of a text string. LEFT(Microsoft,3) returns Mic.

This question belongs to: Computer Microsoft Office

Question #2

Which action query type in MS Access allows a database administrator to permanently remove a specific group of records from an underlying table based on criteria filters?

A. Append Query

B. Make-Table Query

C. Update Query

D. Delete Query

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
A Delete Query targets records that match specified criteria filters and permanently deletes those rows from the database table.

This question belongs to: Computer Microsoft Office

Question #3

In PowerPoint, what is a 'trigger' in animations?

A. An object that starts an animation when clicked

B. A hyperlink to another slide

C. A sound that plays on slide advance

D. An automatic timer for transition

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Trigger sets an animation to begin on the click of a specified object.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs