Access 2007: Application Development

The page you requested does not exist. A search for resource OR center OR learning OR center OR marketing OR training resulted in this page.

Course Specifications:

Courseware: Microsoft Office Access 2007: Level 4

Software: Access 2007

Course length: 1 day

Course times: 8:30 a.m. - 4:30 p.m.

Course Description:

In previous courses, 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. This course will cover the essentials of Access database administration.

Course Objective:

You will exchange data with other applications, automate business processes by using VBA code, and secure and share databases.

Target Student:

This course is designed for students who have a thorough understanding of the basic and advanced user features of the Access 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.

Prerequisites:

To ensure the successful completion of Excel 2002: Intermediate we recommend completion of the following MicroAssist courses, or equivalent knowledge from another source:

  1. Access 2007: Introduction
  2. Access 2007: Intermediate
  3. Access 2007: Advanced

Delivery Method:

Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities. Each student is provided with a computer and a Manual. The manual is the student's to keep and makes an excellent reference guide.

Course Content:

Lesson 1: Integrating Access into Your Business

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

Lesson 2: Automating a Business Process with VBA

  1. Topic 2A: Create a Standard Module
  2. Topic 2B: Develop Code
  3. Topic 2C: Call a Procedure from a Form
  4. Topic 2D: Run the Procedure

Lesson 3: Managing Switchboards

  1. Topic 3A: Create a Database Switchboard
  2. Topic 3B: Modify a Database Switchboard
  3. Topic 3C: Set the Startup Options

Lesson 4: Distributing and Securing Databases

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

Lesson 5: Sharing a Database Using a SharePoint Site

  1. Topic 5A: Export a Table to a SharePoint List
  2. Topic 5B: Import Data from a SharePoint List
  3. Topic 5C: Publish a Database to a SharePoint Site
  4. Topic 5D: Move a Database to a SharePoint Site
  5. Topic 5E: Work Offline