Layout Table~~~~3957~3957~~

Office 2000 12 Sessions - 36 Hours of Interactive Training~
Learning Microsoft Office 2000 skills will help you succeed in today’s business environment with more speed, collaboration, data analysis, and reliability than ever before. With the LearnKey Office 2000 Core Training Series, you gain a powerful understanding of the most widely used Microsoft business applications. LearnKey courses meet or exceed all objectives for the Microsoft Office Specialist exams, and you’ll have the tools you need for star performance in today’s business environment.

Comprehensive instruction for the most widely used Microsoft Office 2000 applications. 3 sessions each of Word, Excel, PowerPoint and Access..~~~3957~3958~~

Course Outline Table~~~~3957~3959~~

Access Session 1~Section A: Introduction
· Uses for a Database
· Access & Other Office Applications
· Understanding & Comparing Tables
· Creating a New Database

Section B: Creating an Attribute Table
· Datasheet View
· Design View
· Entering Values
· Datasheet Features
· Print Preview
· Access vs. Excel
· Saving Design Changes

Section C: Creating a Lookup Table
· Creating a New Table
· Creating a Primary Key
· Creating a Relationship Between Tables
· Cascade Update & Deletes
· Entering Data in a Sub-form
· Creating a Lookup to a Text Key

Section D: Creating Queries
· Sorting & Filtering
· Save as a Query
· Editing a Query in Design View
· Using the Query Wizard to Join Tables
· Changing Values in a Query

Section E: Creating Forms
· Create an AutoForm
· Columnar, Datasheet & Tabular Forms
· Printing Form

Section F: Creating a Measures Table
· Designing a Measures Table
· Using Automatic & Primary Keys
· Specifying Column Data Types
· Creating a Lookup
· Preventing Duplicate Keys
· Relating Tables

Section G: Creating Summary Queries
· Creating Summary Queries
· Crosstab Queries

Section H: Creating Reports
· Create a Tabular Report
· Using the Report Wizard
· Editing the Report

Section I: Discovering More
· Customize Access
· Using the Office Assistant & Help Window~~~3957~3967~~

Access Session 2~Section A: Designing a Database
· Introduction
· Field Names
· Keys

Section B: Importing & Exporting Tables
· Importing from Access
· Exporting
· Copying To & From Excel

Section C: Customizing Field Definitions
· Field Features
· Order Detail Table

Section D: Extending Queries
· Making a New Query
· Filters & Criteria
· Add a Field

Section E: Creating Action Queries
· Create New Query
· Modify Query
· Update Action Query
· Delete Query

Section F: Managing a Database
· Suggestions
· Database Security
· Synchronization
· Linking Databases

Section G: Improving Database Design
· Table Indexes
· Relationships
· Splitting Tables~~~3957~3966~~

Access Session 3~Section A: Creating Report Details
· Creating Forms & Reports
· Queries in Design View
· Creating Reports in Design View
· Linking Reports to Queries
· Altering Labels
· Adding Files
· Converting Text Boxes to Labels
· Refining Label Location

Section B: Creating Report Groupings
· Sorting & Grouping
· Creating Extended Price
· Adding Text Boxes
· Forcing New Pages
· Formatting Reports

Section C: Enhancing the Layout of a Report
· Creating a Page Header
· Adding Logos & Images
· Header & Cover Page Options

Section D: Creating Form Details
· Form & Report Differences
· Copying Controls & Labels
· Headers & Footers
· Linking Data
· Changing Unit Price
· Altering Form List
· Locking & Enabling Form Changes
· Changing Product Name
· Adding a Calculated Field

Section E: Creating Form Grouping
· Renaming & Creating Forms
· Adding & Arranging Controls
· Adding Subforms

Section F: Enhancing the Layout of a Form
· Controlling the Form & Subform Display

Section G: Displaying Data in a Chart
· Creating a Chart

Section H: Automating Access
· Adding Form Controls
· Adding a Graphic Image
· Using the Macro Builder
· Creating a Switchboard
· Splitting the Database

Section I: Integrating with the Internet
· Creating a Hyperlink
· Exporting Queries to HTML Documents
· Creating a Data-access Page

Section J: Tips for the Certification Test
· Key Exam Points~~~3957~3965~~

Excel Session 1~Section A: Introduction
· Uses for a Spreadsheet
· Understanding the Excel Workspace
· Selecting a Range of Cells

Section B: Entering Values
· Entering Text, Numbers & Dates
· Formatting Dates & Editing Values
· Sorting a List

Section C: Managing Workbooks
· Saving a Workbook
· Opening & Closing Workbooks
· Workbook Add, Delete, Rename & Move

Section D: Creating a Form or Document
· Creating a Form or Document
· Changing Fonts, Color & Alignment
· Formatting Dates
· Resizing Columns & Rows
· Creating Backgrounds & Borders
· Inserting Columns
· Merging Cells

Section E: Summarizing Numbers
· Using Auto Fill
· Using Tab to Enter Values
· Creating Totals Automatically
· Understanding the SUM Function
· Creating & Validating Formulas

Section F: Formatting Numbers
· Currency Style
· Auto Formatting Regions & Moving Cells

Section G: Creating Charts
· Adding a Chart
· Adding New Values to a Chart
· Creating a Custom Chart
· Using the Chart Toolbar & Menu
· Chart Location

Section H: Creating Charts
· Print Preview & Page Setup Options
· Preview Color in Black & White
· Selecting Multiple Sheets
· Printing

Section I: Customizing Excel
· Changing Workbook Options
· Using Adaptive Menus & Toolbars
· Context Sensitive Toolbars

Section J: Discovering More
· Screen Tips
· Use Help in Dialogue Boxes
· Using the Office Assistant
· Help Context~~~3957~3960~~

Excel Session 2~Section A: Managing References
· Relative References
· Using Auditing Toolbar
· Mixed & Absolute References
· Saving Workbooks

Section B: Named Ranges
· Naming Cells
· Naming Ranges
· Applying Names

Section C: Manipulating Ranges
· Importing Files
· Special Formatting Features
· Find/Replace

Section D: Basic Functions
· Summarizing Functions
· 3D Formulas
· Logical Functions
· Date Functions

Section E: Look-up Functions
· Types of Look-ups
· Vertical Look-up
· Applying Names to Vertical Look-up

Section F: Financial Functions
· Types of Financial Functions
· Calculating Payments

Section G: Considering Alternatives
· Using Scenarios
· Report Manager
· Using Goal Seek
· Using the Solver

Section H: Enhanced Formatting
· Formatting Numbers
· Formatting Text
· Applying Styles

Section I: Dynamic Formatting
· Applying Conditional Formats
· Using Data Validation

Section J: Graphical Objects
· Using the Drawing Toolbar
· Adding Comments
· Inserting Pictures~~~3957~3961~~

Excel Session 3~Section A: Managing Workbooks
· Introduction
· Adding a File Password
· Protecting a Workbook
· Freezing Row & Column Headers
· Changing Page Breaks
· Printing Portions of a Worksheet
· Setting Workbook Properties
· Creating a Workspace

Section B: Using Templates
· Saving & Editing a Template
· Changing the Default Template
· Changing the Default Worksheet Template

Section C: Sharing a Workbook
· Sharing a Workbook
· Editing a Shared Workbook
· Tracking Changes to a Shared Workbook
· Merging Workbooks

Section D: Query a Database
· Retrieving Data from a Database
· Filtering the Data using Microsoft Query

Section E: Working with Lists
· Sorting Lists
· Using a Form to View/Search a List
· Using AutoFilter
· Using the Advanced Filter
· Adding Subtotals to a List
· Tracing Errors

Section F: Working with PivotTables
· Creating a PivotTable
· Formatting a PivotTable
· Creating a PivotChart

Section G: Excel & the Internet
· Saving a Workbook as HTML
· Saving HTML with Interactivity
· Saving an Interactive PivotTable as HTML
· Importing Values from a Web Site
· Creating Hyperlinks in a Worksheet
· Using the Office Clipboard
· Round Tripping to HTML & Back Again

Section H: Creating Macros
· Creating & Running a Macro
· Looking at a Macro's Code
· Creating Another Macro
· Editing the Macro
· Creating a Button to Run a Macro

Section I: Preparing for Certification
· The Testing Method
· Tips for the Exam~~~3957~3962~~

PowerPoint Session 1~Section A: Introduction
· PowerPoint Possibilities
· Making Your Presentation Sharp

Section B: The Microsoft Method
· Introduction to the Microsoft Method
· Creating Outlines
· Inserting New Slides
· Introducing Different Types of Slides
· Outline View
· Organizing Slides

Section C: Preparing a Presentation
· Help
· Templates
· Page Layout

Section D: Building a Presentation
· Creating a New Presentation
· Adding Content
· Saving

Section E: Working with Objects
· Prepare the Workspace
· Creating Objects
· Manipulating Objects

Section F: Formatting Objects
· Fill Colors
· Fill Effects
· Lines
· Other Options

Section G: Working with Multiple Objects
· Selecting Multiple Objects
· Aligning Objects
· Zoom
· Order
· Custom Toolbar
· Semi-transparent
· Grouping
· Align & Distribute
· Clipboard
· Rotate & Flip
· Changing Format~~~3957~3970~~

PowerPoint Session 2~Section A: AutoShapes
· Control Handles
· Lines
· Free Hand Tool
· Connectors
· Making Decisions

Section B: Text Boxes
· Creating & Manipulating Text Boxes
· Formatting
· Justification & Bullet Points

Section C: More Text Boxes
· Find & Replace
· Paragraph Formatting
· Turning AutoShapes into Text Boxes

Section D: Pictures
· Formatting Pictures
· Brightness
· Framing

Section E: Slide Master
· Logos
· Title & Bullets
· Bars
· Background
· Color Scheme
· Title Master
· Saving as a Template
· Applying Design

Section F: WordArt
· Inserting
· Formatting

Section G: Tables
· Building Tables
· Formatting Tables
· Word Tables

Section H: Graphs
· Building a Graph
· Graph Type
· Integrating Excel

Section I: Organization Charts
· Creating a Chart
· Editing

Section J: Basic Presentation
· Inserting Slides
· Header & Footer
· Handouts & Notes
· Presenting~~~3957~3969~~

PowerPoint Session 3~Section A: Finalizing Presentations
· Slide Transitions
· Text Animation
· Object Animation
· Navigation Buttons
· Save as a Web Page

Section B: Advanced Customization
· Change Presentation
· Sounds
· Video
· Animated GIF's
· Run Custom Shows
· Hyperlinks

Section C: Finishing Up
· Rehearse Timings
· Record Narration
· Set Up Show

Section D: Working with Other Programs
· Import Outlines
· Save Outlines
· Summary Slide
· Save a Graphic
· Genigraphics

Section E: Delivering Presentations
· Broadcast Configuration
· Broadcast a Presentation
· Park & Go
· Review~~~3957~3968~~

Word Session 1~Section A: The Word Window
· Opening Word & the Word Window
· Opening Past Documents

Section B: Selecting
· Select & Do
· The Undo Command
· Selecting More Efficiently

Section C: Commands & Shortcuts
· Deleting, Moving, & Copying Text
· Menus, Buttons, & Shortcuts
· Personalized Menus & Toolbars
· More Toolbars
· Shortcuts
· The Right Click

Section D: Maintaining Your Sanity
· Saving Your Work
· Fixing Mistakes
· Saving & Salvaging Your Work
· Help

Section E: Templates
· Page Setup Templates
· Customizing Your Default Text Format
· Template Options
· Creating Templates
· Finding & Altering Templates

Section F: Creating Content
· Typing Basics
· Word's Helpful Hints
· Accents & Signs
· AutoCorrect & Autoformat
· AutoCorrect & Its Functions

Section G: Formatting
· Using the Right Click
· Shortcuts
· Viewing Fonts Correctly
· The Paragraph Command

Section H: Printing
· Print Preview
· Printing Options~~~3957~3973~~

Word Session 2~Section A: Copy, Paste & Paste Special
· Open Dialog Box
· Select, Copy & Paste
· Paste Special
· The Clipboard
· Collect & Paste

Section B: Automating Content Creation
· Templates
· AutoCorrect & AutoComplete
· AutoText
· Review

Section C: Lists
· Bulleted Lists
· Picture Bullets
· Numbered Lists
· Online Numbered Lists
· Customizing Online Numbered Lists

Section D: Format Techniques
· Paragraph Command & Formatting Shortcuts
· Click & Type
· Font Command
· Borders & Shading Command
· Format Painter & Repeat Command
· Style Command

Section E: Understanding Tables
· What should be in a Table

Section F: Creating Tables
· Adding a Table
· Formatting a Table
· Automating Table Creation

Section G: Managing Tables
· Table Selection Shortcuts
· Table Properties Command
· Adding & Deleting Columns
· Splitting & Merging Cells
· Tables & Borders Toolbar

Section H: Tabs
· Types of Tab Stops
· Creating, Moving & Deleting Tab Stops
· Decimal & Leader Tab Stops

Section I: Saving & Sending Documents
· "Save AS" & "Send TO" Commands
· Web Page Preview & Save as Web Page
· Creating Folders from "Save As"~~~3957~3972~~

Word Session 3~Section A: Thesaurus, Find & Replace
· Thesaurus, Find & Replace
· "More Option" of the Replace Command

Section B: Using Graphics
· Adding & Positioning Clip Art
· Formatting Clip Art
· Inserting & Formatting a Picture
· Inserting & Formatting WordArt
· Drawing Toolbar

Section C: Text Flow
· Inserting Page Flow
· Line & Page Breaks

Section D: Navigating Long Documents
· Heading Styles & Go To
· Bookmarks & Keyboard Shortcuts
· Hyperlinks

Section E: Sections
· Inserting a Section Book
· Page Orientation
· Borders & Shading Tab
· Vertical Alignment

Section F: Column
· Reformatting Text into Multiple Columns
· Adding Text into Multiple Columns
· Column Break Command

Section G: Headers & Footers
· Page Numbers
· Headers & Footers Toolbar

Section H: Complex Headers & Footers
· Modifying First Page Headers & Footers
· Modifying Section Headers & Footers

Section I: Letters, Envelopes & Labels
· Letter Wizard
· Creating Letter Templates
· Adding a Date & Saving the Template
· Envelopes & Labels

Section J: Mail Merge
· Creating a Data Source for Mail Merge
· Inserting Merge Fields
· Merging & Review

Section K: Complex Mail Merge
· Creating Data Sources in Excel
· Creating Mailing Labels
· Sorting & Filtering~~~3957~3971~~

Ordering~~~~3957~3963~~

Office 2000 Core Training Course by LearnKey~Per Seat Licencing Available

Call 01223 894 136 for quotes for MULTIPLE USERS and Training Centre/Bootcamp & Education Solutions!~~PER USER%3A CD Course|270818|LIBRARY LICENCE%3A CD Course|270815|~3957~3964~office 2000 access word excel powerpoint~