Task 10z | Chapter 10 Database | Cambridge AS IT 9626

Hi👋🏻, اهلاً وسهلاً 🔻To download the resources from: https://www.hachettelearning.com/answers-and-extras/cambridge-international-as-level-information-technology-student-s-book-answers ------------------------ This video explains how to group data in a Microsoft Access report and calculate average prices for each group, using two different methods. In Task 10Z, a report is created for the manager to display all product details, grouped by product type (Fridge or Freezer). The task builds on previous activities where product types were identified using queries, and this logic is reused here to support grouping. The video begins by creating a query that identifies whether each product is a fridge or freezer. This is done using: - The RIGHT function to extract characters from the model number - The IIF function to classify products as Fridge or Freezer - Debugging techniques to correct errors when the extracted text does not match expectations Once the query is complete and saved, the tutorial demonstrates two methods of grouping a report: Method 1 – Grouping during report creation - A report is created using the Report Wizard - The report is grouped by the Type field (Fridge / Freezer) - The wizard automatically organises the layout and grouping structure Method 2 – Grouping an existing report - A report is created without grouping - Grouping is later applied using Design View → Group & Sort - Manual layout adjustments are demonstrated, including: - Moving the Type field to the group header - Removing repeated fields - Adjusting spacing and alignment - Formatting headers for better presentation After grouping is complete, the video focuses on calculating average prices: - The average retail price is calculated separately for fridges and freezers - The difference between group averages and overall report averages is clearly explained - Unnecessary totals (such as grand totals) are identified and removed to match the question requirements Two approaches to calculating averages are shown: - Using Totals (right-click → Total → Average) - Using Group & Sort subtotal options to control where calculations appear (group footer vs report footer) Finally, the tutorial applies appropriate formatting: - Currency format - Two decimal places - Bold labels for clarity - Adjusted spacing for a professional report layout By the end of this video, students will understand how to: - Create queries using IIF and RIGHT - Group reports by a calculated field - Apply grouping during or after report creation - Calculate and format group-level averages - Avoid common mistakes in report grouping and totals This task is particularly important for exams, as it combines queries, grouping, calculations, and report formatting in a single activity.