In MS Access, which object is used to extract specific data from one or more tables based on criteria? MCQ with Answer and Explanation

Question

Share Report Error

In MS Access, which object is used to extract specific data from one or more tables based on criteria?

A. Macro

B. Form

C. Query

D. Report

Answer: Option C

Solution (By JKSSB Mock Tests)

A query retrieves and filters data. Forms are for data entry, reports for formatted output, macros automate tasks.

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

Share Report

In Excel, to freeze the top row so it remains visible while scrolling, go to:

A. Review tab -> Protect Sheet

B. View tab -> Freeze Panes -> Freeze Top Row

C. Page Layout -> Print Titles

D. Insert tab -> Header & Footer

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Freeze Panes under View tab can freeze rows/columns. Protect Sheet restricts editing.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In Word, which of the following is used to change the case of selected text?

A. Home > Change Case

B. Insert > Change Case

C. Format > Change Case

D. Review > Change Case

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Change Case is in the Home tab, Font group.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In Excel, which function returns the number of cells in a range that meet multiple criteria?

A. COUNTIF()

B. SUMIFS()

C. DCOUNT()

D. COUNTIFS()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
COUNTIFS handles multiple criteria.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs