Access 97 Advanced

Course Length/Prerequisites

This two day course requires that students be very comfortable with the use of Access for basic tasks such as creating and using data tables, forms, queries and reports.

Who Should Attend?

This course is intended for personnel who are comfortable with the basic operations in Access but wish to produce a database application. This database application can automate various tasks (using macros) and can be placed on a network so that it can be utilized by multiple users.

Course Objectives

Upon completion of this hands-on workshop, students will be able to:
create Access macros
create forms containing buttons that execute useful macros
create forms that contain subforms
create a main form (switchboard)
create a turn-key application that can be installed on a network
create and utilize simple VBA code
create reports that contain subreports
customize a report with VBA code

Course Content

Enhancing Database Design
Before You Begin

Table Relationships

Keeping Tables Separate from Other Objects

Analysis Tools

Building More Powerful Queries
Reviewing Parameter Queries

Changing Data with Action Queries

Crosstab Queries

Useful Functions

Designing Complex Forms
Creating a Main/Subform

Adding Custom Controls

Adding Tab Controls

Creating a Switchboard Form

Programming in Access: Macros
Macro and Visual Basic Events

Creating a Macro

Attaching a Macro to an Event

Macro Groups

Conditional Actions

Connecting Forms to Forms and Forms to Tables

Using a Macro to Add Records to a Table from a Form

Programming in Access: VBA
Visual Basic Terminology

Creating Code

Watching and Debugging Code

Applying Visual Basic Code to the Video Application

Customizing Reports
Creating a Customized Report

Creating a Subreport

Showing and Hiding Controls on a Report

Manual Page Count : 189