Layout Table~~~~2084~2084~~

Office IT Courses~~~~2084~2092~~

Word 2000 Level 1~In this course, you"ll explore the basic skills necessary to begin using Word 2000. You will examine how to create and edit documents and use character and paragraph formatting.~The Standard Course comes with our Silver Support Option that provides next working day tutor support by email or telephone.
The Gold Support Option provides next working day tutor support by email or telephone plus live on-line one-to-one tutorial sessions, using Windows Messenger, by appointment.

Word Basics

• Introduction
• to
• Word

Navigating in a Document

• Scrolling in a Document
• Searching in a Document

Additional Editing Techniques

• Techniques for Selecting Text
• Moving and Copying Text

Character and Paragraph Formatting

• Character Formatting
• Paragraph Formatting
• Working with Indents, Bullets, and Numbered Lists

Introduction to Tabs and Tables

• Working with Tabs
• Creating Tables

Controlling Page Appearance

• Headers and Footers
• Margins
• Page Breaks

Approx. Duration: 5hours~Word 2000 Level 1 Silver Support|1998712965|Word 2000 Level 1 Gold Support|1998712966|~2084~2147~~

Word 2000 Level 2~In this course, you"ll examine intermediate features of Word 2000. You will explore how to create and control section breaks, tables, merges, styles, templates, macros, and web pages.~The Standard Course comes with our Silver Support Option that provides next working day tutor support by email or telephone.
The Gold Support Option provides next working day tutor support by email or telephone plus live on-line one-to-one tutorial sessions, using Windows Messenger, by appointment.

Sections

• Creating and Formatting Sections
• Formatting Text into Newspaper Columns

Tables

• Creating and Formatting Tables
• Working with Table Data

Merging

• Creating a Mail Merge Document
• Performing a Merge
• Merging Addresses into Labels

Styles and AutoText

• Applying and Displaying Styles
• Creating and Modifying Styles

Introduction to templates

• Creating
• a
• Template

Introduction to macros

• Running
• and
• Recording
• Macros

Custom ToolbarsThe Internet and the Web

• Creating a Web Page
• Adding Hyperlinks and Graphics to a Web Page

~Word 2000 Level 2 Silver Support|1998712963|Word 2000 Level 2 Gold Support|1998712964|~2084~2148~~

Word 2000 Advanced~In this course, you"ll explore advanced features of Word 2000. You will examine how to apply styles, create forms, use form fields, add graphics, work with large documents, share documents, and prepare documents as intranet web pages.~The Standard Course comes with our Silver Support Option that provides next working day tutor support by email or telephone.
The Gold Support Option provides next working day tutor support by email or telephone plus live on-line one-to-one tutorial sessions, using Windows Messenger, by appointment.

Advanced styles

• The AutoFormat Feature
• Linking Styles

Form templates

• Creating
• and
• Using
• a
• Form
• Template

Using graphic effects

• Enhancing
• Your
• Document
• with
• Graphic
• Effects

Working with large documents

• Creating a Table of Contents
• Working with Footnotes and Endnotes
• Working with Bookmarks and Cross-References
• Using a Concordance File to Index

Managing document changes

• Tracking, Comparing, and Merging Documents
• Using Highlights and Comments

Preparing Word documents for an intranet

• Creating Hyperlinks
• Viewing and Editing a Web Page
• Inserting Multimedia Elements into Web Pages

~Word 2000 Advanced Silver Support|1998712961|Word 2000 Advanced Gold Support|1998712962|~2084~2149~~

Excel 2000 Level 1~In this course, you"ll use basic Excel worksheet skills and explore how to work with data in worksheets by using an electronic spreadsheet to create basic data reports.~The Standard Course comes with our Silver Support Option that provides next working day tutor support by email or telephone.
The Gold Support Option provides next working day tutor support by email or telephone plus live on-line one-to-one tutorial sessions, using Windows Messenger, by appointment.

Excel Basics

• Excel
• Basics

Entering Data and Navigating in a Worksheet

• Entering and Correcting Data
• Using Formulas
• Navigation and Movement Techniques

Modifying a Workbook

• Working with Ranges
• Working with Functions
• Editing Cell Contents

Moving and Copying Data

• Inserting Rows and Ranges
• Moving and Copying Data
• Absolute References

Formatting a Worksheet

• Formatting a Worksheet
• Number Formats and Text Alignment

Printing a Worksheet

• Printing
• Options

Introduction to the Workbook Environment

• Using
• a
• Multiple-Sheet
• Workbook

Creating Excel Web Pages

• Excel
• as
• a
• Web
• Tool

~Excel 2000 Level 1 Silver Support|1998712965|Excel 2000 Level 1 Gold Support|1998712966|~2084~2150~~

Excel 2000 Level 2~In this course, you"ll explore how to use electronic charts, chart items, and graphics to enhance worksheet data reports in Excel.~The Standard Course comes with our Silver Support Option that provides next working day tutor support by email or telephone.
The Gold Support Option provides next working day tutor support by email or telephone plus live on-line one-to-one tutorial sessions, using Windows Messenger, by appointment.

Creating Charts

• Creating a Chart Sheet
• Embedded Charts

Modifying Charts

• Chart Types
• Modifying Embedded Charts
• Adding and Deleting Chart Items
• Moving and Sizing Chart Items

Formatting a Chart

• Formatting Chart Text
• Formatting Labels

Using Graphic Objects

• Adding and Formatting Graphic Objects
• Enhancing Worksheets and Charts with Graphics

Sorting Data

• Single and Multiple Level Data Sorting
• Sorting Options

Filtering Data

• Filtering a List
• Filtering Using Custom Criteria
• Managing a Filtered List

~Excel 2000 Level 2 Silver Support|1998712963|Excel 2000 Level 2 Gold Support|1998712964|~2084~2151~~

Excel 2000 Advanced~In this course, you"ll explore how to work with advanced features of Excel 2000 and various advanced techniques for analyzing and manipulating data in Excel.~The Standard Course comes with our Silver Support Option that provides next working day tutor support by email or telephone.
The Gold Support Option provides next working day tutor support by email or telephone plus live on-line one-to-one tutorial sessions, using Windows Messenger, by appointment.

Customizing the work areaWorking with Built-In and Custom ToolbarsCreating and Using StylesUsing TemplatesAdvanced formula constructionUsing NamesUsing the IF and VLOOKUP FunctionsUsing pivot tablesCreating Pivot TablesModifying Pivot TablesWorking with multiple worksheetsWorking with WorkbooksLinking Cells in Different WorkbooksUsing protection and display optionsUsing CommentsProtecting WorkbooksUsing Custom ViewsIntroduction to macrosRunning and Recording MacrosViewing and Editing VBA CodeWorking with interactive Excel Web documentsSaving Excel Worksheets as Web DocumentsSpreadsheet Web Components~Excel 2000 Advanced Silver Support|1998712965|Excel 2000 Advanced Gold Support|1998712966|~2084~2153~~

Access 2000 Level 1~In this course, you"ll review the basic skills necessary to begin using Access 2000. You will design and create databases, tables, queries, forms, and reports.~The Standard Course comes with our Silver Support Option that provides next working day tutor support by email or telephone.
The Gold Support Option provides next working day tutor support by email or telephone plus live on-line one-to-one tutorial sessions, using Windows Messenger, by appointment.

Overview of Access 2000

• Introduction to Database Concepts and Terminology
• An Introduction to Access 2000
• Database Planning and Design

Creating Tables

• Examining a Table
• Creating a Table by Using the Table Wizard
• Creating a Table in Design View

Working with Tables

• Modifying the Table Design
• Finding and Editing Records
• Filtering and Sorting Records

Using Select Queries

• Selecting Fields and Sorting Records
• Refining the Results of a Query
• Joining Tables in a Query

Creating and Using Forms

• Creating a Form
• Modifying the Form Design

Creating and Using Reports

• Creating
• a
• Report

~Access 2000 Level 1 Silver Support|1998712965|Access 2000 Level 1 Gold Support|1998712966|~2084~2157~~

Access 2000 Level 2~In this course, you"ll study how to enhance your database designs by using the principles of normalization and table relationships. You will also examine how to query multiple tables for data that is used in customized forms and reports, and how to create data access pages to share data over an intranet or the Internet. In addition, you"ll be able to take the guesswork out of creating databases by using data-normalization techniques. You will examine how to take advantage of relational database efficiency to maintain data. You will also explore techniques to save time by controlling data entry and automating tasks. You will also become familiar with Access features that enable you to customize forms and reports.~The Standard Course comes with our Silver Support Option that provides next working day tutor support by email or telephone.
The Gold Support Option provides next working day tutor support by email or telephone plus live on-line one-to-one tutorial sessions, using Windows Messenger, by appointment.

Principles of table design

• Normalising Data
• Normalising Data for Fourth and Fifth Normal Forms

Principles of table relationships

• Analyzing Table Relationships
• Establishing and Testing Referential Integrity

Table design techniques

• Data Validation Techniques
• Subdatasheets and Lookup List Fields
• Indexing Techniques

Designing select queries

• Using Calculated Fields in Queries
• Creating Multiple-Table Queries

Customizing form designs

• Customising the Form Design
• Performing Calculations on a Form
• Adding Combo Boxes to a Form
• Adding Unbound Controls

Working with data access pages

• Creating
• Data
• Access
• Pages

Customizing reports

• Customising a Report Created by the Report Wizard
• Working with Subreports

~Excel 2000 Level 2 Silver Support|1998712963|Excel 2000 Level 2 Gold Support|1998712964|~2084~2158~~

Access 2000 Advanced~In this course, you"ll examine how to use a variety of complex query techniques, create more efficient forms and reports, and create and use macros to automate forms. In addition, you"ll experiment with Internet-related features, including hyperlinks and the Web toolbar.~The Standard Course comes with our Silver Support Option that provides next working day tutor support by email or telephone.
The Gold Support Option provides next working day tutor support by email or telephone plus live on-line one-to-one tutorial sessions, using Windows Messenger, by appointment.

Parameter and action queries

• Creating Parameter Queries
• Creating Action Queries

Query joins and crosstab queries

• Joining Tables and Working with Join Properties
• Creating Crosstab Queries

Using advanced form techniques

• Organising Field Placement
• Using Functions to Control Data Entry
• Adding an Option Group to a Form
• Using a Form as the User Interface
• Creating a Form that Contains a Subform

Creating basic macros to automate forms

• Macro Basics
• Attaching a Macro to a Command Button

Using macros to provide user interaction and automate tasks

• Using a Macro to Provide User Interaction
• Using a Macro to Automate Data Entry

~Excel 2000 Advanced Silver Support|1998712965|Excel 2000 Advanced Gold Support|1998712966|~2084~2159~~

Crystal Reports 8.0 Basic Skills~In this course, you"ll examine the basic skills needed to create reports to help analyze and present information.~Overview

• Launching
• Crystal
• Reports
• and
• Setting
• Preferences

Creating Basic Reports

• Creating a Report
• Previewing and Formatting Reports

Sorting and Selecting Data

• Sorting
• and
• Selecting
• Data

Grouping and Summarizing Data

• Grouping Data
• Summarizing Data

Using the Report Expert

• Using the Report Expert
• Using the Mail Label Report Expert

Cross-Tab Reports

• Creating a Cross-Tab Report
• Working with Existing Cross-Tabs

Linking

• Creating Links with the Visual Linking Expert
• Understanding Link Options

Creating Formulas

• Creating Formulas
• Creating String and Date Formulas
• Creating Summary Calculations and If Statements

Formatting Sections

• Formatting Sections
• Distributing Data

~Crystal Reports 8.0 Basic Skills|1998713029|~2084~2185~~

Crystal Reports 8.0: Advanced~In this course, you"ll examine the advanced skills required to create informational and analytical reports.~Conditional Formatting

• Conditional Formatting
• Using the Highlighting Expert and Removing Conditional Formats

Advanced Totals

• Using Variables and Creating Running Total Formulas
• Multiple-Pass Reporting and Using Multiple Variables

Multiple Sections

• Multiple Sections
• Multiple Sections and Conditional Formats

Parameter Fields

• Parameter Fields
• Using Parameter Fields
• Using Parameter Fields to Apply Conditional Formatting

Advanced Cross-Tabs

• Multiple Field Cross-tab Reports
• Using Parameter Fields and Groups with Cross-Tabs

Subreports

• Using Linked and Unlinked Subreports
• Using On-Demand Subreports

SQL/ODBC and Crystal SQL Designer

• SQL/ODBC
• and
• Crystal
• SQL
• Designer

Crystal Dictionaries and Graphing

• Defining, Using, and Creating Crystal Dictionaries
• Enhancing and Modifying a Dictionary
• Graphing

~Crystal Reports 8.0%3A Advanced|1998713030|~2084~2186~~