Access Level 4: Advanced Design & VBA

Level 4Full Day1 DayVersion 365Official CPE Provider

Turn an Access database into a secured, automated business tool. Automate tasks with VBA, build switchboards and startup routines, split and lock down your database, and share it with the users.

Course Objective

Students will integrate Access with other applications, automate business processes with VBA, build and manage database switchboards, secure and distribute a database, and share data through a SharePoint site.

Prerequisites

To ensure your success, we recommend that you have experience with advanced Access queries, forms, reports, and macros. Students can obtain this level of skill through our Access Level 1, 2, and 3 courses. This course introduces VBA programming and is technical in nature.

Course Outline

5 lessons · 20 topics

1Integrating Access into Your Business

Import and Export Data
Export Data to the Outlook Address Book
Collect Data Through Email Messages

2Automating a Business Process with VBA

Create a Standard Module
Develop Code
Call a Procedure from a Form
Run the Procedure

3Managing Switchboards

Create a Database Switchboard
Modify a Database Switchboard
Set the Startup Options

4Distributing and Securing a Database

Split a Database
Implement Security
Set Passwords
Convert an Access Database to an ACCDE File
Digital Signature Overview

5Sharing Databases Using a SharePoint Site

Export a Table to a SharePoint List
Import Data from a SharePoint List
Publish a Database to a SharePoint Site
Move a Database to a SharePoint Site
Work Offline

Excel Solutions Team
Kirkwood Tower, 11757 Katy Fwy, Suite 1300, Houston, TX 77079
(713) 589-2655 · contactinfo@excelsolutionsteam.com · excelsolutionsteam.com

Official CPE Provider (TX State Board of Public Accountancy)
BBB Accredited since 2006 · 20+ years training Houston professionals