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 ----
Sony A6400 DSLR - https://amzn.to/3IuDc7Y
AC Power Supply for A6400 - https://amzn.to/3IuQS30
SmallRig Cage with Silicone Handle - https://amzn.to/3ItGIzB
SmallRig Phone Cold Shoe https://amzn.to/412p39r
Sigma 16m F1.4 DC DN Contemporary Lens - https://amzn.to/3YFHLSB
Pronstoor Mini Teleprompter - https://amzn.to/3Ef6nJM

----- Lighting ------
Neewer 660Pro RGB Led Video Light - https://amzn.to/3XCfRph
Corsair iCUE LT100 Smart Lighting Towers - https://amzn.to/3I9Jc4B

------ Computer Setup -------
Asus Zenbook Pro Duo 4k - https://amzn.to/3lMKif5
Samsung M7 4k Smart Monitor - https://amzn.to/3IbZTwk
Corsair Sabre RGB Pro Gaming Mouse - https://amzn.to/3xtmgIC
Corsair K60 Pro TKL RGB Opto-Mechanical Gaming Keyboard - https://amzn.to/410MSym
Stream Deck - https://amzn.to/3S8vqUC

----- Audio Setup ----
Bose QC35 ii - https://amzn.to/3KbRuf6
Rode VideoMic GO II - https://amzn.to/3I9LjW5