Database design — tables, queries, forms

What you'll learn

1. 1

   Think of a database like a digital filing cabinet. Each drawer is a table, and each file is a record.

2. 2

   What is a row in a database table called?

3. 3

   Drag the fields into the correct order for a 'Students' table: StudentID, FirstName, LastName, DateOfBirth.

4. 4

   Let's build a query to find all students in Year 10. A query asks the database a question.

5. 5

   What does a query do?

6. 6

   A form is like a friendly screen that helps you enter data into a table. Instead of typing into a spreadsheet, you fill in a form!

7. 7

   Which is the best tool for entering a new student's details?