Dive into the world of database querying with this comprehensive 38-minute video tutorial on building queries in Access 2016. Learn essential concepts and techniques through 15 practical examples, starting with basic queries and progressing to more advanced topics. Explore how to filter data, use logical operators, perform aggregate calculations, create formulas, and work with multiple tables. Master skills such as renaming queries, using parameters, and implementing 'Contains' queries. Ideal for students and professionals looking to enhance their database management abilities, this tutorial provides a solid foundation for efficiently extracting and analyzing data in Access 2016.
Overview
Syllabus
) 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.
Taught by
ExcelIsFun
Related Courses
-
Ultimate Microsoft Access 2016 Course - Beginner to Expert
-
Excel for beginners:( PowerPivot, PowerQuery,Macros,VBA,DAX)
-
Ultimate Microsoft Office; Excel, Word, PowerPoint & Access
-
Transform Data Sets Using Advanced Filter - Excel 2016
-
Logical Tests - Excel Formulas, Conditional Formatting, PivotTables, Power Query, and More
-
Extract Records With Multiple Contains - Partial Text Criteria: 4 Examples
