Access 2003 IV Training

Main Menu

1 Day Course

Performance-based objectives

Share Access data with other applications.
Use VBA to automate a business process.
Create and modify a database switchboard, and set the startup options.
Secure databases.
Share a database using a SharePoint site.

Prerequisites

In this course you will deal with local database management, you will learn remote database management, how to exchange data with XML and other type applications, and how to automate your business processes by using VBA code. To ensure the successful completion of Access 2003 IV, we recommend completion of the following Element K courses, or equivalent knowledge from another source: Windows 2000: Introduction, Windows XP: Introduction, or Windows XP I and Windows XP II and Access 2003 I, Access 2003 II, and Access 2003 III.

Course Content

Lesson 1: Integrating Access into Your Business

1A: Import XML Data into an Access Database
1B: Export Access Data to XML Format
1C: Export Data to the Outlook Address Book
1D: Collect Data Through Email Messages
1E: Work with Attachments
1F: Save a Database as a Previous Version

Lesson 2: Automating a Business Process with VBA

2A: Create a Standard Module
2B: Develop Code
2C: Call a Procedure from a Form
2D: Run the Procedure

Lesson 3: Managing Switchboards

3A: Create a Database Switchboard
3B: Modify a Database Switchboard
3C: Set the Startup Options

Lesson 4: Distributing and Securing Databases

4A: Split a Database
4B: Implement Security
4C: Set Passwords
4D: Convert an Access Database to an ACCDE File
4E: Package a Database with a Digital Signature

Lesson 5: Sharing a Database Using a SharePoint Site

5A: Export a Table to a SharePoint List
5B: Import Data from a SharePoint List
5C: Publish a Database to a SharePoint Site
5D: Move a Database to a SharePoint Site
5E: Work Offline

For more information on Acumen Classes
Please contact Joann Etling 314.333.3330
or This e-mail address is being protected from spambots. You need JavaScript enabled to view it

1750 South Brentwood Blvd.
Suite 200
Saint Louis, MO 63144