Task 10u | 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 the number of days between an order date and a collection date using a calculated field in Microsoft Access, and how to present the results in a report. In this task, the objective is to display detailed invoice information, including invoice number, product model, quantity, order date and time, collection date and time, customer name, and the number of days taken from placing an order until it is collected. The video begins by showing how all the required fields are added to a query from the relevant tables. The main focus is then on creating a new calculated field to determine the number of days between two dates. The tutorial demonstrates how to: - Create a new field named Days using a calculation that subtracts Order_Date from Collect_Date, - Ensure correct field names and spelling (including underscores), - Set the field format to General Number so the result displays correctly as the number of days. Once the calculation is verified, the video shows how to save the query and convert it into a report. The report is created without grouping and is formatted in landscape view to ensure all fields are clearly visible. Final layout adjustments are made to improve readability. By the end of the video, viewers will understand how to calculate date differences in Access queries and present time-based data effectively in a professional report.