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

 

Call Now Button