MS Access Lesson – Relationships, Primary and Foreign Keys KS3/KS4 ICT

This fully resourced ICT lesson introduces students to relationships, primary keys, and foreign keys in Microsoft Access, showing how relational databases are structured and why key fields are essential. It is part of a six-lesson series modelled around the EDEXCEL IGCSE ICT specification but suitable for any curriculum.

The lesson is built around a Ferrari World theme park (UAE) case study and includes:

Literacy, numeracy, and thinking settler activity

Flashcards for all key terms

Explainer slides for clear, step-by-step learning

Practical activities for creating relationships and assigning keys

One teacher tutorial video

MP4 and YouTube video versions for flexible delivery

Google quizzes for retrieval practice (basic and advanced)

Full series topics:

Data Types and Data Entry

Key Relationships and Key Types

Validation & Sorting

Queries & Operators

Reports & Mail Merge

Revision (37 flashcards and a range of revision activities)

This lesson has been successfully used with English as an Additional Language (EAL) students in an international school setting, providing accessible explanations and practical tasks to ensure students of all abilities can achieve success.

All profits from this resource support charitable initiatives, including refugee assistance, youth sports, educational programmes, and environmental carbon capture, making our work carbon negative.