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