top of page
BTEC IT Unit 2 Scenario 4 - The  Vehicle Rental Company

A set of teaching resources to help prepare for the 5 hour NEA exam. The resource is designed to follow the NEA format closely, with Part A being 3 hours and part B being 2 hours


This resource is based on the January 2022 Exam paper which made use of a Composite Primary Key field on the central Junction table.


The resource contains 15 new differentiated queries, 5 new reports and 4 new forms and makes extensive use of DateDiff() and IIF() functions. The resource is ideal for in-lesson activities or practice for homework.


The NEA exam usually has around 2 queries, 1 reports and 2 forms. This scenario has a range of questions for you to choose from so you can create an exam tailor made to your learners ability. In addition you will be able to have lots of practice questions before setting a timed 'real run'. These scenarios will then leave the Pearson SAMs and Past Papers available to you as full trial mocks.

Each classroom presentation goes through step by step how each table, report or form field was created with step by step guidance in the teacher notes on how the more complicated calculated fields were created. In addition it uses the Pearson guidance for the number of screenshots required as evidence.

BTEC IT Unit 2 Scenario 4 - The Vehicle Rental Company

  • " Your resources have been a lifesaver, to say the least! Thank you for the excellent and well-structured resources. Especially for Unit 2 where students really appreciated how it helped them prepare, step-by-step, for the controlled assessment.

    I could clearly see a marked improvement in students’ confidence after using your resources. So, a Big Thank You,  once again!"

    ​Ms Priya Suresh, Teacher of  Mathematics and Computer Science, East Coast College, Suffolk

bottom of page