Which of the following database tools in MS Access is explicitly used to extract selective records matching specific criteria across multiple underlying tables? MCQ with Answer and Explanation

Which of the following database tools in MS Access is explicitly used to extract selective records matching specific criteria across multiple underlying tables?
A. Form
B. Report
C. Query
D. Macro
Answer: Option C
Solution (By JKSSB Mock Tests)
Queries extract, compile, and filter specific records from multiple interconnected database tables depending on targeted user constraints.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
In MS Access, what do you call a field that contains unique data values across all rows and is used to uniquely identify each record in a table?
A. Lookup Index column
B. Composite reference field
C. Primary Key
D. Foreign Key

Correct Answer: Option C


Explanation:
A Primary Key is a designated field that uniquely identifies each record or row inside a database table, and it cannot contain null values.

This question belongs to: Computer Microsoft Office
Question #2
Which view in MS Word helps to organize and navigate a long document using headings?
A. Draft view
B. Web Layout
C. Outline view
D. Read Mode

Correct Answer: Option C


Explanation:
Outline view shows the document's structure based on heading levels, allowing collapsing/expanding.

This question belongs to: Computer Microsoft Office
Question #3
In PowerPoint, which of the following can be a slide transition effect?
A. Push
B. Fade
C. All of these
D. Morph

Correct Answer: Option C


Explanation:
All are transition effects.

This question belongs to: Computer Microsoft Office