Office 2002/XP Professional Training Course by LearnKeyCBT

Office XP 15 Sessions - 45 Hours of Interactive Training~Office XP is one Microsoft’s recent versions of the most popular office productivity software suite. With the Office XP Professional Training Series of training courses from LearnKey, you’ll easily learn to use Access 2002, Excel 2002, Outlook 2002, PowerPoint 2002 and Word 2002. LearnKey expert instructors will quickly have you managing documents, organizing your communications and building spreadsheets, databases and professional looking presentations. At the conclusion of this training series, you’ll feel confident using the 2002 version of the Office programs and understand basic and advanced features.

Benefits
• Quickly gain mastery of Microsoft 2002 office products and maximize your productivity.
• Be confident in understanding the best tool to make office tasks a breeze.
• This course covers all the objectives for the Microsoft Office Specialist exams.~~~4005~4006~~

Course Outline Table~~~~4005~4007~~

Access Session 1~Section A: Introduction
· Database Concepts
· Relational Databases
· Task Pane
· Tables
· Forms
· Queries
· Reports

Section B: Database Wizard
· Database Development
· Build a Database

Section C: Table Essentials
· Table Wizard
· Relationships
· Field Names
· Text & Number Data Types
· Other Data Types
· Primary Key

Section D: Datasheet View
· Add New Record
· Delete Record
· Office Clipboard

Section E: Table Appearance
· Column Width
· Font & Cell Effects
· Moving & Hiding Columns

Section F: Filter Techniques
· Sorting Records
· Find a Record
· Filter By Selection

Section G: Query Essentials
· Relationships
· Query Wizard
· Dynaset Concepts
· Add Criteria
· Comparison Operator
· Wildcards

Section H: Form Essentials
· Form Wizard
· AutoForm

Section I: Report Essentials
· Report Wizard
· Calculated Control
· Print Preview
· Label Wizard~~~4005~4015~~

Access Session 2~Section A: Field Properties
· Field Size
· Data & Time
· Context Sensitive Help
· Yes & No Fields
· Default Value
· Validation Rule
· Indexed Field

Section B: Create a Lookup
· Insert a field
· Lookup Wizard
· Limit to List

Section C: Importing & Exporting Data
· Export to Excel
· Import from Access
· Import from Excel
· Link Data from Excel
· Share a Database
· Database Splitter

Section D: Relationships
· Relate Tables
· Referential Integrity
· Cascade Options
· Print Relationships

Section E: Advanced Query Techniques
· Parameter Queries
· Multiple Parameters
· Calculated Fields
· Expression Builder
· Summary Queries

Section F: Using Access & HTML
· Properties of HTML
· Creating a Hyperlink
· Using Hyperlinks
· Publish Database to HTML Format
· Creating Data Access Pages
· Accessing Access Pages in Browser~~~4005~4014~~

Access Session 3~Section A: Merging Access into Word
· Mail Merge Wizard
· Create Letter
· Run Merge

Section B: Action Queries
· Make Table Query
· Append Query
· Delete Query
· Run Delete Query
· Update Query
· Print Queries

Section C: Compact & Backup
· Compact & Repair Utility
· Backup & Restore Tool

Section D: Form Design
· Print Records
· Form Controls
· Calculated Controls
· Object Properties
· Event Procedures
· Working with Controls

Section E: Advanced Form Design
· Adding Fields
· Saving & View Form
· Adjust Tab Order
· Add Combo Box
· Add Command Button
· Add Graphic
· Add Header & Footer
· Add ActiveX Control
· Input Mask Wizard

Section F: Report Design
· Headers & Footers
· Move & Resize Controls
· Add Controls
· Add Calculated Control
· Add Group & Sorting Control
· Pagebreak Control
· Report Footer

Section G: Macros
· Creating, Saving & Running Macros
· Perform Queries from Macros
· Assigning a Macro to Event Procedures

Section H: Switchboard
· Creating Switchboard
· Editing Switchboard
· Switchboard in Action
· Set a Startup Option~~~4005~4013~~

Excel Session 1~Section A: Introduction & Simple Lists
· Introduction
· Cell Reference
· Creating Lists
· Simple Formatting
· AutoFill Values
· Format Painter

Section B: Workbooks & Worksheets
· Save a Workbook
· File Properties
· Rename & Delete Worksheets
· Move & Copy Worksheet
· Printing a Workbook

Section C: Manipulating Values
· Editing Values
· Insert, Delete & Move Cells
· Copy Cells
· Comments
· AutoFilter
· Find & Replace

Section D: Charts
· Create a Chart
· Chart Options
· Manipulate Values
· Chart Type
· Secondary Axis
· Add Values

Section E: Summarizing Values
· New Worksheet
· Add Values
· AutoSum
· AutoFormat
· Modifying Format Styles

Section F: Formatting & Graphics
· Create a Grid
· Create a Border
· WordArt
· Add Text
· Merge & Center
· Insert Clip Art
· Drawing Object
· Rotated Text
· Print Preview

Section G: Using Help
· Tool Tips
· Office Assistant
· Ask a Question Box
· Context Sensitive Help
· Comprehensive Help~~~4005~4018~~

Excel Session 2~Section A: Financial Functions
· Loan Calculation
· Insert Function
· Name Ranges
· Amortization Table
· Future Value
· Date Functions
· Dynamic Dates

Section B: What-If Analysis
· Goal Seek Command
· Create Scenarios
· View Scenarios
· Single-input Data Table
· Two-input Data Table

Section C: Relative & Absolute References
· Expense Allocation
· Formula Auditing
· Trace Precedents
· Finding Errors
· References
· Evaluate Formulas

Section D: Protection
· Protect Worksheet
· Unlock Cells
· Protection Options
· Protect Workbook
· Control Input

Section E: Lookups
· Named Range
· Exact Lookup
· Bonus Amount
· Range Lookup
· Moving Ranges
· External References
· Update & Repair Links
· Hyperlinks

Section F: Advanced Formatting
· Custom Number Formats
· Conditional Formatting

Section G: Consolidating Values
· Budget Template
· Save As Template
· Enter Values
· Consolidate: Sum
· Consolidate: Link
· Create Workspace
· 3D Formulas

Section H: Sharing Workbooks
· Share a Workbook
· Track Changes
· Merge Workbooks~~~4005~4017~~

Excel Session 3~Section A: Creating Sample Data
· Sample Database
· Replicate Ranges
· Sort Command
· Random Numbers

Section B: Exporting & Importing Data
· Export to Text
· Export to Database
· Import from Database
· Import from Text
· Import Text Wizard

Section C: Advanced Filters
· Custom AutoFilter
· Advanced Filter
· Extract a List

Section D: Subtotals & Outlines
· Subtotal
· Outline
· Nesting Subtotals
· Manual Grouping

Section E: Summarizing with a PivotTable
· Create a PivotTable
· PivotTable Field List
· Manipulate a PivotTable
· Format
· Group Data
· Create a PivotChart
· Manipulate a PivotChart
· AutoFormat

Section F: Publishing Workbooks
· Preview Large Document
· Freeze Headings
· Header
· Footer
· Preview a Chart
· Print a Chart
· Static HTML Page
· PivotTable Interactivity
· Spreadsheet Interactivity
· Web Queries

Section G: Creating Macros
· Record Macros
· Play Macros
· Visual Basic
· Edit a Macro
· Toggle Macro

Section H: Adding User Interface
· Custom Toolbar
· Menu Command
· Security Level
· Workbook Button
~~~4005~4016~~

Outlook Session 1~Section A: Introduction
· Outlook Features
· Email Options
· Outlook Interface
· Navigation Options
· Outlook Today
· Customize Outlook Today

Section B: Creating Messages
· Using the Inbox
· Create New Message
· Addressing Options
· Name Checking
· Completing Your Message
· Send Message

Section C: Working With Messages
· Changing Format
· Spell Check
· Creating Signatures
· Formatting Signature
· Stationery
· Save a Draft

Section D: Distribution Lists
· Creating
· Select Members
· Use List & Edit List

Section E: Attachments
· Insert Text
· Insert Hyperlink
· Attach Files

Section F: Messaging Options
· Importance & Sensitivity
· Voting Buttons
· Delivery Options

Section G: Sending & Receiving
· Inbox
· Preview & Auto Preview
· Using Voting Buttons
· Saving Mail Messages
· Setting Flags
· Forward Message
· Printing Messages
· Message Tracking

Section H: Customizing Mail
· Email Options
· Reply & Forward Options
· Mail Format Options
· Signature Options
· Out of Office Assistant

Section I: Organize
· Sorting Mail
· Follow-up Flags
· Create Folder
· Create Mail Rule
· Delete Items

Section J: Getting Help
· Office Assistant
· Ask a Question
· Using Help Dialog Box~~~4005~4008~~

Outlook Session 2~Section A: Creating Contacts
· Create a Contact
· General Information
· Phone Number & Email Address
· Mailing Address
· Internet
· Comments & Categories
· Create New from Same Company
· Contact Views

Section B: Using Contacts
· Printing Contacts
· Print Style Options
· Print Preview & Page Configuration
· Import Information
· Import from Excel File
· Map Custom Fields
· Exporting Contacts
· Confirm Export
· Contact Address on Internet

Section C: Getting More From Contacts
· Create Contact from Message
· Create New Letter to Contact
· V-Cards
· Receive V-Card

Section D: Scheduling Appointments
· Add Appointment
· Appointment Options
· Local vs. Exchange Mailbox
· Auto Date
· Reminder Window
· Recurring Events
· Setting Recurrence
· Multi-day Appointments

Section E: Working With Appointments
· Move & Cancel
· Change Multi-Day Appointments
· Configure Default Options
· Add Holidays
· Print Calendar
· Publish Calendar

Section F: Scheduling Meetings
· Create a Meeting
· Response to Meeting
· Move Meeting
· Accept
· Tracking
· Delete a Meeting
· Group Schedule
· View Group Schedules

Section G: Creating Tasks
· Working with Lists
· Create New Task
· Task Tracking
· Recurring Tasks
· Assign Tasks
· Accept Assigned Tasks
· Email to Task
· Add Task to Calendar~~~4005~4009~~

Outlook Session 3~Section A: Creating Journal Entries
· Journal Options
· Create Journal Entry
· Apply to Contact
· Configure Contact
· Manage by Contact

Section B: Creating Notes
· Note Usage
· Move Note to Desktop
· Customize Notes
· Forward Notes
· Managing Notes

Section C: Customizing Views
· Define Views
· Create New View
· View Filters
· Delete Custom View

Section D: Mail Merge
· Mail Merge Contacts
· Contacts Options
· Mail Merge Helper
· Insert Merge Fields
· Format Document
· Preview & Complete Merge

Section E: Archiving Data
· Auto Archive Setup
· Default Archive Settings
· Manual Archive
· Individual Folder Auto Archive Settings
· Mailbox Cleanup

Section F: Delegation
· Setup Delegates
· Delegate Permissions
· Add Delegated Folders to View
· Working with Delegated Folders

Section G: Public Folders
· Create New Folder
· Create Public Contact
· Notify Others
· Delete Public Folders

Section H: Working With Forms
· Custom Forms
· Create Custom Forms
· Adding Fields to Forms
· Publish Custom Forms
· Using Custom Forms
· Select Startup Form

Section I: Synchronization
· Setup Offline Folders
· Connection State
· Create Send & Receive Group
· Synchronization Options~~~4005~4010~~

PowerPoint Session 1~Section A: Introduction
· PowerPoint Interface
· Objects in PowerPoint
· Using the Interface
· Image Files
· Output Planning

Section B: Using PowerPoint
· Normal View
· Slide Sorter View
· Notes Page View
· Print Options
· Working with Objects
· Slide Show View

Section C: Customizing the Interface
· Toolbars
· Create New Toolbar
· Add Buttons to Toolbar
· Screen Toolbars

Section D: Templates & Wizards
· Design Templates
· Backgrounds
· PowerPoint 2000 Style Templates
· Change Slide Layout
· Auto Content Wizard

Section E: Presentation Planning
· Master View
· Edit Font
· Create New Presentation
· Picking a Background
· Import Images to PowerPoint
· Resize Images
· Format Text
· Insert New Slide

Section F: Working With Text
· Copy Slide Content
· Tri-pane View
· Edit Text in Normal View
· Font Styles
· Planning Style & Color
· Delete & Create Text Box
· Text Shadow & Alignment

Section G: Text Levels & Saving
· Text Levels
· Enter Text in Outline View
· Format Painter
· Demoting & Promoting
· Saving Files
· Saving Options~~~4005~4021~~

PowerPoint Session 2~Section A: Tools for Text
· Prepare Word File for Import
· Import Preparations
· Import Outline
· Office Clipboard
· Spell Checking

Section B: Working With Graphics
· Types of Graphics
· Insert Clip Art
· Using Clip Organizer
· Automatic Layout
· Set Transparent Color
· Insert Text on Graphic

Section C: Creating Shapes
· AutoShapes
· Fill Effects
· Layers
· Grouping Objects
· Rotate Objects
· Layout Options
· WordArt
· 3-D Styles

Section D: Tables
· Insert Chart
· Insert Table
· Create a Chart
· Chart Toolbar
· Create a Table
· Link to Excel Database
· Update Chart Information

Section E: Bullets & Numbering
· Auto Numbering
· Choosing Bullets
· Adjusting Indents
· Import Graphic Bullets
· Edit Bullets in Master View

Section F: Animation
· Set Animation in Master View
· Animate Subtext
· Preview Animations
· Animate Objects
· Sound Effects
· Chart Animation

Section G: Presentation Skills
· Room Setup
· Slide Usage & Timing
· Slide Navigation
· Options
· Pen Pointer
· Switch Between Presentations~~~4005~4020~~

PowerPoint Session 3~Section A: Slide Transitions
· Understanding Audience
· Pacing & Style
· Transitions
· Transition Options
· Concerns with Sound
· Slide Advance Delay
· Enhance Transitions

Section B: Sending Presentations
· Sound
· Record Presentations
· Test Narration
· Send Presentation
· PowerPoint Show

Section C: PowerPoint & the Web
· Import Images
· Import Text
· Web Page Preview
· Web Consideration
· Publish as Web Page

Section D: Tips & Tricks
· AutoCorrect
· Find & Replace
· Grid & Guides
· Insert Hyperlink
· Using Hyperlinks
· Edit Hyperlinks

Section E: Print Tools
· Page Setup
· Custom Paper Size
· Photo Album
· View in Grayscale
· Print Options

Section F: Powerful Visuals Made Easy
· Insert Video
· Format Video Object
· Video in Presentation
· Best Practice for Video
· Office Assistant
· Close~~~4005~4019~~

Word Session 1~Section A: Introduction
· Open Word
· Open Dialog Box
· Files & Folders
· Open Documents
· Copy & Paste
· Paste Options
· The Office Clipboard
· Review

Section B: Automating Content Creation
· Save As Template
· AutoCorrect
· AutoComplete
· AutoText
· Spelling Checker
· Create AutoText
· Grammar Checker

Section C: Lists
· Bulleted Lists
· Customize Bullets
· Numbered Lists
· Change Order
· Outline Numbered Lists
· Customize Outline Lists
· Sort Lists

Section D: Formatting Techniques
· Keyboard Shortcuts
· GoTo
· Scrollbar
· Paragraph Formatting
· Paragraph Indent
· Font Formatting
· Borders & Shading
· Text Effects
· Format Painter
· Repeat Command

Section E: Styles
· Reveal Formatting
· Create a Style
· Apply Styles
· Manage Styles

Section F: Understanding & Creating Tables
· Introduction to Tables
· Types of Tables
· Create a Table
· Adjust Column Width

Section G: Saving, Sending, & Printing
· Save As
· Save As Web Page
· Print Preview~~~4005~4024~~

Word Session 2~Section A: Using Graphics
· Insert Clip Art
· Format Clip Art
· Image Control Options
· Insert Picture
· WordArt
· Diagrams

Section B: Sections
· Insert Section Break
· Page Orientation
· Remove Section Break
· Title Page

Section C: Columns
· Format Columns
· Remove Columns
· Balance Columns
· Newspaper Columns
· Insert Column Break

Section D: Headers & Footers
· Page Numbers
· Edit Footer
· Date & Time

Section E: Advanced Headers & Footers
· Initial Header & Footer
· Section Page Numbering
· Unlink

Section F: Forms
· Save As Template
· Form Controls
· Form Controls Cont.
· Protect Form

Section G: File Locations
· Documents File Location
· Workgroup Template

Section H: Mail Merge
· Create Envelope
· Envelope Options
· Create Labels
· Mail Merge Wizard
· Create Address List
· Insert Merge Fields
· Preview & Print

Section I: Advanced Mail Merge
· Envelope Merge
· Merge with Excel Data Source
· Merge Using Outlook Contacts~~~4005~4023~~

Word Session 3~Section A: Setting Up Long Documents
· Table of Contents
· Index
· Table of Authorities
· Table of Figures
· Footnotes

Section B: Managing Long Documents
· Comments
· Cross References
· Hyperlinks
· Bookmark Link
· Paste as Hyperlink
· Web Page Link

Section C: Master Documents
· Master & Subdocuments
· Create Subdocuments
· View Master
· Insert Subdocument

Section D: Versions & Tracking Control
· Multiple Versions
· View Versions
· Distribute Document
· Tracking
· Accept & Reject Changes
· Compare & Merge

Section E: Advanced Table Functions
· Table Properties
· Table Layout
· Table Header Row
· Working with Columns
· Split Columns
· Calculating in Word
· Advanced

Section F: Creating Charts
· Using Data from Excel
· Create Graph Chart
· Change Chart Type
· Embed Excel Chart

Section G: Web Page Creation
· Web Page Wizard
· Add Visual Themes
· Web Site Design
· Add Hyperlink
· Insert File
· Save Project

Section H: Create Shortcuts
· Building Macros
· Record Macro
· Use Macro
· Macro Button
· Modify Macros
· Customize Menu
· Digital Signatures~~~4005~4022~~

Ordering~~~~4005~4011~~

Office 2002/XP 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|670538|LIBRARY LICENCE%3A CD Course|670535|~4005~4012~office 2002 xp access word excel powerpoint outlook~