Task 10t | 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 calculate and display the price per cubic centimetre for fridges and freezers using a calculated field in an Access query, and how to present the results in a report. In this task, the lesson continues using the database from Task 10R. The objective is to display product details for fridges and freezers, including their prices, capacities, types, and the price per cubic centimetre, making it easier to compare items. The video begins by creating a new query based on the Product table. All relevant product details are added, along with the Type field that was created earlier using the IIF and RIGHT functions to classify items as either Fridge or Freezer. Next, the tutorial demonstrates how to create a calculated field to work out the price per cubic centimetre: - A new field named Price per cubic cm is created. - The calculation divides Retail Price by Capacity, with both fields referenced correctly using square brackets. - The result is then formatted as Currency with two decimal places using field properties. After confirming the query results, the video shows how to convert the query into a report: - The query is selected as the data source. - All fields are added to the report. - Minor layout adjustments are made to improve readability, including resizing and repositioning columns such as model number, price, capacity, type, and price per cubic centimetre. By the end of the video, viewers will understand how to create calculated fields for unit pricing in Access and how to present the results clearly using a formatted report.