Access 2002 Advanced course outline

Microsoft Access 2002 Advanced
Training Course Outline

1-day course

This course includes the following topics:

1). WORKING WITH THE NORTHWIND SAMPLE DATABASE

INSTALLING THE NORTHWIND DATABASE
About Northwind
Checking for Northwind
Installing Northwind

2). INTRODUCING STRUCTURED QUERY LANGUAGE

WRITING SQL COMMANDS
Structured Query Language (SQL) Bases
Understanding SQL Statements
Understanding SQL Conventions
Understanding SQL Syntax

WRITING SQL QUERIES
Using SELECT Statement
Selecting All Data
Selecting Specific Data
Selecting Conditional Data
Using ORDER BY Statement
Sorting Data
Using Aggregate Functions
Calculating Data
Using GROUP BY Statement
Grouping Data

WRITING SQL SUBQUERIES
Creating a Subquery with Equality
Creating a Subquery with an Aggregate Function
Using ANY and ALL Statements

WRITING SQL JOINS
Understanding SQL Joins
Creating a Simple Join
Sorting a Join
Creating Outer Joins
Creating Left Outer Joins
Creating Right Outer Joins
Creating Full Outer Joins

INSERTING DATA
Using INSERT Statement
Understanding INSERT Statement Rules
Inserting Data using VALUES
Inserting Data using Defaults
Inserting Data using SELECT

UPDATING DATA
Using UPDATE Statement
Updating All Rows
Updating Specific Rows
Updating Multiple Columns

DELETING DATA
Using DELETE FROM Statement
Deleting Specific Rows
Deleting All Rows

WRITING SQL QUERIES IN ACCESS 2002
Viewing SQL in Access 2002
Understanding SQL in Access 2002
Writing SQL Specific Queries
Finding Help on SQL Queries

3). WORKING WITH MACROS

AUTOMATING TASKS
Understanding Macros

INTRODUCING THE MACRO WINDOW TOOLBAR
Using the Macro Window Toolbar

CREATING MACROS
Creating New Macros

TESTING AND DEBUGGING MACROS
Running a Macro
Stepping Through a Macro

MODIFYING MACROS

CONDITIONAL PROGRAMMING IN MACROS
Adding Conditions to Macros
Using the Expression Builder to create Conditions
Running Macros with Conditions

ADDING MACROS TO FORMS
Attaching Macros to a Form

ADDING MACROS TO REPORTS
Attaching Macros to a Report

FILTERING DATA
Filtering Records

DOCUMENTING MACROS
Commenting Macros
Printing Macro Definitions
Viewing Macro Definitions

4). PROGRAMMING ACCESS USING VISUAL BASIC

USING MACROS VERSUS VISUAL BASIC
Using Visual Basic Modules
Converting Macros to Visual Basic Code

UNDERSTANDING VISUAL BASIC CONCEPTS
Understanding Modules
Creating Modules
Understanding Module Declarations
Understanding Procedures
Using Naming Rules
Declaring Variables
Setting Variable Scope
Declaring Constants
Using Methods
Using Arguments

USING THE VISUAL BASIC EDITOR WINDOW
Customizing the Visual Basic Editor Window
Setting the Visual Basic Editor Options

GETTING HELP WITH VISUAL BASIC
Using Microsoft Visual Basic Help
Getting Visual Basic Syntax Help

5). USING DATA ACCESS PAGES

CREATING DATA ACCESS PAGES
Using Data Access Pages
Creating pages using the AutoPage
Creating pages using the Page Wizard
Creating pages using an Existing HTML Document
Creating pages using the Design View

MODIFYING DATA ACCESS PAGES
Choosing a Theme
Adding Text
Adding Controls
Formatting Text and Labels
Aligning Content
Sizing Content
Adding Images
Adding Backgrounds

SORTING DATA IN DATA ACCESS PAGES
Sorting Data

SUMMARIZING DATA IN DATA ACCESS PAGES
Summarizing Data

EDITING DATA IN DATA ACCESS PAGES
Adding a New Record
Deleting a Record

PROTECTING DATA IN DATA ACCESS PAGES
Customizing Navigation Bar
Protecting Fields

6). CONVERTING ACCESS DATABASES

CONVERTING DATABASES TO ACCESS 2002
Converting Databases
Converting Database Objects
Enabling Databases
Sharing Databases across various Access versions

CONVERTING FROM ACCESS 2002 TO ACCESS 97
Converting an Access 2002 database to an Access 97 database
CONVERTING FROM ACCESS 2002 TO ACCESS 2000
Converting an Access 2002 database to an Access 2000 database

7). CUSTOMIZING ACCESS 2002

CONFIGURING ACCESS 2002 OPTIONS
Setting Access 2002 Options
Setting View Options
Setting General Options
Setting Edit/Find Options
Setting Keyboard Options
Setting Datasheet Options
Setting Forms/Reports Options
Setting Pages Options
Setting Advanced Options
Setting International Options
Setting Spelling Options
Setting Tables/Queries Options

CONFIGURING AUTOCORRECT OPTIONS
Setting AutoCorrect Options
Excluding AutoCorrect Rules
Removing AutoCorrect Rules
Adding Replace AutoCorrect Rules
Removing Replace AutoCorrect Rules

CUSTOMIZING MENUS AND TOOLBARS
Opening Customize Dialog Box
Customizing Toolbars
Creating Custom Toolbars
Removing Toolbars
Customizing Commands
Adding Buttons to Toolbars
Removing Buttons from Toolbars
Customizing Options

8). ANALYZING ACCESS DATABASES

OPTIMIZING DATABASES WITH TABLE ANALYZER
Using the Table Analyser
Renaming Tables
Adding Key Fields

OPTIMIZING DATABASES WITH PERFORMANCE ANALYZER
Using the Performance Analyser

DOCUMENTING DATABASES WITH DOCUMENTER ANALYZER
Using the Documenter Analyser
Printing Documentation
Exporting Documentation

For further details, or to book a course, please contact us:
email: training@ictwizard.com
telephone: 01382 453447

Our Access courses include:

Microsoft Access 2007 Foundation

Microsoft Access 2007 Intermediate

Microsoft Access 2007 Advanced

Microsoft Access 2003 Foundation

Microsoft Access 2003 Intermediate

Microsoft Access 2003 Advanced

Access VBA

ICT Wizard courses: