In MS Access, which clause of SQL is used to filter records based on a condition? MCQ with Answer and Explanation

Question

Share Report Error

In MS Access, which clause of SQL is used to filter records based on a condition?

A. ORDER BY

B. GROUP BY

C. HAVING

D. WHERE

Answer: Option D

Solution (By JKSSB Mock Tests)

WHERE filters rows before grouping. HAVING filters after grouping.

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 PowerPoint, which shortcut key opens the 'Slide Show' tab?

A. Alt + H

B. Alt + D

C. Alt + S

D. Alt + W

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Alt+S for Slide Show tab.

This question belongs to: Computer Microsoft Office

Question #2

In Excel, the 'Paste Special' dialog can be opened with:

A. Alt + E, S

B. Ctrl + Alt + V

C. Both A and C

D. Ctrl + Shift + V

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+Alt+V opens Paste Special. Alt+E,S also opens it (legacy).

This question belongs to: Computer Microsoft Office

Question #3

In MS Word, the shortcut to increase indent by one level is:

A. Alt + Shift + Right Arrow (for list indent)

B. Tab

C. Both A and B (depending on context)

D. Ctrl + M

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl+M increases left indent. Tab may increase list level.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs