Access Level 4: Advanced Design & VBA

Level 4Full Day1 DayVersion 365Official CPE Provider

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