|
Training
Materials for:
Windows Vista
Windows XP
Microsoft Word 2007
Microsoft Excel 2007
PowerPoint 2007
Microsoft Access 2007
Internet
Explorer 7
Outlook 2007
Expression Web
Microsoft Project
Microsoft Publisher
Microsoft FrontPage
Microsoft Visio
Computer
Concepts
ECDL / ICDL
Downloads
PLUS MANY MORE ...
|
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
INTRODUCING THE MACRO WINDOW TOOLBAR
- Using the Macro Window Toolbar
CREATING 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
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
SUMMARIZING DATA IN DATA ACCESS PAGES
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
|
