Entering and editing data, forms with sub-forms, queries with criteria, AND/OR, calculated fields, sorting, and reports with grouping, totals and a title.
5 narrated scenes. Press play, listen and read along — the points appear as they are explained. Use ‹ Prev / Next › or the scene bar to jump to any scene.
A table stores data, but people want answers. Forms enter data safely, queries ask questions, and reports present the answers on paper.
Narration uses your device’s built-in voice. No sound? Switch to “Captions only” — the captions advance on their own.
Change the criteria and the AND / OR to see which records are selected.
Copy these into your notebook in your own words — that is how they stick.
Screen layout to enter or view one record.
Form inside a form showing related “many” records.
Selects records by criteria; can sort and calculate.
"5A", >70, Between, Like "A*"; AND on one row, OR on separate rows.
Name: [Price]*[Quantity] in the query grid.
Printed output; groups, totals, title.
Add, edit, delete, sort, filter, back up.
≤ 3 tables, 2 queries, 1 calculation, main form + sub-form, 1 report with grouping.
3 quick games on this lesson. Earn XP and badges as you play — your best score for each game is saved. Games are for practice and do not change your exam readiness. More games in the Information Technology Arcade.
8 items modelled on real CSEC Paper 1 questions. Choose one answer for each, then check. Aim for 80% or better. Work each item on paper first.
Write full answers, then reveal the mark scheme and tick the points you earned (14 marks in total). Show all your working — method marks count. Your answers are saved on this device.
Question 1 [14 marks]
The library database has tables Member(MemberID, Name, Class) and Loan(LoanID, MemberID, BookID, DateOut, Fine).
(a) (a) State two reasons for entering data through a form instead of directly into the table. [2]
(b) (b) Describe how to create a query to list members of class 5A who owe a fine of more than $5. [4]
(c) (c) Write a calculated field to show Fine increased by 10%. [2]
(d) (d) Describe a report that lists loans grouped by class with a total fine per class. [4]
(e) (e) Distinguish between a form and a report. [2]
Find these in your own past-paper booklets for extra timed practice. Items above are written in the style of these papers; any adapted from a specific question say so.