Office 2016 40

Access 2016: Building Queries in Access (15 Examples)

DESCRIPTION

Topics in this Video:
(00:01) Introduction
(01:20) What is a Query?
(02:10) Query 01 Description and Sell Price
(06:50) Query 02 Product Records From SC
(08:40) Query 03 On Hand = 10
(09:57) Query 04 Sell Price $10 AND On Hand 8 (AND Logical Test)
(12:40) Query 05 Price Between $5 And $10 (AND Logical Test)
(16:05) Query 06 Sell Price 5 AND 10 (AND Logical Test)
(18:03) Rename Queries
(19:15) Query 07 Supplier Code Toy Records SC Or AP (OR Logical Test)
(20:43) Query 08 Ave Sell Price (Aggregate Calculation)
(22:28) Query 09 Ave Sell Price Group By Supplier
(23:17) What is Group By?
(24:23) Query 10 Min & Max Sell Price Group By Supplier
(25:18) Query 11 Inventory Value (Formula or Expression)
(28:50) Query 12 Gross Profit for each Product (Formula or Expression)
(30:40) Query 13 Products that Contain *rail* (Contains Query)
(32:20) Query 14Product Re-Order Phone List (Query based on Two Tables)
(35:04) Query 15 Records by Supplier (Parameter Query)
(36:45) Summary

NOTES

WORKBOOKS

Download “Office 2016 40” Office-2016-40.zip – Downloaded 5 times – 132 KB







Be the first to comment

Leave a Reply