MS Access Lesson – Reports and Mail Merge KS3/KS4 ICT

This fully resourced ICT lesson teaches students how to generate professional reports and perform mail merges in Microsoft Access, developing both practical database skills and theoretical understanding. 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 step-by-step guidance

Practical activities for creating reports and integrating with Microsoft Word for mail merge

Two teacher tutorial videos

MP4 and YouTube video versions

Access to Google quizzes for effective 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, with clear instructions and differentiated resources that make learning accessible while maintaining challenge.

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