Access 2003 Intermediate Training Course Outline

Microsoft Access Training CoursesThis 1-day Microsoft Access 2003 Intermediate training course is delivered onsite and off-site at locations across the UK.

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