Queries, forms and reports
Tables store data; three other objects put it to work. A form enters it, a query asks it questions and a report presents the answers. Paper 1 asks one query item most years: a criterion such as >= 05/11/2024 And <= 05/14/2024 picks the records from the 11th to the 14th, inclusive.
By the end of this page you can
- Say what forms, queries and reports are for
- Write query criteria with relational and logical operators
- Add a calculated field and sort or group a report
Goals tick themselves off as you try the activities below.
Photo: The Document Foundation, CC BY-SA 3.0, via Wikimedia Commons. Cropped to the query wizard, JPEG q80.
A wizard builds a query step by step: choose the fields, the sort order, then the search conditions.
How often it shows up in past papers
All papers11 of 14 papers
Last 55 of 5 · 2019–2025
Paper 1 counts come from our past-paper bank of CSEC Information Technology Paper 1s. The last-5 row shows how often it came up in the five most recent papers.
Inside this topic
- Forms, queries, reportsLocked
- Writing criteriaLocked
- Key termsLocked
- Test yourselfmarkedLocked