Self-Study QuickSkill Course Access 2002 (Office XP): Level 3
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, you’ll explore a variety of complex query techniques, create more efficient forms and reports, and create and use macros to automate forms. In addition, you’ll gain experience working with various Microsoft Access tools, such as securing a database, using the Database Splitter, replicating a database, and creating MDE files.

Table of Contents

Lesson 1: Advanced Query Techniques
  Joining Tables and Working with Join Properties
  Creating Crosstab Queries
  Creating Parameter Queries
  Creating Action Queries
Lesson 2: Using Advanced Form Techniques
  Organizing Field Placement
  Using a Form as the User Interface
  Using the Switchboard Manager
  Creating a Form that Contains a Subform
  Creating a Form in Design View
Lesson 3: Creating Basic Macros to Automate Forms
  Macro Basics
  Attaching a Macro to a Command Button
Lesson 4: Using Macros to Provide User Interaction and Automate Tasks
  Using a Macro to Provide User Interaction
  Using a Macro to Automate Data Entry
Lesson 5: Enhancing Reports
  Working with Subreports
Lesson 6: Using Access Tools
  Steps to Securing a Database
  Replicating a Database
  Importing and Exporting XML Documents
Lesson 7: Creating Database Applications
  Creating Event Procedures
  Using the Database Splitter
  Creating MDE Files