[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...