Access 365 - Advanced

Overview

About this course

Self-paced lessons on advanced Access in Microsoft 365: database structure, maintenance, navigation forms and startup options.

Curriculum

Curriculum

8 modules

Introduction

Using the Table Analyzer Wizard
Append Querying to Normalize a Table
Creating a Junction Table

Backing Up a Database
Using the Compact and Repair Database Tool
Using the Object Dependencies Tool
Using the Database Documenter Tool
Using the Analyze Performance Tool

Creating a Navigation Form
Modifying a Navigation Form
Setting the Startup Options

Using the Database Splitter
Configuring Trusted Locations
Password Protecting a Database
Password Protecting Modules
Converting a Database to an ACCDE File

Understanding VBA Basics
Exploring Variables and Control Flow Statements
Exporting a Table or Query with VBA
Converting a Macro to VBA

Understanding Table Events
Using the Before Change Event Command
Using the After Update Event Command

Course Recap

Who it's for

Who it's for

Access 365 users managing larger databases.

Before you start

No formal prerequisites. Bring curiosity and a willingness to practise.