Layout Table~~~~3974~3974~~

Office 2000 18 Sessions - 54 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 Professional Training Series, you gain a powerful understanding of all the Microsoft business applications. This training course covers all the objectives for the Microsoft Office Specialist exams and covers 3 sessions each of Access, Excel, Outlook, PowerPoint, Publisher and Word.

Benefits
• Quickly gain mastery of Microsoft 2000 office products and maximize your productivity.
• Be confident in understanding the best tool to make office tasks a breeze.
• Create professional, informational documents that communicate your ideas and expertise. .~~~3974~3975~~

Course Outline Table~~~~3974~3976~~

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~~~3974~3977~~

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~~~3974~3978~~

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~~~3974~3979~~

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~~~3974~3980~~

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~~~3974~3981~~

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~~~3974~3982~~

Outlook Session 1~Section A: Introduction
· Interface
· Outlook Defined
· Email Interface
· Personal Information

Section B: Email Basics
· Make a New Email
· Sending Options

Section C: Customizing Email
· Stationary
· Email in Word
· Create New Stationary

Section D: Receiving Email
· Preview & Icons
· Attachments
· Reply
· Forwarding
· Sorting the Inbox
· Finding
· Printing
· Recalling

Section E: Organizing Outlook
· Components
· Folders

Section F: Advanced Email
· Folders
· Colors
· Views
· Junk Email
· Controlling Email~~~3974~3993~~

Outlook Session 2~Section A: Contact Basics
· Add New Contact
· Phone Number in Outlook
· Categories
· All Fields
· Your Own Field
· Contact Follow Up
· Delete Contact
· Send Email to Contact
· Adding Contact through Email

Section B: More Contacts
· V Card Option
· Add V Card to Contacts
· Distribution List
· Organization Function
· Using News
· Create New Group
· Create Personal Address Book

Section C: Calendars
· Calendar Functions
· Options
· Appoint Management Event
· Events

Section D: Share Calendars
· Printing
· Putting it on the Web
· Sharing Your Calendar
· Sharing Any Folder
· Editing a Share
· NetMeeting
· NetShow

Section E: Tasks
· Setting Up a Task
· Assigning a Task
· Accepting a Task
· Updating a Task
· Organizing~~~3974~3992~~

Outlook Session 3~Section A: Journal
· Journal Options
· Journal View
· Making & Reviewing Entries

Section B: Notes
· Creating a Note
· Configuring Notes
· Forwarding Notes

Section C: Outlook Today
· Customizing Outlook
· Customizing Toolbars
· Adaptive Menus
· Help

Section D: Working with Office
· Emailing a Word Document
· Emailing an Excel Document
· Working within Outlook
· Import & Export
· Cut & Paste

Section E: Mail Merge
· Contact Dialog Box
· Inserting Fields & Performing a Merge

Section F: Newsgroups
· Internet connection Wizard
· Subscribing to a Newsgroup
· Reading Messages

Section G: Forms
· Designing a Form

Section H: Out of Office
· Setting Up Remote Access
· Synchronization
· Offline Folders
· Performing Synchronization
· Out of Office Assistant
· Delegate Access
· Tracking Options

Section I: Archive
· Auto Archive
· Archiving Right Now

Section J: Fax Services
· Compose New Fax
· Fax Properties
· Cover Page
· Receiving Faxes
· Favorites~~~3974~3991~~

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~~~3974~3983~~

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~~~3974~3984~~

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~~~3974~3985~~

Publisher Session 1~Section A: Introduction
· Desktop Publishing Defined
· Templates
· Work Space & Pages
· Toolbars & Menus

Section B: Working with Frames
· Picture Frame
· Manipulating Frames
· Text Frame
· Zoom
· Inserting Text & Elements
· Grouping Objects

Section C: Publisher Basics
· Personal Information
· Using the Template Wizard
· Color Scheme
· Editing Content & Text
· Logo Wizard
· Type Format

Section D: Customizing a Template
· Editing Text
· Columns
· Fitting Text to Columns
· Save & Remind to Save
· Customize Content
· Overflow Text
· Remove Pages
· Insert Pictures

Section E: Document FoundationBlank Publication
· Master Page
· Ruler Guide
· Layout Guide

Section F: Text Handling
· Manipulating Text
· Hide Guides
· Flowing Text
· Fine Tuning Text
· Insert a Graphic
· Text Wrap
· Column Balance
· Error Correction
· Printing~~~3974~4004~~

Publisher Session 2~Section A: Automated Text Handling
· Session Overview
· Formatting Issues
· Hidden Characters
· Design Checker
· Search & Replace
· Metacharacters
· Spaces with Characters
· Smart Quotes

Section B: Styles
· Text Styles
· Apply Styles
· Edit Styles
· Create Subheads
· Create Shortcut with Word
· Modify & Update Styles
· Import Styles

Section C: Typographic Controls
· Hyphenation
· Line Breaks
· Line Spacing
· Tracking & Kerning

Section D: Working with Graphics
· Picture Frame
· Insert Picture
· Cropping & Resizing
· Rotate, Position & Scale
· Customize Text Wrap
· Scanning
· Half Tone

Section E: Tables
· Table of Contents
· Tabs
· Table Tool
· Adjusting Tables
· Adding Text
· Formatting Cells

Section F: Headers, Footers & Page Numbering
· Master Page
· Ignore Background
· Electronic White Out~~~3974~4003~~

Publisher Session 3~Section A: Foundations
· Session Overview
· Options
· Auto Fit
· Save with Backup

Section B: Navigation & Interface
· Page Controls
· Multiple Documents
· Scrolling
· Multiple Pages
· Zoom Controls
· Show Guides

Section C: Tips & Tricks
· Format Printer
· Character Map
· Replace Using the Clipboard
· Line Spacing
· Page & Column Breaks
· Clip Art for the Web

Section D: Creating a Web Site
· New Web page
· Design Gallery
· Layout Page
· Insert Pages
· Prepare to Publish
· Add Manual Links
· Save as a Web Page

Section E: Converting to a Web Site
· Automatic Conversion
· Modify the Web Site
· Manual Conversion

Section F: Mail Merge
· Integrate Files
· Data External Source
· Merge
· Filter & Sort
· Data Internal Source

Section G: Color Publications
· Pantone
· Tint Effects
· Print Spot Color
· Photo Printing

Section H: Special Elements
· Shapes
· WordArt
· Drop Caps~~~3974~4002~~

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~~~3974~3986~~

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"~~~3974~3987~~

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~~~3974~3988~~

Ordering~~~~3974~3989~~

Office 2000 Professional 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|270678|LIBRARY LICENCE%3A CD Course|270675|~3974~3990~office 2000 access word excel powerpoint outlook~