203-220-2218
skip to the main content area of this page
Training: Course Outline

2008 Training Schedules

To register call:
1-203-220-2218

Access 2007, Expert

In previous levels, you were introduced to the various features of Access 2007 that dealt with local database management. However, effective database management calls for mastering the advanced administrative and collaborative features of Access. In this course, you will exchange data with other applications, automate business processes by using VBA code, and secure and share databases.

Audience

This course is designed for students who have a thorough understanding of the basic and advanced user features of the Microsoft® Office Access™ 2007 application, and are interested in learning introductory level administrator skill sets. The course is also for the student that may be working in a web-based environment and may need to adapt Access applications to the environment. It is also designed for students pursuing the Microsoft MOS Expert Level Certification for Access 2007.

Prerequisites
  • To ensure the successful completion of Microsoft Office Access 2007: Expert, the following courses or equivalent knowledge is recommended: Microsoft Office Access 2007: Introduction, Microsoft Office Access 2007: Intermediate, Microsoft Office Access 2007: Advanced

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

  • 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.

Course Contents
  • 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
    • Work with Attachments
    • Save a Database as a Previous Version
  • Automating a Business Process with VBA
    • Create a Standard Module
    • Develop Code
    • Call a Procedure from a Form
    • Run the Procedure
  • Managing Switchboards
    • Create a Database Switchboard
    • Modify a Database Switchboard
    • Set the Startup Options
  • 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
  • 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

Student Responsibilities
In order for a class to be successful, all students should share the same general level of knowledge and experience. If a participant does not demonstrate these, the instructor will take the necessary steps either to prepare the participant or place him/her in a more appropriate course. This policy is intended to maintain the high level of quality control that you have come to expect.
<< Back to Schedule