This 1-day Microsoft Access 2002 Intermediate training course is delivered onsite and off-site at locations across the UK.
Training Course Outline
This Access 2002 Intermediate training course
covers the following topics:
1). WORKING WITH THE
NORTHWIND SAMPLE DATABASE
INSTALLING THE NORTHWIND
DATABASE
About Northwind
Checking for Northwind
Installing Northwind
2). DESIGNING TABLES IN ACCESS
2002
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 2002
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 2002
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 2002
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 PIVOTTABLES AND PIVOTCHARTS
CREATING
PIVOTTABLES AND PIVOTCHARTS
Creating PivotTables
Creating PivotCharts
Selecting Elements of a
PivotTable
Selecting Elements of a PivotChart
CREATING PIVOTTABLE FORMS
Using the PivotTable
AutoForm Wizard
Deleting Items from a PivotTable
Filtering Items in the PivotTable List
Using the
AutoCalc Feature
Displaying Subtotals
CREATING
PIVOTCHART FORMS
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 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 Fnctions
Using Text
Functions