Layout Table~~~~9015~9015~~

Office 2007 19 Sessions - 57 Hours of Interactive Training~
In today’s fast-paced, collaborative business world, proficiency in Microsoft Office is a must. Powerful and packed with new features, Office 2007 imposes a demanding learning curve. The Office 2007 Professional Series from LearnKey allows you to make a smooth transition to the new suite of applications with expert instructors guiding you step-by-step through the basics to more advanced features. This series provides three sessions each of Outlook 2007, PowerPoint 2007, and Word 2007, and five sessions of Access 2007 and Excel 2007.

Benefits
• Efficiently use MS Office 2007 applications.
• Make your daily tasks flow smoothly and quickly.
• Enhance your personal productivity and promotional value. .~~~9015~9016~~

Course Outline Table~~~~9015~9017~~

Access Session 1~Section A: Understanding Access
· What Is Access?
· Access vs. Excel
· Components, Objects, and Terms
· Changes In 2007

Section B: Getting Started
· Application Overview
· Using Templates
· Using the Ribbon
· The Navigation Pane
· Shortcut to Forms
· Finding Help

Section C: Using the Navigation Pane Effectively
· Group View Options
· Item View Options
· Organizing Items
· Navigation Options
· Table Views
· Query and Form Views
· Report and Macro Views

Section D: Data Entry
· Working with Records
· Entering and Editing Records Data
· Deleting Records
· Sorting Data In Records
· Finding Data in Records
· Entering Data In Forms

Section E: Database Design
· Design Steps
· Purpose
· Tables
· Fields
· Relationships
· Primary Key
· Making the Relationship
· Naming Conventions
· Design Cleanup
· Example: Purpose and Tables
· Example: Primary Key and Relationships

Section F: Creating Databases and Tables
· Create Blank Database
· Datasheet View
· Saving Tables
· Table Templates~~~9015~9043~~

Access Session 2~Section A: Working with Tables
· Design View
· Text and Memo Data Types
· Number Data Types
· AutoNumber Data Types
· Yes/No Data Types
· Data Beyond the Database
· Creating Tables
· Setting Primary Keys

Section B: Field Properties
· Field Properties Overview
· Modifying Fields
· Text Field Properties
· Number Field Properties
· Validation Rules
· Arranging and Deleting Fields
· Viewing Changes
· Validation Text
· More Field Properties
· Memo Fields
· Attachment Fields
· Input Masks

Section C: Lookup Fields
· Creating Lookups
· Design View Lookups
· Lookup Properties

Section D: Relationship Theory
· Relationship Basics
· Beyond Relationship Basics
· Relationship Types
· Putting Relationship Theory Together

Section E: Creating Relationships
· Viewing Relationships
· Building and Modifying Relationships
· Relationship Reports
· Joining Table Properties

Section F: Analyzing Design
· Cleaning Up
· Formatting Datasheets
· Hiding Columns
· Rearranging Fields
· Performance Analyzer

Section G: Subdatasheets and Filters
· Adding Subdatasheets
· Subdatasheet Display
· Removing Subdatasheets
· Filtering by Selection
· Number Filtering
· Filtering by Form
· Advanced Filters
· Total Row Summaries~~~9015~9042~~

Access Session 3~Section A: Query Basics
· Query Wizard
· Selecting Data Sources
· Selecting Fields
· Sorting Fields
· Arranging Fields
· Criteria
· Comparison Criteria
· Range Criteria

Section B: Intermediate Queries
· Field Properties
· Query Properties
· Unique List
· Outputting All Fields
· Removing Tables
· Multiple Table Queries
· Query Relationships

Section C: Calculation in Queries
· Adding Fields
· Calculation Fields
· Null Values
· Totals
· Expression Builder

Section D: Special Queries
· Crosstab Queries
· Modifying Crosstab Queries
· Finding Duplicate Records
· Finding Unmatched Records
· Parameter Queries
· Range Parameters
· SQL View

Section E: Action Queries
· Updating Queries
· Creating Table Copies
· Creating Table Queries
· Saving Action Queries
· Archiving Records
· Deleting Queries
· Deleting Tables

Section F: Concatenation
· What is Concatenation?
· Concatenating Data
· Reviewing Concatenation
· Concatenation Examples~~~9015~9041~~

Access Session 4~Section A: Importing/Exporting Data
· Importing Data
· Importing Objects
· Importing from Excel
· Making Changes
· Exporting Data
· Add-Ins
· Save as PDF or XPS

Section B: Using Mail Merge
· Introduction
· Mail Merge Wizard
· Creating a Merge Letter
· Sharing Outlook Contacts
· Importing Outlook Folders
· Collaboration

Section C: Basic Forms
· Lookup Tables
· Form Wizard
· Form Tools
· Layout View

Section D: Form Controls
· Design View
· Controls
· Move Controls
· Selecting Multiple Controls
· Arranging Controls

Section E: Form Design
· Font Formatting
· Conditional Formatting
· Control Types
· Query by Form
· Check Boxes
· Bind Controls
· Properties

Section F: Special Forms
· Split Forms
· Subforms
· Subform Relationships
· Creating Subforms
· PivotTable Forms
· Calculations
· Filtering PivotTables

Section G: Reports
· AutoReports
· Report Wizard
· Grouping and Sorting
· Adding Pictures
· Page Breaks
· Label Wizard
· Charts~~~9015~9040~~

Access Session 5~Section A: Controlling Display and Data Entry
· Form Properties
· Display Options
· Data Entry Options
· Lock Controls
· Bang and Dot Operator
· Query Aliases
· Query Parameters
· Dynamic Reports

Section B: Access Automation
· Remove Grouping
· Control Wizard
· Switchboard Manager
· Edit Switchboard Pages
· Edit Main Switchboard
· Customize Switchboards

Section C: Custom Automation
· Overview
· Unbound Forms
· Add Record
· Message Box
· Close Form
· Close Database
· Modal Dialog Form

Section D: Working with the File
· Custom Navigation Pane
· Arranging Objects
· Database Properties
· Access Options
· Current Database Options
· Compact and Repair
· Back Up Database
· Database Splitter
· Linked Table Manager

Section E: Security
· Security Types
· Password Protection
· User-Level Permissions
· Creating User-Level Permissions
· Security Tips

Section F: Sharing Information
· Printing Tables
· Printing Forms
· Printing Reports
· Output as File
· Database Documenter
· Save as Previous Version~~~9015~9039~~

Excel Session 1~Section A: Introduction
· What You Will Learn
· Excel 2007 Interface
· Ribbon and Tabs
· Document Windows
· Navigation Tips

Section B: Creating and Manipulating Data
· Entering Data
· AutoFill a Series
· Fill Non-Adjacent Cells
· AutoFill on Multiple Sheets
· Creating Custom Lists
· Series Formatting

Section C: Managing Worksheets
· Copying Worksheets
· Inserting and Deleting Worksheets
· Hiding Worksheets

Section D: Data Integrity
· Validation Criteria
· Character Validation
· Drop-Down Lists

Section E: Modifying Cell Content
· Cut, Copy, Paste
· Transposing Data
· Copy Cell Format Only
· Removing Duplicates
· Data Validation

Section F: Changing Views
· Zoom Features
· Workbook Views
· Page Layout View
· Repeating Cell Content
· Freeze Panes
· Split Windows
· Viewing Multiple Windows
· Saving Hot Links
· Hiding the Ribbon~~~9015~9048~~

Excel Session 2~Section A: Formatting Data
· Formatting Worksheets
· Worksheet Backgrounds
· Watermarks

Section B: Modifying Rows and Columns
· Inserting Rows
· Inserting Columns
· Cutting and Inserting Columns
· Modifying Cell Width/Height
· Inserting Multiple Rows and Columns
· Inserting and Deleting Cells
· Formatting Rows and Columns
· Hiding/Unhiding Rows and Columns

Section C: Formatting Numbers
· Currency Format
· Format Painter
· Formatting Dates
· Special Formats
· Cell Styles

Section D: Formatting Text and Tables
· Fonts, Fills, and Alignment
· Comments
· Merging and Splitting Cells
· Inserting Hyperlinks
· Formatting as a Table
· Summary Function

Section E: Understanding Formulas
· Using Operations
· Creating Formulas
· AutoSum
· Common Functions
· Searching for Functions
· Copying Formulas
· Absolute Cell References~~~9015~9047~~

Excel Session 3~Section A: Referencing Formulas
· Dependent References
· Multiple Sheet References
· Consolidating Data
· Consolidating with Links

Section B: Ranges and Dates
· AutoSum
· Cell Names
· Formulas with Cell Names
· COUNT
· COUNTA
· Date Formulas

Section C: Subtotals
· Overview
· Subtotal Options
· Selecting Visible Data

Section D: Lookups
· Lookups Purpose
· VLOOKUP
· VLOOKUP Exact Match
· HLOOKUP
· HLOOKUP Exact Match

Section E: Conditional Logic
· IF Syntax
· IF Statement
· Nested IF
· Nested IF Syntax

Section F: More Conditional Logic
· AND
· OR
· NOT
· IFERROR
· SUMIF
· AVERAGEIF
· COUNTIF
· SUMIFS
· AVERAGEIFS
· COUNTIFS~~~9015~9046~~

Excel Session 4~Section A: Financial Formulas
· Future Value
· Payment
· Goal Seek
· Changing Rate
· Scenario Manager

Section B: Text Formulas
· Case Formulas
· Paste Column Widths
· Operations in Paste Special
· Skip Blanks
· AutoCalculate
· Fix Number Fields
· Trim Spaces
· Substitute Text

Section C: Introduction to Charts
· Chart Types
· Instant Chart
· Update Chart
· Column Chart
· Picture Fill
· Adjust Chart Size
· Line Chart
· Scatter Chart

Section D: Formatting Charts
· Chart Styles
· Chart Layouts
· Add Labels
· Axis Options
· Chart Title
· Legends
· Data Labels

Section E: Conditional Formatting
· Highlight Cells Rules
· Top/Bottom Rules
· Data Bars
· Color Scales
· Custom Formatting Rule
· Text Formatting

Section F: Adding Graphics to Spreadsheets
· Insert Pictures
· Modifying Pictures
· Insert Shapes
· Insert SmartArt
· Apply Themes~~~9015~9045~~

Excel Session 5~Section A: Outlining, Sorting, and Filtering
· Group and Ungroup
· Sort Data
· Sort Multiple Levels
· Filter Data
· Advanced Filter
· Conditional Sorting and Filtering
· Sorting and Filtering Data Attributes

Section B: PivotTables
· Overview
· Creating PivotTables
· Choosing Fields
· Sub Fields
· PivotTable Layout
· Filtering PivotTables
· Totals
· Modifying PivotTable Data
· PivotCharts

Section C: Protecting Data
· Workbook Passwords
· Protecting Workbooks
· Hiding Worksheets
· Unlocking Cells

Section D: Collaboration
· Document Properties
· Formatting Comments
· Document Inspector
· Sharing a Workbook
· Track Changes
· Accept/Reject Changes
· Information Rights Management
· Using IRM
· Signature Line
· Mark as Final

Section E: Saving a Workbook
· Save As Previous Version
· Templates
· Save As PDF
· Save As Web Page
· Macro-Enabled Workbook

Section F: Printing
· Page Orientation
· Page Breaks
· Print Area
· Margins
· Headers and Footers
· Scaling~~~9015~9044~~

Outlook Session 1~Section A: Learning to be Efficient
· What is Outlook Really?
· New Features
· Outlook Editions
· Edition-Specific Features
· Edition Version Summary

Section B: Outlook Interface
· Getting Started
· Navigation Pane
· Information and Reading Panes
· To-Do Bar

Section C: Outlook Today
· The Ideal Assistant
· Customizing Outlook Today

Section D: Configuring E-mail Accounts
· How E-mail Works
· Account Settings
· Manual Configuration
· Changing E-mail Accounts

Section E: Creating E-mail
· Creating Messages
· Addressing the Message
· E-mail Options

Section F: E-mail Extras
· Formatting
· Voting Buttons
· Attachments
· Importance and Sensitivity
· Spell Check
· Saving a Draft

Section G: Hyperlinks and Quick Parts
· Using Hyperlinks
· Using Quick Parts
· Bookmark Hyperlinks

Section H: Setting E-mail Defaults
· E-mail Settings
· Mail Format
· Themes and Fonts
· Setting up E-mail Signatures
· Creating Multiple Signatures

Section I: Securing E-mail
· Digital Signatures
· Encrypting Messages
· IRM
· Configuring IRM
· The Trust Center~~~9015~9051~~

Outlook Session 2~Section A: Receiving E-mail
· Replying to Messages
· Forwarding Messages
· Voting
· Receiving Attachments
· Sent Items
· Recall and Resent Messages
· Vote Tally

Section B: Working Offline
· Send/Receive Settings
· Send/Receive Groups
· Out of Office Assistant
· Downloading the Address Book

Section C: Changing Views
· Sorting
· Customizing Views
· Fields
· Views Dialog Box

Section D: Organizing Information
· Organizing with Categories
· Quick Click
· Organizing with Flags
· Custom Flags

Section E: Managing Junk Mail
· Junk Mail Tactics
· Junk Mail Folder
· Junk Mail Settings

Section F: Customizing Folders
· Folder Settings
· Deleting Items
· Creating Folders
· Organizing Folders
· Recover Deleted Items
· Saving in Different File Types

Section G: Managing Data Files
· Creating a Personal Folder Set
· Personal Folder Properties

Section H: Rules and Alerts
· Automated Features
· Rules
· Alerts
· Ordering Rules~~~9015~9050~~

Outlook Session 3~Section A: Archiving
· Activating Archiving
· AutoArchive Settings
· Manual Archiving

Section B: Searching
· Search Options
· Simple Searches
· Query Searches
· Using Search Folders
· Category Searches
· Custom Search Folders

Section C: Contact Basics
· Creating Contacts
· Modifying Contacts
· Adding Contacts
· Contact Views

Section D: Advanced Contacts
· Modifying Contacts
· Business Card Options
· Distribution Lists
· Secondary Address Books

Section E: Calendars and Scheduling
· Calendar Views and Entries
· Creating Appointments
· Creating Events
· Recurring Events
· Creating Events from E-mail

Section F: Calendar Defaults and Permissions
· Calendar Settings
· Assigning Delegate Permissions
· Viewing People's Calendars

Section G: Collaboration
· Group Calendars
· Send a Calendar via E-mail
· Publish Calendars Online

Section H: Meetings
· Scheduling Meetings
· Responding to Requests
· Tracking Responses
· Recurring Meetings
· Proposing New Meeting Times

Section I: Tasks and Journal
· Creating Tasks
· Assigning Tasks
· Recurring Tasks
· Responding to Assigned Tasks
· Task Views
· Tracking with the Journal~~~9015~9049~~

PowerPoint Session 1~Section A: Introduction to PowerPoint
· How to Create Effective Presentations

Section B: Effective Presentations
· Overview
· Take AIM
· Audience
· Intent
· Message
· Presentation Structure
· Visuals
· Nonverbal Communication
· Presentation Tips

Section C: Creating Presentations
· Opening PowerPoint
· New Presentations
· Opening Templates
· Interface Layout
· Changing Views
· Navigation
· Saving a Presentation
· File Extensions
· PowerPoint Process

Section D: Creating Initial Content
· Placeholders
· Working with Text
· Adding Slides
· Changing Slide Layouts
· Arranging Slides
· Copying and Pasting

Section E: Themes
· Live Preview
· Theme Colors
· Customizing Colors
· Theme Fonts
· Theme Effects
· Saving Themes
· Setting Default Themes

Section F: Customizing Slide Masters
· Using Masters
· Slide Master View
· New Slide Master
· New Layout
· Headers and Footers
· Renaming Layouts
· Using New Layout
· Preparing Templates
· Saving Templates

Section G: Working with Text
· Mini Toolbar
· Paragraph Formatting
· Font Formatting
· Editing Master
· Synonyms
· Format Text Box
· Turning Off Mini Toolbar

Section H: Working with Lists
· Creating Bulleted Lists
· Modifying Bulleted Lists
· Customizing Bullets
· Setting Tabs
· Using the Ruler
· Applying Indents~~~9015~9054~~

PowerPoint Session 2~Section A: Using Existing Content
· Headings
· Creating New Slides
· Outline View
· Bullets
· Arranging Slides
· Adding Slides
· Saving as an RTF
· Creating Word Handouts
· Reusing Slides
· Slide Libraries

Section B: Charts
· Excel 2007
· Inserting Charts
· Excel Charts
· Paste Special
· Changing Chart Types
· Selecting Data Sources
· Layout Options
· Chart Formatting
· Chart Templates

Section C: Tables
· Inserting Tables
· Design Options
· Merging Cells
· Entering Text
· Changing Table Settings
· Copy and Paste

Section D: Shape Properties
· Starting with Shapes
· Fill Options
· Texture Fill
· Inserting Pictures
· Shadows
· 3-D Effects
· Modifying Text

Section E: Drawing Tools
· Inserting Shapes
· Arranging Shapes
· Distributing Shapes
· Selection Pane

Section F: SmartArt Diagrams
· Converting Bulleted Lists
· Working with the Text Pane
· SmartArt Tools
· Creating SmartArt
· Adding Shapes

Section G: Pictures and Photo Albums
· Creating Photo Albums
· Album Layout
· Captions
· Inserting Pictures
· Compressing Pictures

Section H: Backgrounds and Watermarks
· Background Styles
· Hiding Background Graphics
· Inserting Watermarks~~~9015~9053~~

PowerPoint Session 3~Section A: Multimedia
· Supported File Types
· Inserting Sound Clips
· Sound Tools
· Modifying Sound Files
· Sound Insert Options
· Narration
· Inserting Movies
· Movie Tools

Section B: Animations
· Creating Animations
· Customizing Animations
· Previewing Animation
· Animating Text
· Animation Settings
· Animating SmartArt
· Animating Charts
· Motion Paths

Section C: Customizing Slide Shows
· Transitions
· Individual Transitions
· Hiding Slides
· Custom Show

Section D: Save for Web Viewing
· Hyperlinks
· Action Buttons
· Saving as a Web Page
· Viewing as a Web Page

Section E: Delivery Formats
· Page Setup
· Saving as a Picture
· PowerPoint Show
· PDF/XPS
· Package for CD
· CD Options

Section F: Proofing and Reviewing
· Visual Check
· Spell Check
· AutoCorrect
· Research
· Comments

Section G: Prepare and Protect
· Document Properties
· Document Inspector
· Encryptions and Passwords
· Information Rights Management
· Digital Signature
· Mark as Final
· Compatibility Checker

Section H: Prepare for the Presentation
· Printing Tips
· Optimization Tips
· Running a Show
· Speaker's Notes
· Setting Up the Show
· Rehearsing Timings
· Using Presenters View
· Print Options
· Print Preview~~~9015~9052~~

Word Session 1~Section A: Getting Familiar
· What's New
· Interface Tour
· Getting Help

Section B: Document Navigation Tips
· Navigating Within Documents
· Navigating With the Keyboard
· Browsing By Object
· Selecting Text

Section C: Manipulating Text
· Setting Up a Document
· Cut, Copy, Paste, Move
· Using the Clipboard
· Find and Replace

Section D: Themes and Templates
· Using Themes
· Inserting Pages

Section E: Quick Parts
· Overview
· Modifying Building Blocks
· Inserting Fields
· Inserting Symbols
· Inserting Logos

Section F: Preparing Documents for Printing
· Inline Spelling Errors
· Proofing Indicator
· Spelling and Grammar Dialog
· Proofing Options
· Saving Documents
· Naming Files
· Print Preview
· Print Options
· More Print Options~~~9015~9059~~

Word Session 2~Section A: Formatting Characters
· Changing Fonts
· Formatting Text
· Formatting Tools

Section B: Formatting Paragraphs
· Spacing
· Indentation
· Using Styles
· Customizing Styles

Section C: Organizing Content
· Creating Lists
· Creating Tables
· Formatting Tables
· Table Styles
· Converting Text to Tables
· Modifying Tables

Section D: Tabs, Columns, and Charts
· Setting Tabs
· Charts
· Columns
· Previewing Documents

Section E: Links, Headers, and Footers
· Hyperlinks
· E-mail Links
· Headers
· Footers

Section F: References
· Bookmarks
· Captions
· Footnotes
· Citations
· Reference Styles
· Research Pane
· Index Entries
· Creating Indexes
· Bibliographies
· Table of Figures
· Table of Contents~~~9015~9058~~

Word Session 3~Section A: Mail Merge
· Inserting Symbols
· Mail Merge Wizard
· Choosing Recipients
· Instant Merge Fields
· Inserting Dates
· Previewing Letters
· Envelopes
· Labels

Section B: Visual Content
· Character Spacing
· Inserting Shapes
· Inserting Pictures
· Picture Options
· WordArt
· Pull Quotes
· Text Boxes
· Sorting Text
· SmartArt Graphics

Section C: Reviewing Documents
· Document Window Views
· Split Screen View
· Tracking Changes
· E-mail Collaboration
· Tracking Options
· Combining Documents
· Accepting Changes
· Comments
· Reading View

Section D: Protecting and Sharing Documents
· Previous Word Versions
· Compatibility Checker
· Document Inspector
· Digital Signatures
· Restricting Permissions
· Document Properties
· Word Options
· Finalizing Documents
· Personalizing Office~~~9015~9057~~

Word Session 4~Section A: Importing/Exporting Data
· Importing Data
· Importing Objects
· Importing from Excel
· Making Changes
· Exporting Data
· Add-Ins
· Save as PDF or XPS

Section B: Using Mail Merge
· Introduction
· Mail Merge Wizard
· Creating a Merge Letter
· Sharing Outlook Contacts
· Importing Outlook Folders
· Collaboration

Section C: Basic Forms
· Lookup Tables
· Form Wizard
· Form Tools
· Layout View

Section D: Form Controls
· Design View
· Controls
· Move Controls
· Selecting Multiple Controls
· Arranging Controls

Section E: Form Design
· Font Formatting
· Conditional Formatting
· Control Types
· Query by Form
· Check Boxes
· Bind Controls
· Properties

Section F: Special Forms
· Split Forms
· Subforms
· Subform Relationships
· Creating Subforms
· PivotTable Forms
· Calculations
· Filtering PivotTables

Section G: Reports
· AutoReports
· Report Wizard
· Grouping and Sorting
· Adding Pictures
· Page Breaks
· Label Wizard
· Charts~~~9015~9056~~

Word Session 5~Section A: Controlling Display and Data Entry
· Form Properties
· Display Options
· Data Entry Options
· Lock Controls
· Bang and Dot Operator
· Query Aliases
· Query Parameters
· Dynamic Reports

Section B: Access Automation
· Remove Grouping
· Control Wizard
· Switchboard Manager
· Edit Switchboard Pages
· Edit Main Switchboard
· Customize Switchboards

Section C: Custom Automation
· Overview
· Unbound Forms
· Add Record
· Message Box
· Close Form
· Close Database
· Modal Dialog Form

Section D: Working with the File
· Custom Navigation Pane
· Arranging Objects
· Database Properties
· Access Options
· Current Database Options
· Compact and Repair
· Back Up Database
· Database Splitter
· Linked Table Manager

Section E: Security
· Security Types
· Password Protection
· User-Level Permissions
· Creating User-Level Permissions
· Security Tips

Section F: Sharing Information
· Printing Tables
· Printing Forms
· Printing Reports
· Output as File
· Database Documenter
· Save as Previous Version~~~9015~9055~~

Ordering~~~~9015~9037~~

Office 2007 Series 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 19 sessions|200538|LIBRARY LICENCE%3A CD Course 19 sessions|200535|~9015~9038~office 2003 access word excel powerpoint outlook~