View ECDL/ICDL Site

Microsoft Access XP 2002 Course
Advanced Level Courseware Training Materials

Training Course Outline

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 Analyzer
• Renaming Tables
• Adding Key Fields

OPTIMIZING DATABASES WITH PERFORMANCE ANALYZER

• Using the Performance Analyzer

DOCUMENTING DATABASES WITH DOCUMENTER ANALYZER

• Using the Documenter Analyzer
• Printing Documentation
• Exporting Documentation

Other Microsoft Office 2002 Courseware materials

• Microsoft Access 2002 Foundation Courseware materials
• Microsoft Access 2002 Intermediate Courseware materials
• Microsoft Access 2002 Advanced Courseware materials
• Microsoft Excel 2002 Foundation Courseware materials
• Microsoft Excel 2002 Intermediate Courseware materials
• Microsoft Excel 2002 Advanced Courseware materials
• Microsoft FrontPage 2002 Foundation Courseware materials
• Microsoft FrontPage 2002 Intermediate Courseware materials
• Microsoft Outlook 2002 Foundation Courseware materials
• Microsoft PowerPoint 2002 Foundation Courseware materials
• Microsoft PowerPoint 2002 Intermediate Courseware materials
• Microsoft Project 2002 Foundation Courseware materials
• Microsoft Publisher 2002 Foundation Courseware materials
• Microsoft Publisher 2002 Intermediate Courseware materials
• Microsoft Visio 2002 Foundation Courseware materials
• Microsoft Word 2002 Foundation Courseware materials
• Microsoft Word 2002 Intermediate Courseware materials
• Microsoft Word 2002 Advanced Courseware materials