This course on Access 2016 focuses on building queries in Access through 15 examples. By the end of the course, learners will be able to create various types of queries, such as those involving logical tests, aggregate calculations, formulas, expressions, and parameter queries. The teaching method involves a step-by-step demonstration of each query, along with explanations and examples. This course is intended for individuals looking to enhance their skills in database management and querying using Microsoft Access.
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
-
The Beginning Guide to Microsoft Access 2013
-
Microsoft Access Complete Beginner to Advanced
-
Ultimate Microsoft Access 2016 Course - Beginner to Expert
-
Microsoft Access 2016 Intermediate/Advanced Course
-
Microsoft Access 2016 Master Class: Beginner to Advanced
-
Excel for beginners:( PowerPivot, PowerQuery,Macros,VBA,DAX)
