Self-Study QuickSkill Course Access 2002 (Office XP): Level 4
Series: Office XP - Access 2002
Platform: Windows NT 4 Workstation, 95, 98, 2000, ME, XP, Mac OS 8
Course Type: Self-Study QuickSkill Course


In this course, students will create and modify a database switchboard. Students will also set and modify startup options. Students will develop a data access page and include a PivotTable and PivotChart in it. Students will distribute a database and add security features to it. Students will integrate Access into business operations. Students will also automate a business process using VBA.

Table of Contents

Lesson 1: Creating a Switchboard and Setting the Startup Options
  Examining and Creating a Switchboard
  Customizing a Switchboard
  Setting the Startup Options
  Modifying the Startup Options
Lesson 2: Developing a Data Access Page and Including a PivotTable and PivotChart
  Creating a Data Access Page in the Design View
  Adding a Combo Box to a Data Access Page
  Viewing Data Using a Browser
  Adding Records to a Database
  Planning and Developing a PivotTable
  Developing a PivotChart
Lesson 3: Distributing and Securing The Database
  Splitting a Database
  Determining Security Levels
  Applying Security to a Front-end Database
  Applying Security to a Back-end Database
  Deploying Security
  Setting Passwords
  Encrypting and Decrypting a Database
  Converting a Database to an MDE File
Lesson 4: Integrating Access into Your Business
  Working with Links
  Importing XML Data into a Database
  Exporting Access Data to the XML Format
  Replicating an Access Database
Lesson 5: Automating a Business Process with VBA
  Creating a Standard Module
  Creating a Sub Procedure
  Developing Procedure Code
  Calling a Procedure
  Testing a Procedure