Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Master Access 2021: Advanced Microsoft Access Course
Section 1: Introduction
Course Introduction (2:08)
Set Up for Success in Access 2021 (3:02)
DOWNLOAD ME: Course Exercise Files
DOWNLOAD ME: Course Instructor Files
Section 2: Primary Keys and Indexes
Primary Keys and Indexing Rules and Guidelines (9:22)
More About Indexes (8:05)
Section 3: Using Datasheet View
Setup the Northwind Database (3:17)
Work in a Datasheet View (11:00)
Customize Datasheet View (9:03)
Advanced Sorting and Filtering in Datasheet View (8:24)
Subdatasheets (8:19)
Exercise 01 (0:52)
Section 4: Linking to Other Access Databases
Linking Two Tables to Other Access Databases (11:37)
Section 5: Using ODBC and SQL Server
Install SQL Server Express (9:24)
Setup SQL Server Express (9:42)
Exercise 02 (1:14)
Section 6: Splitting an Access Database
Splitting an Access Database into Frontend and Backend (7:35)
Convert To Local Table (7:47)
Addressing Multi-user Issues when Sharing Data (10:14)
Exercise 03 (1:53)
Section 7: Macros
Basics of Macros (7:35)
Macro on Events; AutoExec (11:07)
More About AutoExec (11:50)
Macro Security Settings (5:49)
Exercise 04 (2:46)
Section 8: The Ribbon
Customize the Quick Access Toolbar and Tabs (9:57)
Section 9: Visual Basic for Applications
Convert Macros to VBA (9:41)
Run VBA Code and Error Handling (11:41)
Create Modules: Subs, Functions, Intellisense and Variables (9:59)
Scope, Variable Naming and Strings (10:20)
Standard Functions: Logical, Case and Loops (11:05)
Section 10: Access Events Model
Adding Events to Assets Database (6:47)
Exercise 05 (1:55)
Common Events: Form and Report Events (6:49)
Switchboard, Navigation Forms and Error Handling (13:53)
Exercise 06 (5:06)
Section 11: Forms
Formatting Bound and Control Forms (9:28)
Split Forms and Macro Error Handling (11:59)
Creating Form with Tab (9:04)
Go To Combo Box and Its Properties (11:47)
Exercise 07 (4:58)
Section 12: Advanced Use of Queries
Basics of Queries (11:19)
Syntax of SQL Statements (12:42)
Use of Multiple Where Criteria & Select Statements Function (10:32)
Joins and Join Types (11:34)
Exercise 08 (0:37)
Action Queries - Part 1 (10:50)
Action Queries - Part 2 (10:46)
Subqueries (3:59)
Section 13: Protecting the Database and Code
Protect the Database and VBA Code (7:12)
Exercise 09 (0:56)
Section 14: Conclusion
Course Close (2:31)
Certificate of Completion and Course Quiz
Setup the Northwind Database
Complete and Continue