Access 2013 - Advanced

Overview

About this course

Self-paced lessons on advanced Access 2013: improving structure, maintaining databases and switchboards.

Curriculum

Curriculum

8 modules

Introduction

Using the Table Analyzer Wizard
Using an Append Query to Normalize a Table
Creating a Junction Table to Manage a Many-to-Many Relationship

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 Access Switchboards
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 an Access Database to an ACCDE File

Understanding VBA Basics
Exploring Variables and Control Flow Statements
Using VBA to Export a Table or Query to Excel
Using VBA to Export the Specified Table or Query to Excel
Using VBA to Create a Custom Switchboard
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

Users maintaining Access 2013 databases.

Before you start

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