Mastering Access 97

Course description

Overview: Students will learn how to solidify their basic Access skills and deepen their knowledge of Access by using advanced software features.

Prerequisites: Students should understand the basics of Microsoft Windows 95 and Access 97. To acquire the Access basics, students should complete the LearnPro Applying Access 97 course or have equivalent knowledge.

Skills list

Objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of all the cases in this course, students will have been introduced to the following skills:

Adding and moving fields in table design

Adding graphics to a form or report, using OLE

Analyzing table relationships

Changing Startup options

Changing tab order in a form

Creating a combo box

Creating a command button on a form

Creating a custom dialog box

Creating a database

Creating a form based on joined tables

Creating a macro to control form properties

Creating a macro to open a form

Creating a multi-parameter query

Creating a single-parameter query

Creating a switchboard form

Creating action queries

Creating an index

Creating forms

Creating hierarchical forms

Creating queries with multiple criteria

Deleting records from a table

Designating primary-key fields

Designing a table

Determining table relationships

Enforcing referential integrity

Establishing table relationships

Exploring database concepts

Exploring database design

Exploring exporting objects to HTML format

Exploring hyperlinks

Exploring importing HTML files

Exploring Microsoft On The Web

Exploring replication

Exploring the Publish To The Web Wizard

Exploring the Web toolbar

Formatting reports

Grouping records in reports

Inserting fields into table design

Joining tables in a query

Moving controls and labels in Design View

Normalizing data

Opening a database

Opening Access objects

Sorting table records

Specifying field default value

Specifying validation rules

Specifying validation text

Using cascade deletions

Using cascade updates

Using forms to enter and edit data

Using the Input Mask Wizard

Using junction tables

Using referential integrity

Using the Performance Analyzer Wizard

Using the Publish To The Web Wizard

Using the Report Wizard

Using the Table Analyzer Wizard

Viewing objects in Datasheet View

Viewing objects in Design View

Course content

Project 1: Initial Exploration

Project 2: Creating a Database

Project 3: Creating and Using Queries

Project 4: Creating a Form

Project 5: Creating a Report

Module A: Tables

                Project A1: Table Design

Module B: Advanced Queries

                Project B1: Creating Multiple Parameter Queries

                Project B2: Creating Action Queries

                Project B3: Creating Queries Based on Queries

                Project B4: Creating Crosstab Queries

                Project B5: Creating an Outer Join Query

Module C: Advanced Forms

                Project C1: Subforms and Switchboard Forms

                Project C2: Creating Multiple Related Forms

Module D: Advanced Reports

                Project D1: Advanced Reporting

                Project D2: Creating a Mailing Label Report

Module E: Worldwide Web Capabilities

                Project E1: Internet Features