Office 2016 Video #40: Access 2016: Building Queries in Access (15 Examples)

) Introduction.
) What is a Query?.
) Query 01 Description and Sell Price.
) Query 02 Product Records From SC.
) Query 03 On Hand = 10.
) Query 04 Sell Price $10 AND On Hand 8 (AND Logical Test).
) Query 05 Price Between $5 And $10 (AND Logical Test).
) Query 06 Sell Price 5 AND 10 (AND Logical Test).
) Rename Queries.
) Query 07 Supplier Code Toy Records SC Or AP (OR Logical Test).
) Query 08 Ave Sell Price (Aggregate Calculation) .
) Query 09 Ave Sell Price Group By Supplier.
) What is Group By?.
) Query 10 Min & Max Sell Price Group By Supplier.
) Query 11 Inventory Value (Formula or Expression) .
) Query 12 Gross Profit for each Product (Formula or Expression).
) Query 13 Products that Contain *rail* (Contains Query).
) Query 14Product Re-Order Phone List (Query based on Two Tables).
) Query 15 Records by Supplier (Parameter Query).
) Summary.