The Cheltenham Courseware 'Computer Courseware Library'

Consider investing in a complete library of computer courseware titles. We provide the computer training materials, you deliver the IT training. A low one-off investment gives you over 150 course titles inc, Windows Vista and Microsoft Office 2007 courseware. There is a separate ECDL / ICDL Courseware Library available. Train as many people as you like for as long as you like. SIMPLE!

Don't just get one course, get over 150 courses as a complete 'Computer Courseware Library'. We provide the courseware, you deliver the training Details

Microsoft Office 2007 Courseware

Windows Vista Courseware

ECDL 4.5 / ICDL 4 Courseware
European Computer Driving Licence

Windows XP Courseware

Microsoft Office 2003 Courseware

Microsoft Office XP Courseware

Other courses

Microsoft Access 2003

Computer Training Course - Intermediate Level

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

Why write your own computer training manuals?
Save time, effort and money and get all the training courses you need from Cheltenham Courseware.
We write the computer training materials - You concentrate on delivering IT training.

Computer Courseware Library for Schools, Collages, Universities & IT Trainers
A complete set of training materials for computer trainers & computer training organizations

Microsoft Office 2007 Courseware

Windows Vista Courseware

ECDL 4.5 / ICDL 4 Courseware European Computer Driving Licence

Windows XP Courseware

Microsoft Office 2003 Courseware

Microsoft Office XP Courseware

Microsoft Access 2003

Computer Training Course - Intermediate Level

1. WORKING WITH THE NORTHWIND SAMPLE DATABASE

INSTALLING THE NORTHWIND DATABASE

2. DESIGNING TABLES IN ACCESS 2003

NORMALIZING DATA

ESTABLISHING RELATIONSHIPS

WORKING WITH INDEXES

WORKING WITH DATA TYPES

3. DESIGNING QUERIES IN ACCESS 2003

CREATING ACTION QUERIES

CREATING PARAMETER QUERIES

CREATING CALCULATED COLUMNS IN QUERIES

JOINING TABLES

4. DESIGNING FORMS IN ACCESS 2003

CREATING DATA ENTRY FORMS

WORKING WITH SUBFORMS

CREATING POP-UP FORMS

WORKING WITH SWITCHBOARDS

5. DESIGNING REPORTS IN ACCESS 2003

WORKING WITH STANDARD REPORTS

WORKING WITH POP-UP REPORTS

WORKING WITH SUBREPORTS

WORKING WITH REPORT SNAPSHOTS

DEVELOPING DATA ACCESS PAGES

6. WORKING WITH PIVOT TABLES AND PIVOT CHARTS

CREATING PIVOT TABLES AND PIVOT CHARTS

CREATING PIVOTTABLE FORMS

CREATING PIVOTCHART FORMS

7. IMPORTING AND EXPORTING

LINKING TO EXTERNAL DATA SOURCES

IMPORTING DATA INTO ACCESS

EXPORTING DATA FROM ACCESS

8. BUILDING EXPRESSIONS

USING THE EXPRESSION BUILDER

USING COMMON BUILT-IN FUNCTIONS

Computer Courseware Library for Schools, Collages, Universities & IT Trainers A complete set of training materials for computer trainers & computer training organizations

ECDL 4.5 / ICDL 4 Courseware
European Computer Driving Licence

Computer Courseware Library for Schools, Collages, Universities & IT Trainers
A complete set of training materials for computer trainers & computer training organizations