Microsoft Access Advanced

Formats ⟩ Live Virtual: 4 hrs./1 Day | In-Person: 6 hrs./1 Day

This course teaches advanced Access® features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multiple-user access, and more. Knowledge of these features separates database professionals from casual database users or occasional designers.

Course Prerequisite: Microsoft Access Intermediate

Learning Objectives »

Share data across applications
Use action, unmatched, and duplicate queries
Create complex reports and forms
Use macros to improve user interface design
Use VBA to extend database capabilities
Backup, compact, repair, perform analysis, check object dependencies, and document

Course Agenda

Importing and Exporting Table Data

Import and Link Data
Export Data
Create a Mail Merge

Using Queries to Manage Data

Create Action Queries
Create Unmatched and Duplicate Queries

Creating Complex Reports and Forms

Create Sub-Reports
Create a Navigation Form
Show Details in Sub-Forms and Popup Forms

Creating Access Macros

Create a Standalone Macro to Automate Repetitive Tasks
Create a Macro to Program a User Interface Component
Restrict Records by Using a Condition
Create a Data Macro

Managing a Database

Back-Up a Database
Manage Performance Issues
Document a Database

Using VBA to Extend Database Capabilities

Getting Started with VBA
Using VBA with Form Controls

Distributing and Securing a Database

Split a Database for Multiple-User Access
Implement Security
Convert an Access Database to an ACCDE File
Package a Database with a Digital Signature