Microsoft Access XP 2002
Intermediate Level Courseware Training Materials

Training Course Outline

1. WORKING WITH THE NORTHWIND SAMPLE DATABASE

• About Northwind
• Checking for Northwind
• Installing Northwind

2. DESIGNING TABLES IN ACCESS 2002

• Setting a Primary Key
• Removing Non-related Data
• Removing Redundant Data
• Removing Repeating Data
• Setting Required Values in Columns
• Using the Relationship Tool
• Identifying a Related Table
• Creating Join Types
• Enforcing Referential Integrity
• Working with Cascading Updates and Deletes
• Creating a Single-Field Index
• Creating a Multiple-Field Index
• Setting the Index Sort Order
• Setting Index Properties
• Deleting Indexes
• Choosing Appropriate Data Types
• Setting Column Data Types
• Formatting Data Types
• Converting Between Data Types

3. DESIGNING QUERIES IN ACCESS 2002

• Creating Update Queries
• Creating Delete Queries
• Creating Append Queries
• Creating Make-Table Queries
• Creating a One-Parameter Query
• Creating a Two-Parameter Query
• Using Wildcards as Parameters
• Creating Calculated Fields
• Using Common Functions in Calculated Fields
• 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 2002

• 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
• Creating a Subform
• Creating a Form with Two Subforms
• Creating Nested Subforms
• Deleting a Subform
• Creating a Modal Pop-up Form
• Creating a Modeless Pop-up Form
• Creating a Switchboard
• Editing a Switchboard Item
• Deleting a Switchboard

5. DESIGNING REPORTS IN ACCESS 2002

• 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
• Creating a Modal Pop-up Report
• Creating a Modeless Pop-up Report
• Creating a Subreport
• Creating a Report with Two Subreports
• Deleting a Subreport
• Creating Report Snapshots
• Distributing Report Snapshots
• 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 PIVOTTABLES AND PIVOTCHARTS

• Creating PivotTables
• Creating PivotCharts
• Selecting Elements of a PivotTable
• Selecting Elements of a PivotChart
• Using the PivotTable AutoForm Wizard
• Deleting Items from a PivotTable
• Filtering Items in the PivotTable List
• Using the AutoCalc Feature
• Displaying Subtotals
• Using the PivotChart AutoForm Wizard
• Deleting Items from a PivotChart
• Filtering Items in the PivotChart List
• Changing PivotChart Types

7. IMPORTING AND EXPORTING

• 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 from Excel Files
• Importing from Other Access Databases
• Importing from ODBC Data Sources
• Exporting to Files
• Exporting to Access Databases
• Exporting to ODBC Data Sources

8. BUILDING EXPRESSIONS

• Using the Expression Builder in Queries
• Using the Expression Builder in Forms
• Using the Expression Builder in Reports
• Using Date/Time Functions
• Using Financial Functions
• Using Math Functions
• Using Text Functions

Other Microsoft Office 2002 Courseware materials

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