EdExcel ICT iGCSE Databases Practice MS Access

Two Pearson Edexcel iGCSE ICT (4IT1) Paper 2-style database practice assessments with ready-made Access databases, question papers and full mark schemes.

Give your iGCSE ICT pupils real practice for the database task in Paper 2 (Practical). This pack has two complete, ready-to-use practice assessments for specification topic 6.2 Database management. Each one is set in a realistic business scenario and comes with everything you need to run it in the lab: the pupil question paper, a working Microsoft Access database, a logo image, an evidence document, and a teacher mark scheme in PDF and editable Word format.

What’s included

Practice Assessment 1 – Al Noor Events
An events company in Saudi Arabia’s Eastern Province plans weddings, birthdays and corporate events. It keeps its data in a relational database with two linked tables, CLIENTS and EVENTS, with referential integrity enforced.

• Question paper (PDF, 3 pages)
• Mark scheme (PDF and editable DOCX, 3 pages)
• AL NOOR EVENTS.accdb, the Access database with sample data
• AL NOOR LOGO.png, for the form and report tasks
• EVIDENCE.docx, a structured answer document for screenshots and written answers

Specification coverage (4IT1 6.2)
Relational database structure, primary and foreign keys, data types, validation and lookup lists, sorting, single- and multiple-criteria queries (AND, OR, NOT, relational operators, dates), forms for consistent data entry, and reports produced from saved queries.

Ideal for

• End-of-unit practice before a database assessment
• Mock exam preparation for Paper 2
• Timed lab practice, homework or cover lessons
• Teaching examination technique: screenshot evidence, exact field order, sort order and house-style requirements

Notes

The databases are .accdb files for Microsoft Access.
Dates use DD/MM/YYYY format. Set Windows’ regional settings to English (United Kingdom) so date queries work correctly.
The scenarios and data are original and fictional.