Access 2003 Advanced Courseware

Microsoft Access 2003 Advanced Training Materials

Advanced Level Training Materials

Training Course Outline

 

1. WORKING WITH THE NORTHWIND SAMPLE DATABASE

  •     About Northwind
  •     Checking for Northwind
  •     Installing Northwind

2. INTRODUCING STRUCTURED QUERY LANGUAGE

  •     Structured Query Language (SQL) Bases
  •     Understanding SQL Statements
  •     Understanding SQL Conventions
  •     Understanding SQL Syntax
  •     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
  •     Creating a Subquery with Equality
  •     Creating a Subquery with an AggregateFunction
  •     Using ANY and ALL Statements
  •     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
  •     Using INSERT Statement
  •     Understanding INSERT Statement Rules
  •     Inserting Data using VALUES
  •     Inserting Data using Defaults
  •     Inserting Data using SELECT
  •     Using UPDATE Statement
  •     Updating All Rows
  •     Updating Specific Rows
  •     Updating Multiple Columns
  •     Using DELETE FROM Statement
  •     Deleting Specific Rows
  •     Deleting All Rows
  •     Viewing SQL in Access 2003
  •     Understanding SQL in Access 2003
  •     Writing SQL Specific Queries
  •     Finding Help on SQL Queries

3. WORKING WITH MACROS

  •     Understanding Macros
  •     Using the Macro Window Toolbar

CREATING MACROS

  •     Creating New Macros
  •    Running a Macro
  •     Stepping Through a Macro
  •     Modifying a Macro
  •     Adding Conditions to Macros
  •     Using the Expression Builder to create Conditions
  •     Running Macros with Conditions
  •     Attaching Macros to a Form
  •     Attaching Macros to a Report
  •     Filtering Records
  •     Commenting Macros
  •     Printing Macro Definitions
  •     Viewing Macro Definitions

4. PROGRAMMING ACCESS USING VISUAL BASIC

  •     Using Visual Basic Modules
  •     Converting Macros to Visual Basic Code
  •     Understanding Modules
  •     Creating Modules
  •     Understanding Module Declarations
  •     Understanding Procedures
  •     Using Naming Rules
  •     Declaring Variables
  •     Setting Variable Scope
  •     Declaring Constants
  •     Using Methods
  •     Using Arguments
  •     Customizing the Visual Basic Editor Window
  •     Setting the Visual Basic Editor Options
  •     Using Microsoft Visual Basic Help
  •     Getting Visual Basic Syntax Help

5. USING 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
  •     Choosing a Theme
  •     Adding Text
  •     Adding Controls
  •     Formatting Text and Labels
  •     Aligning Content
  •     Sizing Content
  •     Adding Images
  •     Adding Backgrounds
  •     Sorting Data
  •     Summarizing Data
  •     Adding a New Record
  •     Deleting a Record
  •     Customizing Navigation Bar
  •     Protecting Fields

6. CONVERTING ACCESS DATABASES

  •     Converting Databases
  •     Converting Database Objects
  •     Enabling Databases
  •     Sharing Databases across various Access versions
  •     Converting Access 2003 database to Access 97 database
  •     Converting Access 2003 database to Access 2000 database

7. CUSTOMIZING ACCESS 2003

  •     Setting Access 2003 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
  •     Setting AutoCorrect Options
  •     Excluding AutoCorrect Rules
  •     Removing AutoCorrect Rules
  •     Adding Replace AutoCorrect Rules
  •     Removing Replace AutoCorrect Rules
  •     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

  •     Using the Table Analyzer
  •     Renaming Tables
  •     Adding Key Fields
  •     Using the Performance Analyzer
  •     Using the Documenter Analyzer
  •     Printing Documentation
  •     Exporting Documentation

 

Rate this post