Microsoft Access Complete Course: Beginner to Advanced

8 Reviews
524 Enrolled
13 Hours
You save 75%

172 Lessons (13h)

  • Course Introduction and Exercise Files
  • Access Overview - Quick Overview of Access Interface
  • Access Overview - Fundamentals of Access Objects
  • Access Tables - Working with Table Data
  • Access Tables - Creating Tables in Your Access Database
  • Access Tables - Microsoft Access Table Exercise
  • Access Tables - Working with Access Table Relationships
  • Access Queries - Working with Access Select Queries
  • Access Queries - Query Calculated Fields
  • Access Queries - Summarizing Data in an Access Query
  • Access Queries - Working with Access Action Queries
  • Access Queries -- Querying Multiple Tables with Query Joins
  • Access Queries - Parameter Queries
  • Access Forms - Building Data Entry Forms
  • Access Forms - Working with Form Data
  • Access Forms - Form Controls
  • Access Forms - Formatting Options
  • Access Forms - Building a Database Swithboard
  • Access Forms - Interacting with Queries through Forms
  • Access Reports - Building an Access Report
  • Access Reports - Creating Calculated Controls
  • Access Reports - Advanced Report Group Options
  • Getting Started with Microsoft Access VBA
  • Working with Access VBA SUB Procedures and Functions
  • Understanding and Working with Access Objects with VBA
  • Foundational VBA Programming Concepts
  • Working with the Access Recordset Object
  • Debugging Access VBA Code
  • Access VBA - Project #1 Working with Access VBA SUB Procedures

Master All Microsoft Access Tools in One Package

Kyle Pew


Kyle Pew is a Microsoft Certified Trainer (MCT) and a certified Microsoft Office Master Instructor and has been teaching and consulting for the past 10+ years on various computer applications, including Microsoft Office Suite, SharePoint End-User, and VBA (Excel and Access).


Deep dive into the popular end-user relational database tool, Microsoft Access with this comprehensive course! This Microsoft Access course combines four different courses in one. Jump in, and you'll walk through everything from the absolute Access basics to more advanced concepts, like building dynamic user data forms and effective reports. By the end of the course, you'll have the know-how required to create effective database tables, automate tasks, and more with this powerful tool.

  • Access 172 lectures & 13 hours of content 24/7
  • Explore creating effective database tables & understanding table relationships
  • Gain knowledge on retrieving data using access queries
  • Get a grip on building dynamic user data forms & effective reports
  • Learn to automate Access database tasks w/ Macros & VBA


Important Details

  • Length of time users can access this course: lifetime
  • Access options: web & mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 15 days of purchase
  • Experience level required: beginner


  • Windows machine w/ Microsoft Access 2007, 2010, 2013 & 2016</ul


  • Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.
Your cart is empty. Continue Shopping!
Processing order...