NEW! JUNE 2023 EXAM - BTEC Level 3 Database Exam Walk Through (Part 2 ) Queries and Reports

In this video, I look at the creation of the 2 different queries and the report required in question 3 of the Database exam for unit 2 Creating Systems to Manage Information.
In the first of our queries, we will set conditions to show fields and hide others that are used with set criteria.
The second of the queries will include "iif" statements and calculated fields.
Finally, we use the report wizard along with customised fields and labels to present information that is required for the third part of the question

My Youtube setup

---- Camera Setup -----

------ Lighting -------

------- Computer Setup --------

------ Audio Setup -----

[unitedkingdom]

Part B was actually way easier than I thought it would be 😎

[hdsjdhks]

You're literally helping me so much right now, doing the exam in Jan, appreciate it so much bro, thank

[CaIIMeElla]

Thank you! Where can I find past papers for this ?? I’m struggling to find them

[Soap]

Edit: Didnt do well in the exam . It was hard . Ill definitely resit for sure. Btw could you do a video on normalisation?

[tomkrawec]

Thank you for this, always appreciated.

[unitedkingdom]

Also thank you so much for these videos, they help a lot

[sapherfin]

when I make the report the manufacturer_name isn’t under the Manufacturer_Id header but instead it’s just called header. Help me

[osyrus]

Is IIF the only function we need to know for the exams

[malakababs]

You have tuaght me more then my own teachers tysm but I don't understand activity 4 for part A very well could you pls go through that, I would appreciate it alot

[WaqasAhmed-kkcw]

Dear sir, can I ask when you are going to upload Paper B for June 2023 Exam? Waiting...
Thank you for all your hard work...