Last updated
1 November 2024
Share this 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
Tes paid licenceHow can I reuse this? 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.
Bundle
BTEC IT Unit 2 Databases bundle (56% off, 11 packs of resources covering every aspect of the assessment, pre-2024 exams only) This bundle has all the booklets, written walkthroughs, video walkthroughs, and ERD / Normalisation practice sheets **uploaded in my first year uploading to this site**. 2024 resources are NOT included. You can find those here: https://www.tes.com/teaching-resource/resource-12945635
The booklets in this bundle cover all activities, with reference to past papers and their answers throughout.
Written and VIDEO answer walkthroughs for the June 2022 (Automatic Vending) paper, covering **all activities** in that paper. Also, the same for both the June 2023 (Heather Burn Caravan) paper and for the Jan 2023 (Martlepool College LFC) paper.
*There are free taster videos on their respective pages. They are combined together in this free pack:* https://www.tes.com/teaching-resource/free-taster-videos-for-unit-2-databases-video-walkthroughs-covering-multiple-papers-and-activities-12951622.
Activity 1 / Entity Relationship Diagram / Normalisation practice sheets, booklets, and detailed answers so students can understand *why* the answer is what it is (because of junction tables, composite keys, and more).
Reviews Select overall rating (no rating)
Write a review
Update existing review
Submit review Cancel
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 resource to let us know if it violates our terms and conditions.
