Access 2003 Intermediate Courseware Materials

Microsoft Access 2003 Intermediate Training Materials for IT Trainers

Intermediate Level Computer 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