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

Link to download the complete paper 2 used in this example:

[channbin]

my exam is literally tomorrow and i never understood how to do queries and reports till i watched this!! thank you so much😭🙏

[彗鑫]

fantastic tutorial! this helps me so much on understanding access and the test coming this Friday! thank you sir

[birungiannitah]

Thank you so much for your videos. I am a trainer of microsoft office applications but didnt have any idea about acces. But i have just landed on your channel and i am learning a lot. Thanks alot one again. You have earned yourself a new subscriber

[potentialofprotonis]

paper in a few hours!
@ 30:15, what if they ask that the data has to be sorted by a certain name, eg- the report must contain data of only the word 'William' in it; it could be 'william shakespere' or 'william randomsurname' too, how do we sort them exclusively?

[kavish]

i do have my ict practicals of paper 2 tomorrow...in this past 2 years i litterally had no idea about database nd stuff but ur videos helped me a lot sir. thnx for ur help..probably will score good tomorrow coz its my final exam.

[Toothspace]

This is well made video. Thank you for this sir! Wish the graphics used to explain query and report differences were more concise! Have a great day

[camilaurgel]

Thank you so much this helps me a lot for my exam on Tuesday!!

[akj_]

Thank you so much for your help with this!! i'm really understanding a lot, i hope this helps me with my board exam tomorrow.

[sarakadwani]

really thanks for this! this is helping in my igcse coming up next week!

[fumezzzzz]

You can do the sorting of the columns in the report in the layout view a lot easier

[Akshay_jsgs]

thank you i have my exams on tueasday and this helps me a lot

[joejrkamalizeni]

I feel like theres a mistake on where it says... Show only results where ready is no and sold is yes... But you made them all as no or yes. Isnt it supposed to be those that were already no are the ones to be included in the query?

[MinaTchassama]

sir please how do you identify what goes in the query and in the report

[theram]

thanks mate got an exam this morning😭💀🙏🙏

[emanay_]

This helped alot for my upcoming igcse exam in a week!! just a qs tho, they said make sure the report fits in 1 page right? but your report was 3pages long so im confused if when you print it will it be printed on 1 page or 3?

[ananyasharma]

when u did the count record thing was it only counting for price or for the whole thing?

[someoneyk]

Do you have vids like this for excel? Especially nested if functions

[chisommogbolu]

Is relationship meant to be done before query and report

[Arielah-c]

Never understood this in class and I have an exam tomorrow🙏😭

[firdoushasan]

hi sir is it for all the papers that the first three bullet points will be the question for creating a querry or does it depend?