Completed
) Introduction
Class Central Classrooms beta
YouTube playlists curated by Class Central.
Classroom Contents
Access 2016 - Building Queries in Access
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction
- 2 ) What is a Query?
- 3 ) Query 01 Description and Sell Price
- 4 ) Query 02 Product Records From SC
- 5 ) Query 03 On Hand = 10
- 6 ) Query 04 Sell Price $10 AND On Hand 8 (AND Logical Test)
- 7 ) Query 05 Price Between $5 And $10 (AND Logical Test)
- 8 ) Query 06 Sell Price 5 AND 10 (AND Logical Test)
- 9 ) Rename Queries
- 10 ) Query 07 Supplier Code Toy Records SC Or AP (OR Logical Test)
- 11 ) Query 08 Ave Sell Price (Aggregate Calculation)
- 12 ) Query 09 Ave Sell Price Group By Supplier
- 13 ) What is Group By?
- 14 ) Query 10 Min & Max Sell Price Group By Supplier
- 15 ) Query 11 Inventory Value (Formula or Expression)
- 16 ) Query 12 Gross Profit for each Product (Formula or Expression)
- 17 ) Query 13 Products that Contain *rail* (Contains Query)
- 18 ) Query 14Product Re-Order Phone List (Query based on Two Tables)
- 19 ) Query 15 Records by Supplier (Parameter Query)
- 20 ) Summary
