BTEC IT Unit 2 Databases Queries and Reports (Part A, Activity 3)

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 a detailed 33 page booklet which takes students through the intricacies of creating queries and reports Activity 3. Students will need access to Microsoft Access. By following the booklet, they will be able to complete Part A, Activity 3 of the Unit 2 Controlled Assessment.

Contents of booklet

• Part A Activity 3 explanation (12 marks)
• Query 1: Repeating the query from the introduction booklet
• Query 2: learning about the Total row and creating calculated fields / expressions
• Query 3: using an IIf function to decide true/false based on a value
• Creating and formatting a report: Input mask and lookup practice, including our first ever report (using Report Wizard)
• Skills for producing more detailed reports (both for showing existing data and making calculations on that data)
• Exam practice on both queries and reports: Part A Activity 3 practice (Jan 2021 Smart Art)