Microsoft Access Full Course Tutorial - Beginner to Advanced

Overview

Learn Data Science. Courses starting at $12.99.

This comprehensive tutorial on Microsoft Access guides you through transforming scattered data into a centralized database solution. Perfect for business analysts, administrative professionals, and small-business users with basic Office familiarity who need to organize customer, order, or inventory information efficiently. Learn to navigate the Access interface, create and manage tables, establish relationships with referential integrity, build queries using both Design View and SQL, design user-friendly forms, craft professional reports, and automate tasks with macros and VBA modules. The nearly 5-hour training progresses from beginner concepts (interface navigation, table creation) through intermediate skills (complex queries, action queries, parameters) to advanced techniques (custom forms with buttons, detailed reports, and VBA programming). Compatible with Access 2013 or later, including Access for Microsoft 365, this step-by-step guide teaches practical database management skills like setting field properties, creating input masks, establishing default values, and implementing lookup lists to make your database both powerful and user-friendly.

Syllabus

Start 0:00
Introduction 0:09
Access Startup Page 1:23
Access Interface 3:06
Access Objects 5:20
Tables 6:01
Queries 7:30
Forms 8:20
Reports 9:18
Macros and Modules 9:50
Working with Tables 12:04
Sorting and Filtering 19:29
Creating a Table 39:05
Field Properties 1:00:37
Look Ups for Dropdown Lists 1:16:32
Creating More Tables 1:17:20
Creating Relationships and Trouble Shooting 1:24:20
Using Lookup Wizard to Create Relationships 1:34: 29
Beginner Conclusion 1:39:27
Microsoft Access Intermediate Introduction 1:39:51
Creating a Query 1:40:55
Using Criteria to Filter Queries 1:45:40
Data Type Mismatch 1:47:43
Using AND,OR, & BETWEEN Conditions 1:49:23
Sorting Queries 1:55:42
Using Table Fields with Our Criteria 2:00:02
Wild Cards and Saving Queries 2:03:17
Calculated Fields 2:05:22
Month and Month Name Functions 2:09:52
Dated iiff Function 2:18:37
IF Function 2:23:38
Data Summaries 2:29:36
Crosstab Query 2:34:39
Creating a Table with Action Queries 1:38:52
Updating Data with Action Queries 2:43:17
Delete Query 2:47:58
Appending Tables 2:49:46
Query Join Types 2:52:03
Creating Parameter Queries 2:55:04
Intermediate Conclusion 3:01:52
Access Advanced Introduction 3:02:15
Creating a Form 3:02:35
Working with Forms 3:17:17
Form Controls and Calculated Fields 3:21:10
Adding Buttons and Formatting our Forms 3:29:25
Using Forms to Interact with Queries 3:35:07
Building a Report 3:48:03
Grouping and Sorting 4:04:20
Intro to VBA with Access 4:18:36
Searching Records with VBA 4:29:27
Advanced Conclusion 4:45:21