Access 2003 Advanced Courseware Materials

Rate this post

Microsoft Access 2003 Advanced Training Materials for IT Trainers

Advanced Level Computer Training Materials

Training Course Outline

WORKING WITH THE NORTHWIND SAMPLE DATABASE

  • About Northwind
  • Checking for Northwind
  • Installing Northwind

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 Aggregate Function
  • 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

WORKING WITH MACROS

  • Understanding Macros
  • Using the Macro Window Toolbar
  • 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

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

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

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

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

ANALYZING ACCESS DATABASES

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

 

Powered by WordPress. Designed by Woo Themes