This 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