Prerequisite: Windows

• Understand database concepts and terminology in Access 2000.

• Design and create tables.

• Enter and manipulate data in tables.

• Use Access queries to select and analyze information in a table.

• Create data forms for viewing and inputting data.

• Create reports that summarize and group data.

• Perform database maintenance procedures.

 Prerequisite: Experience with topics listed in Access 2000 Level 1

• Normalize sample tables by identifying design problems.

• Establish relationships between tables by analyzing table relationships and enforcing referential integrity.

• Customize table designs by setting field properties to maintain data integrity and creating indexes.

• Design select queries by using multiple tables to calculate, group, average, and concatenate values and to show top values.

• Customize form designs by creating calculated fields, combo boxes, and unbound controls.

• Display table information that has a one-to-many relationship by creating forms that contain subforms.

• Customize report designs by grouping, sorting, and summarizing data, and by adding subreports.

Lesson 1: Principles of table design

• Normalizing data

• Normalizing data for fourth and fifth normal forms

Lesson 2: Principles of table relationships

• Analyzing table relationships

• Establishing and testing referential integrity

Lesson 3: Table design techniques

• Data validation techniques

• Indexing techniques

Lesson 4: Designing select queries

• Working with calculations

• Creating advanced select queries

Lesson 5: Enhanced form design

• Modifying the form design

• Adding calculations to a form

• Adding combo boxes to a form

• Adding unbound controls

Lesson 6: Subform design

• Creating a form that contains a subform

• Using the Form Wizard to create a from that contains a subform

Lesson 7: Customizing reports

• Customizing a report created by the Report Wizard

• Subreports

Prerequisite: 
Experience with topics listed in Access 2000 Levels 1 and 2

• Make select queries more versatile by using parameters; and use action queries to update data values and add or delete records.

• Refine the information derived from queries by creating outer joins and using crosstab queries.

• Enhance form design by manipulating control object properties.

• Automate simple tasks by creating macros to open forms and control form properties.

• Make forms more functional and automate tasks by creating macros.

• Enhance the design of reports by hiding repetitive data, grouping data on prefix values, and using functions in controls.

• Use Access to create links to Internet sites, and to save data as HTML documents.

Lesson 1: Designing parameter and action queries

• Creating parameter queries

• Creating action queries

Lesson 2: Outer join and crosstab query techniques

• Joining tables and working with join properties

• Crosstab queries

• Editing limitations in query datasheets

Lesson 3: Form design enhancements

• Building a form based on joined tables; using functions in forms

• Using option groups and additional form design enhancements

Lesson 4: Using command buttons and macros with forms

• Creating macros and command buttons

• Using macros to control form properties

Lesson 5: Using macros to provide user interaction and automate tasks

• Using macros to provide user interaction

• Using macros to automate tasks

Lesson 6: Advanced report techniques

• Hiding duplicate data, grouping data, and using functions in reports

Lesson 7: Introduction to the Internet

• Using hyperlinks
   

 Prerequisite: Windows

• Understand the disadvantages of paper spreadsheets and the advantages of electronic spreadsheets by exploring both.

• Create a basic worksheet by entering text, values, and formulas.

• Create formulas by using Excel’s built-in functions.

• Move and copy data by using shortcut menus, drag-and-drop editing, and toolbar buttons.

• Change the appearance of worksheet data by using a variety of formatting techniques.

• Prepare a document for printing by using the spell checking feature and a variety of printing options.

• Use the three-dimensional aspect of the Excel workbook environment by creating formulas that refer to cells on multiple worksheets.

Lesson 1: Excel basics

• The paper spreadsheet

• The Excel program

• The workbook environment

Lesson 2: Entering data and navigating in a worksheet

• Entering and correcting data

• Saving a file

• Using formulas

• Opening a second file

• Navigation and movement techniques

Lesson 3: Modifying a workbook

• Working with ranges

• Working with functions

• Editing cell contents

Lesson 4: Moving and copying data

• Inserting rows and ranges

• Moving data

• Copying data

• Absolute references

• Using the Fill Series feature

Lesson 5: Formatting a worksheet

• Formatting a worksheet

• Number formats and text alignment

• Copying and pasting formats

• Special and custom formatting

Lesson 6: Printing a worksheet

• Checking spelling

• Using the Print Preview command

• Printing a large worksheet

• Additional print options

Lesson 7: Introduction to the workbook environment

• Using a multiple-sheet workbook

• Creating a chart

• Outlining

• Spreadsheet Solutions
   

 Prerequisite: Experience with topics listed in Excel 2000 Level 1

• Create charts that graphically represent worksheet data.

• Modify charts.

• Customize charts by applying formatting.

• Enhance worksheets and charts by using the drawing tools to add graphic objects.

• Sort information in a list by using the Data, Sort command.

• Locate information quickly in a list that meets specified conditions by using the Advanced filter feature.

Lesson 1: Creating charts

• Creating a chart sheet

• Creating an embedded chart

• Comparing chart sheets with embedded charts

Lesson 2: Modifying charts

• Chart types

• Modifying embedded charts

• Adding and deleting chart items

• Moving and sizing chart items

Lesson 3: Formatting a chart

• Formatting chart text

• Formatting numbers

• Formatting the chart

• Printing a chart sheet

Lesson 4: Using graphic objects

• Adding graphic objects

• Formatting graphic objects

• Using graphic objects to enhance worksheets and charts

Lesson 5: Sorting data

• Single-level sorting

• Multiple-level sorting

• Sorting options

• Design considerations

Lesson 6: Filtering data

• Filtering a list

• Custom criteria

• Multiple-condition criteria

• Managing a filtered list
   

 Prerequisite: Knowledge of topics in Excel 2000 Levels 1 and 2

• Customize toolbars and create styles and templates.

• Create nested and decision making functions.

• Analyze worksheet data by creating pivot tables.

• Compare and contrast workbook files and file links.

• Outline and consolidate worksheets; analyze worksheet data by using the Solver and Scenario Manager.

• Display and protect worksheet data by locking cells.

• Record and modify macros by using the Visual Basic Editor.

Lesson 1: Customizing the work area

• Working with existing toolbars

• Creating a new toolbar

• Creating and using styles

• Creating templates

Lesson 2: Advanced formula construction

• Nested functions

• The IF function

• The VLOOKUP function

• Error handling and the Auditing features

Lesson 3: Pivot tables

• Creating pivot tables

• Working with pivot tables

• Viewing pivot tables at different levels

Lesson 4: Multiple file linking

• Working with workbooks

• Linking individual cells

• Workbooks versus links and workspaces

Lesson 5: Consolidating data and using analysis tools

• Consolidating worksheets

• Using the Goal Seeker and Solver utilities

• Creating a scenario by using Scenario Manager

Lesson 6: Protect and display options

• Using comments

• Protecting the worksheet

• Hiding information

• Custom views

Lesson 7: Introduction to macros

• Running a macro

• Recording a macro

• Viewing and editing VBA code
   

 Prerequisite: Windows

• Become familiar with the Outlook 2000 interface

• Identify the steps necessary to send, to receive, and to act on mail messages

• Use additional message handling options, to insert text into a message, and to create multiple Signatures

• Create personal folders and to organize their Outlook 2000 folders

• Create, edit, and categorize single appointments and recurring appointments

• Create, send, and manage meeting requests

• Create, edit, assign, and track tasks and to create and edit contacts

Lesson 1: Getting started with Outlook 2000

• Overview of Outlook 2000

• Overview of Outlook Today

Lesson 2: Using mail

• Creating and sending messages

• Acting on messages

• Working with address books

• Recalling and printing

Lesson 3: Handling messages

• Message handling options

• Inserting text into a message

• Creating Signatures

Lesson 4: Managing folders

• Creating and using personal folders

• Using the Organize Page

Lesson 5: Working with appointments and events

• Scheduling appointments

• Assigning categories

• Editing appointments

• Inserting events

Lesson 6: Scheduling and managing meetings

• Creating and sending meeting requests

• Working with meeting requests

• Managing meeting responses

Lesson 7: Using the task and contact manager

• Managing tasks

• Adding and editing contacts
   

Prerequisites: Experience with the topics listed in Outlook Level 1

• Manage and arrange Outlook items by sorting, filtering, and using the Find feature; and by displaying custom views and creating custom forms.

• Share information with other Outlook users by creating, posting to, replying to, and editing posts in public folders; creating and posting to Net Folders; and granting other Outlook users folder permissions.

• Communicate with contacts by sending faxes, sharing contacts with other users, and organizing contacts and notes.

• Automatically record items associated with contacts in the Journal by setting options in the Options dialog box.

• Integrate Outlook 2000 with Office applications by importing and exporting Office documents and creating an Office document in Outlook.

• Customize the Outlook environment by creating custom toolbars and menu items to add to the Outlook Bar.

• Investigate Internet and remote mail features by creating HTML documents, adding hyperlinks, and discussing the Outlook Newsreader and remote mail options.

Lesson 1: Arranging messages and using forms

• Sorting, finding, and filtering messages

• Setting rules in a folder by using the Rules Wizard

• Working with views

Lesson 2: Using templates and forms

• Using templates and forms

• Creating forms

Lesson 3: Sharing information by using folders

• Overview of public folders

• Overview of Net Folders

• Working with permissions

Lesson 4: Working with contacts and notes

• Sending and sharing contact information

• Using notes

Lesson 5: The Outlook Journal

• Overview of the Outlook Journal

• Setting options to record Journal entries automatically

Lesson 6: Integrating Outlook components and Office applications

• Integrating Outlook components

• Importing and exporting data from Office applications

• Creating Office documents in Outlook

Lesson 7: Customizing the Outlook environment

• Customizing the Outlook Bar

• Customizing menus and toolbars

Lesson 8: Internet options

• Creating HTML documents and inserting hyperlinks

• Using the Newsreader

• Using Outlook remote mail options
   

 Prerequisite: Windows

• Start the PowerPoint program, identify on-screen features, and navigate through a presentation.

• Create and edit bullet slides.

• Use PowerPoint’s drawing tools to create a slide.

• Incorporate clip art and WordArt objects in a slide.

• Create and enhance organization charts, and create and edit charts by using Microsoft Graph.

• Change the overall appearance of a presentation by using design templates and the Slide Master.

• Run a slide show, become familiar with slide show options, and add notes to a slide.

Lesson 1: Introduction to PowerPoint

• Starting PowerPoint and opening a presentation

• Orientation to the PowerPoint presentation screen

• Orientation to views

Lesson 2: Beginning a presentation

• Creating a title and bullet slide in Slide view

• Creating a slide in Outline view

• Editing slides

• Spelling

Lesson 3: Drawing tools

• Working with drawing tools

• Working with text and drawn objects

• Enhancing drawn objects

Lesson 4: Clip art and WordArt

• Using clip art

• Using WordArt

Lesson 5: Organization charts and Microsoft Graph

• Creating an organization chart

• Organization-chart options

• Orientation to Microsoft Graph

• Editing a column chart

Lesson 6: Templates and the Slide Master

• Selecting and applying a template

• Changing text and bullets in the Slide Master

• Removing Slide Master objects and adding a footer

Lesson 7: Slide shows, output, and presentation options

• Slide show options

• Adding transitions and animation to a slide show

• Running a manual and an automatic slide show

• Working with speaker notes

• Printing a presentation

Lesson 8: Preparing Presentations for the Web

• Using the AutoContent Wizard

• Saving Presentations for Internet Delivery and Viewing
   

 Prerequisite: Experience with the features in PowerPoint Level 1

• Create a custom template by selecting a color scheme, Back to Course Listground fill, and fonts.

• Enhance a presentation by using graphic objects.

• Examine the concept of embedded and imported information by using Microsoft applications.

• Enhance a slide containing a flow chart by using advanced drawing techniques.

• Customize the PowerPoint environment by modifying toolbars and using the Options dialog box.

• Enhance a presentation by using animation.

• Bring PowerPoint meeting notes into Word by using the Meeting Minder.

Lesson 1: Working with templates

• Working with presentations

• Creating your own template

• Working with fonts

Lesson 2: Working with graphic objects

• Working with clip art

• Using AutoCorrect and the Style Checker

Lesson 3: Importing and embedding objects

• Creating a table

• Enhancing the table

• Editing the table

• Importing and embedding charts

Lesson 4: Advanced drawing techniques

• Aligning and rotating flow-chart objects

• Enhancing flow-chart objects

Lesson 5: Additional PowerPoint features

• Customizing PowerPoint toolbars

• Other customization options

• Working with the Internet and hyperlinks

Lesson 6: Examining animation and multimedia

• Working with animation

• Multimedia

Lesson 7: Working with meeting notes

• Using the Meeting Minder

• Sending slides to Word
   

Lesson 1: Overview of project management

•  Objective of software

•  Terminology

•  Screen tour

 Lesson 2: Tasks

• Listing tasks

• Task notes

• Recurring tasks

• Milestones

• Summary tasks

Lesson 3:  Linking

• Definition

• Types of links 

Lesson 4: Constraints

• Constraint types

• Cautions

• Violating constraints

Lesson 5: Calendars

• Project calendars

• Resource calendars

Lesson 6: Resources

• Creating resources

• Assigning resources

• Viewing resource efficiency

• Viewing resource costs

Lesson 7: Printing

• Printing views

• Reports

• HTML

• Gif file

Lesson 8: Saving a baseline

• When to save a baseline

• How to save the primary baseline

• Saving additional baselines

Lesson 9: Tracking actuals

• Who enters the facts

• Views for entering actuals

• Communicating assignments via Outlook

• Adjusting the schedule

Lesson 10: Managing a project

• Manage deadlines

• Manage costs

• Manage resources

Lesson 11: Managing multiple projects

• Create a resource pool

• Create a master project

Lesson 12: Formatting and customization

• Customizing views, tables, reports

• Using the Organizer

 Prerequisite: Windows

• Create and save a document; open an existing document; and use simple editing techniques.

• Navigate in a large document by using the mouse and keyboard.

• Edit a document by using more sophisticated techniques, including moving and copying text within a document and between documents.

• Apply and remove character and paragraph formatting.

• Use tabs and create and modify a table structure.

• Adjust margins, add and delete page breaks, and create headers and footers.

• Use Word’s proofing tools such as the speller and thesaurus.

Lesson 1: Word basics

• Introduction to Word

• The basics of entering text

• The File, Save As command

• Opening and editing a document

• Saving a document

Lesson 2: Navigating in a document

• Scrolling in a document

• Searching in a document

Lesson 3: Additional editing techniques

• Using the AutoCorrect feature

• Techniques for selecting text

• Moving and copying text

Lesson 4: Character and paragraph formatting

• Basic character formatting techniques

• Advanced character formatting techniques

• Paragraph formatting

• Working with indents, numbered lists, and bulleted lists

• Line breaks and line spacing

Lesson 5: Introduction to tabs and tables

• Tabs

• Creating a table

• Enhancing a table

Lesson 6: Controlling page appearance

• Headers and footers

• Margins

• Page breaks

Lesson 7: Tools and printing

• Using proofing tools

• Printing a document

• Envelopes and labels
   

 Prerequisite: Windows and Word 2000 Level 1

• Create, modify, perform calculations in, and import data in tables

• Use styles to affect the appearance of paragraphs and create outlines

• Create and use templates, and create a fax template

• Merge a document with data to create multiple variations of a document

• Create, run, and edit macros

• Format text in columns with graphics; use section breaks to format a document

• Discuss Internet features, create and edit an HTML document, and view the document source code

Lesson 1: Tables

• Tables

• Drawing a table

• Performing calculations in tables

• Creating charts

• Importing worksheets and data

Lesson 2: Introduction to styles

• Applying styles

• Creating styles

• Redefining and deleting styles

• Using styles to create an outline

Lesson 3: Introduction to templates

• Using templates

• Using a fax template

• Examining the Normal template

Lesson 4: Introduction to merging

• Creating data

• Completing main documents

• Merging data with the main document

• Managing merges

• Creating catalogs

Lesson 5: Introduction to macros

• Creating and assigning macros

• Editing and testing macros

• Deleting a macro

Lesson 6: Newspaper columns

• Formatting text into newspaper columns

• Using graphics

• Sections

• Sorting
   

 Prerequisite: Windows, Word 2000 Level 1 and Word 2000 Level2

• Use advanced techniques for working with styles

• Create and use templates and forms

• Enhance documents by drawing in a document and using clip art and WordArt

• Create a master document, a table of contents, and an index

• Enhance document layout

• Use highlights, comments, and revision marks to edit and share documents online

Lesson 1: Advanced styles

• Using the AutoFormat feature

• Linking styles

• Managing styles

Lesson 2: Creating templates and forms

• Examining templates

• Creating and enhancing a template

• Creating a form

Lesson 3: Using graphic effects

• Drawing in a document

• Working with clip art and graphic effects

• Using WordArt

Lesson 4: Working with large documents

• Creating a master document

• Generating an index

• Preparing to print

Lesson 5: Document layout

• Using sections to control layout

• Formatting a document for binding

• Creating footnotes and endnotes

• Using bookmarks

• Creating cross-references

Lesson 6: Sharing documents

• Routing a document

• Using highlights and comments

• Creating, comparing, and merging multiple versions of documents
   

 1. The learning environment

• Principles of adult learning

• Understanding different learning styles

• Selecting the most appropriate learning strategy

• Understanding different input styles

• Setting expectations

• Selecting the most effective instructional methods

• Keeping in control of the learning environment

• Handling problem students

• Dealing with fast and slow students

2. Practical presentation tools

• Employing effective public speaking skills

• Making students feel comfortable

• Using your body effectively

• Developing a colorful voice

• Identification of common voice problems

• Building rapport with eye contact

• Adding interest and humor to your teaching

• Accepting and delivering constructive criticism

• Watching your vocabulary

• Promoting maximum learner participation

• Using examples, analogies, visual aids

• Responding effectively to student questions

• Alternatives to lecture

3. Presentation content

• Explaining the concept

• Demonstrating the concept

• Guiding exercises

• Pacing exercises

• Ongoing improvement

4. Additional resources

• Trainer competencies

• Measuring effectiveness of presentation

• Designing effective exercises

• Evaluation tools

• Web sites

• E-newsletters

Prerequisite: Windows

• Create a simple web with text, graphics and links

• Enhance pages with Back to Course Listground colors, sound, and themes

• Control layout with tables

• Import and publish webs

• Use the FrontPage task list

Lesson 1: Overview

• Screen tour

• Create a one-page web

• Create a web using a wizard

• Insert files from other applications

Lesson 2: Linking

• Internal links

• Bookmark links

• External links

• E-mail links

• Creating a navigation bar

Lesson 3: Enhancing web pages

• Format text

• Change page properties

• Add sound

• Share Back to Course Listground information

• Examine HTML tags

• Use Reveal Tags

• Apply themes

Lesson 4: Add pictures

• Graphic sources

• Add a picture

• Change picture properties

• Add alternative text

• Use pictures as hyperlinks

• Create hotspots

• Set a transparent color

• Resample a picture

• Autothumbnails

Lesson 5: Work with tables

• Create a table   

• Insert columns and rows

• Delete columns and rows

• Merge and split cells

• Resize cells

• Change table properties

Lesson 6: Manage a web

• Publish a web

• FrontPage Server extensions

• Import a web-based web

• Import a disk-based web

• Manage web files

• Verify hyperlinks

• Create, update and complete tasks
   

Prerequisite: Windows and FrontPage 2000 Level 1

• Design considerations

• Web location options

• Create frame pages

• Create forms

• Insert components and animation

• Create and use style sheets

• Apply and modify themes

Lesson 1: Tips for Getting Started

• Storyboarding

• Wizards

• Examine features of notable webs

• Design considerations

• Browser issues

Lesson 2: Web Location Options

• Disk-based webs

• Server-based webs

• The Personal Web Server

Lesson 3: Structure a Web

• Create sub webs to facilitate maintenance and security

• Create shared borders

• Place a navigation bar in a shared border

• Turn off a shared border

• Set alternative shared border

Lesson 4: Create frames

• Create a framed page

• Save and name a frameset

• Create an alternative no-frame page

• Set hyperlinks to frame sections

• Control frame properties

• Scroll bars

• Resizing

Lesson 5: Create forms

• Create a form

• Use and define form fields

• Set form-field properties

• Handle form results

• Create a confirmation page

• Use FrontPage with databases

Lesson 6: Work with Components

• Marquee

• Banner Ad Manager

• Hit Counter

• Search Forms

• Hover buttons

• Excel data

• ActiveX and Java applets

Lesson 7: Animation

• Marquees

• Text animation

• Page transitions

• Collapsible lists

Lesson 8: Style sheets

• Cascading style sheets

• External style sheets

• Embedded style blocks

• Inline styles

Lesson 9: Themes

• Use a theme

• Customize a theme

• Disable a theme for selected pages

• Download themes

©pctrainingcentral.net2004