Access 2016 - Advanced

Overview

About this course

Self-paced lessons on advanced Access 2016: improving database structure, maintenance, switchboards and configuration.

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 Performance Analyzer Tool

Understanding the Access Switchboard
Using The Switchboard Manager
Modifying a Switchboard
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 Change Event Command

Course Recap

Who it's for

Who it's for

Users maintaining Access 2016 databases.

Before you start

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