[Part 4A] Query and Reports (Microsoft Access) Cambridge IGCSE ICT (0417)

In this tutorial you will learn what queries are, why we use them in databases, how to create a new query to filter your data and produce a report based on your query results. The tutorial is focused on the Cambridge 0417 ICT IGCSE examination and i solve the problems from an actual past paper to demonstrate the skills required. This particular paper has a basic query and a complex report. Part 4B has a simple query and a complex report. During the tutorial i expand on questions to cover skills required which are not covered i n this paper. 0:00 Intro to what queries, why we use them, analyzing a question paper 7:18 Creating a Query in Access 9:50 Adding a new field calculated at run time 11:20 format to fixed decimal places 11:55 completing the query 14:38 Creating the Report 15:34 Choosing the right view 17:33 Editing the report 18:00 Adjusting Field sizes to make sure all content visible 20:12 Adding calculated fields at bottom of report 25:00 Formatting fields as currency 27:29 Finishing the report, adding title and page footer The playlist with all the Access tutorials can be found here:    • Databases (Access) IGCSE 0417 ICT   Link to download the complete paper 2 used in this example: https://thejuniorschool-my.sharepoint...