Home  | Samples / Prices  | Courses  | What You Get  About Us  FAQs  Contact | ECDL / ICDL

             Cheltenham Courseware

UK Computer Courseware Irish Computer Courseware
Please select your region  
UK/Ireland | USA/Canada | Australia/International 


 

 COMPUTER COURSES

  MS Office 2010
  Courseware
  Word 2010 Foundation
  Word 2010 Intermediate
  Word 2010 Advanced
  Excel 2010 Foundation
  Excel 2010 Intermediate
  Excel 2010 Advanced
  Access 2010 Foundation
  Access 2010 Intermediate
  Access 2010 Advanced
  Outlook 2010 Basics
  PowerPoint 2010 Foundation
  PowerPoint 2010 Intermediate
  PowerPoint 2010 Advanced

  MS Office 2007
  Courseware

   Word 2007 Foundation

  Word 2007 Intermediate
  Word 2007 Advanced
  Excel 2007 Foundation
  Excel 2007 Intermediate
  Excel 2007 Advanced
  Access 2007 Foundation
  Access 2007 Intermediate
  Access 2007 Advanced
  Project 2007 Foundation
  Publisher 2007 Foundation
  Visio 2007 Foundation
  PowerPoint 2007 Foundation
  PowerPoint 2007 Intermediate
  PowerPoint 2007 Advanced
  Outlook 2007 Basics

  MS Office 2003 
  Courseware

   Word 2003 Foundation

  Word 2003 Intermediate
  Word 2003 Advanced
  Excel 2003 Foundation
  Excel 2003 Intermediate
  Excel 2003 Advanced
  Access 2003 Foundation
  Access 2003 Intermediate
  Access 2003 Advanced
  Access 2003 Basics
  Access 2003 Expert
  Project 2003 Foundation
  Publisher 2003 Foundation
  PowerPoint 2003 Foundation
  PowerPoint 2003 Intermediate
  PowerPoint 2003 Advanced
  Outlook 2003 Basics


  LONGER 2 LEVEL 
  COURSES

  MS Office 2010
  Courseware
 
  Word 2010 Basics
  Word 2010 Expert
  Excel 2010 Basics
  Excel 2010 Expert
  Access 2010 Basics
  Access 2010 Expert 
  Outlook 2010 Basics
  PowerPoint 2010 Basics
  PowerPoint 2010 Expert

  MS Office 2007
  Courseware


  Word 2007 Basics
  Word 2007 Expert
  Excel 2007 Basics
  Excel 2007 Expert
  Access 2007 Basics
  Access 2007 Expert
  Project 2007 Foundation
  Publisher 2007 Foundation
  Visio 2007 Foundation
  PowerPoint 2007 Basics
  PowerPoint 2007 Expert
  Outlook 2007 Basics

  MS Office 2003 
  Courseware


  Word 2003 Basics
  Word 2003 Expert
  Excel 2003 Basics
  Excel 2003 Expert
  Access 2003 Basics
  Access 2003 Expert
  Project 2003 Foundation
  Publisher 2003 Foundation
  PowerPoint 2003 Basics
  PowerPoint 2003 Expert


  ICT Courseware
  PC Basics
  Windows XP Basics
  Windows Vista Basics
  Windows 7 Basics
  Internet Explorer 8

 

Sample IT Training Materials

SEO training seminars, Perth, WA

 

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

 
 

UK coursework   USA coursework Canada Australia coursework International Computer coursework  Privacy Policy
© 1995-2012 Cheltenham Courseware Pty. Ltd. All trademarks acknowledged. Terms & Conditions 
Course content subject to change without notice. Cheltenham Group | HTML Formatted Sample
Microsoft Word - Microsoft Excel - Microsoft Access - Microsoft PowerPoint - Microsoft Windows | Prices & Ordering | Computer Courseware Samples | FAQs | Cheltenham Group | About Us | Contact UsECDL UK Instructor-led Courseware  |  ECDL / ICDL International Courseware | Site Map | Home Page |  Perth SEO
SEO training seminars, Perth, WA
           
Computer Training resources for IT trainers inc Microsoft Office 2010


  Customisable Courseware
  No Annual Renewal Fees
  Unlimited Number of Users
  Unlimited Reprinting Rights
  PLUS Intranet Versions


Please select your region  
UK/Ireland | USA/Canada | Australia/International 

   Computer Training Courseware for IT Teaching Professionals
    Quality courseware materials for tutor-led computer training:  
    For schools, colleges, IT trainers, corporate training departments, & computer training companies.