 |
Courses & Certifications
|
 |

Microsoft Access 2007 - Level 3 - Advanced |
This course has been designed exclusively for Microsoft Access 2007.
For earlier versions of Access please follow this link |
|
Dates for next course: | Call 02 4969-0690 for the next course date |
| Training Format: |
Classroom |
| Price: | Call 02 4969-0690 for pricing |
Overview
In this course, students will exchange data with other applications, automate business processes by
using VBA code, and secure and share databases. (Second Edition)
Lesson 1: Integrating Access into Your Business
- Import XML Data into an Access Database
- Export Access Data to XML Format
- Export Data to the Outlook Address Book
- Collect Data Through Email Messages
Lesson 2: Automating a Business Process with VBA
- Create a Standard Module
- Develop Code
- Call a Procedure from a Form
- Run a Procedure
Lesson 3: Managing Switchboards
- Create a Database Switchboard
- Modify a Database Switchboard
- Set the Startup Options
Lesson 4: Distributing and Securing Databases
- Split a Database
- Implement Security
- Set Passwords
- Convert an Access Database to an ACCDE File
- Package a Database with a Digital Signature
Lesson 5: Sharing a Database 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
|
Forsythes IT & Training provides instructor led computer training on the Microsoft Office and Adobe range of applications.
We service Newcastle, the Hunter Valley, Lake Macquarie and the Central and Northern Coasts of New South Wales (NSW) Australia.
With our mobile training room we can provide a range of courses on-site at your premises.
|
|
 |
|