Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Udemy

Microsoft Access Complete Beginner to Advanced

via Udemy

Overview

Ultimate Microsoft Access Training - Create & Maintain Access Tables, Access Queries, Access Forms, Access Reports

What you'll learn:
  • Manage Large Sets of Data in Microsoft Access Relational Design
  • Build an Efficient Database Table Design
  • Control User Data Entry Effectively
  • Build Dynamic Access Database Queries
  • Present Dynamic Reports
  • Build Automation, Saving Time and Money

Microsoft Access all in One Package

This Microsoft Access course combines 4 different courses.

  • Microsoft Access 101 - An Introduction to Access and Table Design

  • Microsoft Access 102 - Access Queries

  • Microsoft Access 103 - Form and Reports

  • Automate Microsoft Access Tasks with Macros and VBA

Each Section, (Intro/Tables, Queries, Forms, Reports and Macros/VBA), will start at the basic level and progress to an advanced level with the section.

Material recorded with Access 2016 but works in 2007, 2010, 2013, 2016, 2019, Microsoft 365/2025

Enroll now to go through a deep dive of the popular end-user relational database tool, Microsoft Access. As your instructor I will use my 15+ years of Access training to guide you step by step through the beginner to advanced level and beyond.

As you participate in each of the 4 courses you will master Access tools that will clear away the pain of stumbling through your daily tasks. You will start with the basics, building a solid foundation that will give you further knowledge as you progress into intermediate and advanced level topics.

At completion of this course you will have mastered the most popular Access tools and come out with confidence to complete any Access tasks with efficiency and grace. Below are just a few of the topics that you will master:

  • Creating Effective Database Tables

  • Understanding Table Relationships

  • Building Dynamic User Data Forms

  • Effectively Retrieve Data Using Access Queries

  • Build Effective Reports

  • Automate Access Database Tasks with Macros and VBA

So, what are you waiting for, enroll now and take the next step in mastering Access and go from Access Newb to Access Guru!

Syllabus

  • 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 Switchboard
  • 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

Taught by

Kyle Pew

Reviews

4.7 rating at Udemy based on 9469 ratings

Start your review of Microsoft Access Complete Beginner to Advanced

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.