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