Question 1
When would you use a query instead of sorting a table?
A query selects records and fields that meet conditions, while sorting only changes the order of the displayed data.
What to learn
Use a query to retrieve selected records and fields from one or more tables. Create queries with a wizard or Design View, apply single-field or multiple-field criteria, use wildcards and perform calculations with numerical data.
- A query answers a focused question about stored data.
- Criteria filter records; multiple criteria can combine conditions.
- Wildcards match patterns in text fields.
- Calculated fields can derive results from numeric values.
Practical activity
From a Marks table, create a query that returns students with Science marks above 80. Add a calculated total field, then edit the query to include a second criterion for class.
Use your school’s prescribed software version and teacher instructions. Keep personal information out of public practice files.
Solved CBSE-style questions
These questions and answers are original practice written for this guide; they are not copied from past papers.
Question 2
What does a wildcard do in a text criterion?
It stands for one or more unknown characters, allowing a search for a pattern rather than an exact full value.
Question 3
How is a calculated query field useful?
It can compute a value such as total marks or balance from existing numeric fields without manually entering a duplicate result.
Revision checklist
- Can I explain the key terms without memorising a definition alone?
- Can I complete the listed practical task and describe each step?
- Can I apply the idea to a new example and explain why my answer works?
Aligned to the CBSE 2026–27 syllabus outline. Check the official subject curriculum and your school’s textbook/material for the prescribed scope.