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