This resource is relevant to:
- Pearson BTEC Level 3 National Extended Diploma in Information Technology
- Unit 2: Creating Systems to Manage Information
This booklet is part of a series. I do not suggest using it standalone.
It refers to a practice database made in booklet 1, which can be found for free here: https://www.tes.com/teaching-resource/resource-12945808
The resource is an 18 page booklet which takes students through all the validation rules, checks and lookups needed for Activity 2. Students will need access to Microsoft Access. By following the booklet, they will be able to complete Part A, Activity 2 of the Unit 2 Controlled Assessment.
Contents of booklet
- Part A Activity 2 explanation (8 marks)
- The 6 validation rules / checks / lookups
- Part A Activity 2 practice (Jan 2021 Smart Art)
- Input mask homework
- Video guidance (on YouTube) specifically for Activity 2
- Video tutorials (on YouTube) with guided tutorials for multiple previous papers
Get this resource as part of a bundle and save up to 56%
A bundle is a package of resources grouped together to teach a particular topic, or a series of lessons, in one place.
Something went wrong, please try again later.
This resource hasn't been reviewed yet
To ensure quality for our reviews, only customers who have purchased this resource can review it
Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.