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

In Access, which query type is used to display data from multiple tables based on a common field?
A. Crosstab Query
B. Parameter Query
C. Select Query
D. Action Query
Answer: Option C
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.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
Which object query language is natively used behind the graphical interface layout to filter and extract records in MS Access tables?
A. Structured Query Language (SQL)
B. Extensible Markup Language (XML)
C. HyperText Markup Language (HTML)
D. Unified Modeling Language (UML)

Correct Answer: Option A


Explanation:
MS Access uses SQL (Structured Query Language) behind its graphical Query Design view to communicate with, query, and manipulate relational databases.

This question belongs to: Computer Microsoft Office
Question #2
In MS Word, which key is used to delete text to the right of the insertion point?
A. End
B. Insert
C. Delete
D. Backspace

Correct Answer: Option C


Explanation:
Delete key removes the character to the right. Backspace deletes to the left.

This question belongs to: Computer Microsoft Office
Question #3
In PowerPoint, the 'Eyedropper' tool is used to:
A. Pick a color from any part of the slide and apply it to another object
B. Copy formatting from one shape to another
C. Insert a screenshot
D. Crop an image precisely

Correct Answer: Option A


Explanation:
Eyedropper matches colors. Format Painter copies formatting.

This question belongs to: Computer Microsoft Office