Access 2003 Intermediate Courseware

Microsoft Access 2003 Intermediate Training Materials

Intermediate Level Training Materials

Training Course Outlines

 

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