← ACARA Digital Technologies Years 7–8

Database objects: table, query, form and report

The four database objects: a table stores records, a query finds records, a form enters records and a report presents them.

Part of: ACARA Digital Technologies Years 7–8 — Structured Data and Queries — Module 9, QCE Digital Solutions Unit 3 — Interactions Between Users, Data and Digital Systems — Module 91, WA Computer Science ATAR Year 11 — Data Management — Module 21

Understanding Database objects: table, query, form and report in ACARA Digital Technologies Years 7–8

What it does: A WHERE condition makes the query find only the matching records, such as students with more than 100 points. A form is a screen for entering data. Behind it, each filled-in form adds one new record to the table, like this INSERT. A table stores the records, arranged in fields (columns) and records (rows). The other objects use the data held in tables. A report presents records in an organised layout, often for printing or sharing, such as a class list. SELECT ... FROM is the code for a query, which finds and returns records from a table. Forms enter records and reports present them, so the two objects have been mixed up.

Common mistakes: Each field definition in a table must be separated by a comma. Line 3 is missing the comma after TEXT, so it should be ' firstName TEXT,'. A query names the table it reads with the keyword FROM. 'FORM' is a typo (and a form is a different database object). It should be 'SELECT firstName FROM students'.

Class: _____________________  ·  Name: _____________________  ·  Date: _________

Free printable worksheet with full answer key — or add this module to a class and your students practise it interactively.

🖨 Print worksheet + answer key Add Database objects: table, query, form and report to a class →

This module's key terms are also in a printable crossword (Modules 331–360) and word search (Modules 331–411).

Take this worksheet further — free with Cloodit

Each concept is reinforced from every angle — learned, then applied, then tested.

Learning
Duo
Which database object stores the records?
TableReport
Matches
A report is where you type in new records.
↓
This describes a form. A report presents records, for example as a neat printed summary.
Applying
Meanings
Term
table, query, form, report
Meaning
The four database objects: a table stores records, a query finds records, a form enters records and a report presents them.
Practice
SELECT firstName, house
Testing
Gaps
CREATE Students (name TEXT, year INT);
Check Answer
Spots
2 studentId INTEGER,
3 firstName TEXT

Cloodit turns curriculum-aligned coding content into journeys students work through one biome at a time.

The 'Moose' badge — Tundra Champion, one of Cloodit's 106 collectible badges
Students earn collectable badges

Over 100 of them, across seven natural biomes.

Study Buddy
Students build a real study resource

Turns their work into revision material ready for Flash Cards and Exam study.

Diamond Dash — one of Cloodit's live, competitive Sprint games
Students lock in with Sprints

Live, competitive practice for the start of the lesson or a teacher-led lesson finisher.

A Cloodit certificate of achievement, ready to personalise and print
Custom printable certificates

Honour your top performers, or encourage a student who's trying hard — ready to print in seconds.

Add to class →

Quick Questions

1. Which database object stores the records?
A. Report
B. Table ✓
A table stores the records, arranged in fields (columns) and records (rows). The other objects use the data held in tables.
2. Which database object finds records that match a condition?
A. Query ✓
B. Form
A query finds records. In SQL, a SELECT statement with a WHERE clause is a query.
3. Which database object is used to enter new records?
A. Form ✓
B. Query
A form gives a friendly screen for entering records, so you do not type straight into the table.
4. Which database object presents data in a neat, printable layout?
A. Table
B. Report ✓
A report presents records in an organised layout, often for printing or sharing, such as a class list.
5. A teacher wants a list of all Year 8 students in the Red house. Which object does she use?
A. Query ✓
B. Form
She is finding records that match a condition (yearLevel = 8 AND house = 'Red'), so she uses a query.

Match the Pairs

SELECT firstName, house FROM students; → A query that finds records and shows only the chosen fields from the students table
CREATE TABLE products (productId, name, price); → A table that stores records in fields, such as the products a shop sells
A query finds only the records that match a condition → SELECT * FROM students WHERE points > 100;
A form enters a new record into a table, one field at a time → INSERT INTO students VALUES (11, 'Sam', 'Ray', 7, 'Red', 0);
A report is where you type in new records. → This describes a form. A report presents records, for example as a neat printed summary.
A table finds the records that match a condition. → This describes a query. A table only stores records in rows and fields.

Key Term

table, query, form, report
The four database objects: a table stores records, a query finds records, a form enters records and a report presents them.

Fill in the Blanks

1. CREATE TABLE Students (name TEXT, year INT);
Hint: Type the keyword for the database object that stores records.
2. SELECT name FROM Students WHERE year = 7;
Hint: Type the keyword that starts a query to find records.
3. <form action="/add"> <input name="name"> </form>
Hint: Type the tag name for the object used to enter new records.
4. table: stores records query: finds records report: presents records
Hint: Type the name of the database object that presents records.
5. table: stores records form: enters records report: presents records
Hint: Type the verb describing what a form does with records.

Spot the Error

Question 1
A CREATE TABLE students (
B studentId INTEGER,
C firstName TEXT
D yearLevel INTEGER
E );
Line C — Each field definition in a table must be separated by a comma. Line 3 is missing the comma after TEXT, so it should be ' firstName TEXT,'.
Question 2
A -- Query: find Year 8 students
B SELECT firstName FORM students
C WHERE yearLevel = 8;
Line B — A query names the table it reads with the keyword FROM. 'FORM' is a typo (and a form is a different database object). It should be 'SELECT firstName FROM students'.
Question 3
A -- Form: Add Student
B INSERT INTO students
C (firstName, yearLevel)
D VALUE ('Kai', 7);
Line D — When a form saves a new record, the SQL uses the keyword VALUES (with an S) to give the data for the new record. It should be "VALUES ('Kai', 7);".
Question 4
A -- Report: points leaderboard
B SELECT firstName, points
C FROM students
D ORDER points DESC;
Line D — The sorting clause that a report uses to present records in order is ORDER BY. The word BY is missing, so it should be 'ORDER BY points DESC;'.
Question 5
A SELECT name products
B WHERE stock = 0;
C ORDER BY name;
Line A — A query must say which table the records come from using FROM. Line 1 is missing FROM, so it should be 'SELECT name FROM products'.

Student with a class code? Join your class →