|
Access 2007 - Level 3
Duration:
1 Day
Overview:
In this
course, students will exchange data with other applications, automate
business processes by using VBA code, and secure and share databases.
Pre-requisites:
Access 2007 Level 2 or equivalent knowledge
Outline:
|
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 |
Back to Office 2007
Course List
|