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: Level 4, we recommend completion of the following Element K courses, or equivalent knowledge from another source:
Windows 2000: Introduction, Windows XP: Introduction, or Windows XP: Level 1 and Windows XP: Level 2 and Access 2003: Level 1, Access 2003: Level 2, and Access 2003: Level 3 .
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 Information Contact
Rhuann Heimann 618-523-4893
This e-mail address is being protected from spambots. You need JavaScript enabled to view it
www.trainatacumen.com
|
