Which property under an MS Access query design matrix allows database administrators to filter records to show only those matching a specific range, such as values between 100 and 500? MCQ with Answer and Explanation

Which property under an MS Access query design matrix allows database administrators to filter records to show only those matching a specific range, such as values between 100 and 500?
A. Sort Row
B. Field Identifier alignment
C. Show checkbox parameter
D. Criteria Row
Answer: Option D
Solution (By JKSSB Mock Tests)
The Criteria row in the Query Design grid is where you input logical expressions (such as 'Between 100 And 500') to filter the records extracted from the database.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
In MS PowerPoint, which feature allows you to animate the text in a bulleted list one bullet at a time?
A. Effect Options
B. Rehearse Timings
C. Trigger
D. Animation Pane

Correct Answer: Option A


Explanation:
After applying an animation, you can use Effect Options to set the sequence (e.g., 'By Paragraph' for bullets) so each bullet animates separately.

This question belongs to: Computer Microsoft Office
Question #2
Which of the following is NOT a valid function category in Excel?
A. Text
B. Financial
C. Graphing
D. Logical

Correct Answer: Option C


Explanation:
Graphing is not a function category. Categories include Financial, Logical, Text, Date & Time, Lookup & Reference, Math & Trig, Statistical, etc.

This question belongs to: Computer Microsoft Office
Question #3
In PowerPoint, which tab would you use to change the orientation of slides from landscape to portrait?
A. Design -> Slide Size -> Custom Slide Size
B. Home -> Orientation
C. View -> Slide Orientation
D. Insert -> Slide Orientation

Correct Answer: Option A


Explanation:
Slide orientation is under Design -> Slide Size.

This question belongs to: Computer Microsoft Office