Microsoft Access 2003 Courseware Materials for IT Trainers
Intermediate Level Training Materials

Courseware Training Manual

1. WORKING WITH THE NORTHWIND SAMPLE DATABASE

INSTALLING THE NORTHWIND DATABASE

• About Northwind
• Checking for Northwind
• Installing Northwind

2. DESIGNING TABLES IN ACCESS 2003

NORMALIZING DATA

• Setting a Primary Key
• Removing Non-related Data
• Removing Redundant Data
• Removing Repeating Data
• Setting Required Values in Columns

ESTABLISHING RELATIONSHIPS

• Using the Relationship Tool
• Identifying a Related Table
• Creating Join Types
• Enforcing Referential Integrity
• Working with Cascading Updates and Deletes

WORKING WITH INDEXES

• Creating a Single-Field Index
• Creating a Multiple-Field Index
• Setting the Index Sort Order
• Setting Index Properties
• Deleting Indexes

WORKING WITH DATA TYPES

• Choosing Appropriate Data Types
• Setting Column Data Types
• Formatting Data Types
• Converting Between Data Types

3. DESIGNING QUERIES IN ACCESS 2003

CREATING ACTION QUERIES

• Creating Update Queries
• Creating Delete Queries
• Creating Append Queries
• Creating Make-Table Queries

CREATING PARAMETER QUERIES

• Creating a One-Parameter Query
• Creating a Two-Parameter Query
• Using Wildcards as Parameters

CREATING CALCULATED COLUMNS IN QUERIES

• Creating Calculated Fields
• Using Common Functions in Calculated Fields

JOINING TABLES

• Creating a Two-Table Join
• Adding Fields from Different Tables to the Query Grid
• Removing Tables from the Query Builder

4. DESIGNING FORMS IN ACCESS 2003

CREATING DATA ENTRY FORMS

• About Forms
• Choosing an Appropriate Control
• Placing Controls on a Form
• Moving a Control
• Resizing a Control
• Setting Control Properties
• Creating Page Headers and Footers
• Creating Form Headers and Footers
• Setting Form Properties
• Working with Identifiers

WORKING WITH SUBFORMS

• Creating a Subform
• Creating a Form with Two Subforms
• Creating Nested Subforms
• Deleting a Subform

CREATING POP-UP FORMS

• Creating a Modal Pop-up Form
• Creating a Modeless Pop-up Form

WORKING WITH SWITCHBOARDS

• Creating a Switchboard
• Editing a Switchboard Item
• Deleting a Switchboard

5. DESIGNING REPORTS IN ACCESS 2003

WORKING WITH STANDARD REPORTS

• About Reports
• Placing Controls on a Report
• Moving a Control
• Resizing a Control
• Setting Control Properties
• Creating Page Headers and Footers
• Creating Report Headers and Footers
• Sorting Records on a Report
• Grouping Records on a Report
• Setting Report Properties

WORKING WITH POP-UP REPORTS

• Creating a Modal Pop-up Report
• Creating a Modeless Pop-up Report

WORKING WITH SUBREPORTS

• Creating a Subreport
• Creating a Report with Two Subreports
• Deleting a Subreport

WORKING WITH REPORT SNAPSHOTS

• Creating Report Snapshots
• Distributing Report Snapshots

DEVELOPING DATA ACCESS PAGES

• Using the New Data Access Page Wizard
• Defining a Data Source for a Stand-Alone Data Access Page
• Creating Stand-Alone Data Access Pages

6. WORKING WITH PIVOT TABLES AND PIVOT CHARTS

CREATING PIVOT TABLES AND PIVOT CHARTS

• Creating Pivot Tables
• Creating Pivot Charts
• Selecting Elements of a PivotT able
• Selecting Elements of a Pivot Chart

CREATING PIVOTTABLE FORMS

• Using the PivotTable AutoForm Wizard
• Deleting Items from a PivotTable
• Filtering Items in the Pivot Table List
• Using the AutoCalc Feature
• Displaying Subtotals

CREATING PIVOTCHART FORMS

• Using the Pivot Chart AutoForm Wizard
• Deleting Items from a PivotChart
• Filtering Items in the PivotChart List
• Changing PivotChart Types

7. IMPORTING AND EXPORTING

LINKING TO EXTERNAL DATA SOURCES

• Linking to Text Files
• Linking to Microsoft Excel Spreadsheets
• Linking to HTML Files
• Linking to Other Access Databases
• Linking to a SQL Server ODBC Data Source

IMPORTING DATA INTO ACCESS

• Importing from Excel Files
• Importing from Other Access Databases
• Importing from ODBC Data Sources

EXPORTING DATA FROM ACCESS

• Exporting to Files
• Exporting to Access Databases
• Exporting to ODBC Data Sources

8. BUILDING EXPRESSIONS

USING THE EXPRESSION BUILDER

• Using the Expression Builder in Queries
• Using the Expression Builder in Forms
• Using the Expression Builder in Reports

USING COMMON BUILT-IN FUNCTIONS

• Using Date/Time Functions
• Using Financial Functions
• Using Math Functions
• Using Text Functions

Other Microsoft Office 2003 Courseware materials

• Microsoft Access 2003 Foundation Courseware materials
• Microsoft Access 2003 Intermediate Courseware materials
• Microsoft Access 2003 Advanced Courseware materials
• Microsoft Excel 2003 Foundation Courseware materials
• Microsoft Excel 2003 Intermediate Courseware materials
• Microsoft Excel 2003 Advanced Courseware materials
• Microsoft FrontPage 2003 Foundation Courseware materials
• Microsoft Outlook 2003 Foundation Courseware materials
• Microsoft PowerPoint 2003 Foundation Courseware materials
• Microsoft PowerPoint 2003 Intermediate Courseware materials
• Microsoft PowerPoint 2003 Advanced Courseware materials
• Microsoft Project 2003 Foundation Courseware materials
• Microsoft Publisher 2003 Foundation Courseware materials
• Microsoft Word 2003 Foundation Courseware materials
• Microsoft Word 2003 Intermediate Courseware materials
• Microsoft Word 2003 Advanced Courseware materials