Course description
This Microsoft Office course teaches you how to effectively use the Office 2007 Suite through comprehensive lessons and engaging quizzes, allowing the user to choose which lesson to learn. New users will be guided through the fundamentals of the new office interface, while experienced users will be brought up to speed on the new navigation and functionality of this 2007 edition. These courses will train you how to best meet your needs through the use of Word, Outlook, Excel, Powerpoint, and Access.
With this course comes multiple-choice quizzes for each section covered allow the user to track their progress as they learn, a complete overview of the instructor, product, and what to expect from the training and a course Map allowing which topic the user wants to learn is easy with the convenient course map.
Your Personal Instructor: Deanna Reynolds
Deanna Reynolds has worked as a technical trainer for more than ten years teaching in both the corporate and technical college environments. Throughout her teaching career, Deanna has been privileged to work with students traveling many different career paths on a multitude of software programs including the entire Microsoft Office Suite, Web Design, Desktop Publishing, and Database Development. Deanna specializes in delivering instructor-led training and writing custom courseware that helps her students quickly become "power-users."
Microsoft Access 2007: Beginner
Introduction
1.0 Getting Started
1.1 About Relational Databases and Access 2007
1.2 Launching Access 2007
1.3 Touring the Access Environment
1.4 Using the Office Menu
1.5 Database Components
1.6 Using the Navigation Pane
1.7 Getting Help
1.8 Opening and Closing Access Databases
1.9 Creating an Access Database Using a Preloaded Template
2.0 Working with an Existing Table
2.1 Exploring Datasheet View
2.2 Editing and Selecting Table Data
2.3 Adding and Deleting Records
2.4 Find and Replace
2.5 Undo and Redo
3.0 Working with an Existing Form
3.1 Exploring Form View
3.2 Editing and Selecting Form Data
3.3 Adding and Deleting Records
3.4 Find and Replace
4.0 Sorting and Filtering
4.1 Sorting a Table and a Form
4.2 About Filters
4.3 Common Filters
4.4 Filter by Selection
4.5 Filter by Form
4.6 Advanced Filter
5.0 Designing Select Queries
5.1 Using the Query Wizard
5.2 Using Query Design View
5.3 Using Criteria
5.4 Sorting and Showing Query Fields
5.5 Adding Tables to a Query
6.0 Form Basics
6.1 Using the Forms Wizard
6.2 Using the Form Tool
6.3 Working with Form Design View
6.4 Working with Form Layout View
6.5 Working with Form Controls
7.0 Report Basics
7.1 Using the Reports Wizard
7.2 Using the Report Tool
7.3 Working with Report Design View
7.4 Working with Report Layout View
7.5 Working with Report Controls
8.0 Printing Database Objects
8.1 Printing Tables or Queries
8.2 Printing Forms
8.3 Printing Reports
Microsoft Access 2007: Intermediate
Introduction
1.0 Planning & Designing a Database
1.1 Evaluating Inputs & Outputs
1.2 Data Normalization
1.3 Creating a Database Using a Wizard
1.4 Creating a Database from Scratch
2.0 Building & Modifying Tables
2.1 Using the Table Wizard
2.2 Creating a Table in Datasheet View
2.3 Creating a Table from Scratch
2.4 Using Field Templates
2.5 About Data Types
2.6 Using the Automatic Calendar
2.7 Setting Primary Keys
3.0 Working with Relationships
3.1 Introduction to Relationships
3.2 Types of Relationships
3.3 Referential Integrity
3.4 Cascading Updates and Deletes
3.5 Multi-Valued Fields
3.6 Printing Relationships
4.0 Sharing Your Data
4.1 Export Your Access Report to Word
4.2 Export Your Access Table to Excel
4.3 Import Your Excel Spreadsheet in to Access
4.4 Using the Report Snapshot Viewer
4.5 Copying the Table Structure and Data
5.0 Enhancing Your Forms
5.1 Using the Field List Task Pane
5.2 Using the Toolbox
5.3 Adding &Formatting Labels
5.4 Adding Graphics
5.5 Adding Command Buttons
6.0 Enhancing Your Reports
6.1 Using the Toolbox
6.2 Adding Graphic Details
6.3 Adding Bound Controls
6.4 Working with White Space and Report Width
Microsoft Access 2007: Advanced
Introduction
1.0 Preventing Data Entry Errors
1.1 Using the Lookup Wizard
1.2 Data Validation
1.3 Working with Combo Boxes
1.4 Working with List Boxes
2.0 Advanced Table Design
2.1 Field Properties
2.2 Using Input Masks
2.3 Using the Datasheet Total Row
2.4 Formatting Text
2.5 Using Rich Text in the Memo Field
3.0 Advanced Query Design
3.1 Creating a Calculated Field
3.2 Creating a Crosstab Query
3.3 Find Unmatched Query Wizard
3.4 Find Duplicates Query Wizard
4.0 Advanced Form Design
4.1 Split Forms
4.2 Changing Control Properties
4.3 Changing Control Tab Order
4.4 Form Properties
4.5 Conditional Formatting
4.6 Adding Tab Pages
4.7 Creating a Subform
5.0 Advanced Report Design
5.1 Creating Groups & Total Reports
5.2 Working with Report Properties
5.3 Creating a Subreport
5.4 Adding a Calculated Control
6.0 Managing Databases
6.1 Identify Object Dependencies
6.2 Database Documenter
6.3 Backing Up a Database
6.4 Compacting & Repairing a Database
Microsoft Access 2007: Expert
Introduction
1.0 Expertly Designed Select Queries
1.1 Single Parameter Queries
1.2 Multiple Parameter Queries
1.3 Query Joins
2.0 Action Queries
2.1 Types of Action Queries
2.2 Update Queries
2.3 Append Queries
2.4 Make Take Queries
2.5 Delete Queries
3.0 Expertly Designed Forms
3.1 Creating Multi-Table Forms
3.2 Using a Bitmap as a Form Background
3.3 Adding Calculated Controls to a Form
4.0 Expertly Designed Reports
4.1 Setting Section Properties
4.2 Adding Graphics
4.3 Arranging Report Data Into Columns
5.0 Data Access Pages
5.1 Creating a Data Access Page
5.2 Editing a Data Access Page
5.3 Grouping a Data Access Page
5.4 Creating a PivotTable Data Access Page
6.0 Macros
6.1 Create a Macro
6.2 Edit a Macro
6.3 Attach a Macro to a Command Button
7.0 Database Security
7.1 About Database Security
7.2 Using a Database Password
7.3 Creating Users & Groups
Microsoft Outlook 2007:Intermediate
Introduction
1.0 Using the Calendar
1.1 Creating an Appointment
1.2 Using the Appointment Ribbon
1.3 Creating a Recurring Appointment
1.4 Editing an Appointment
1.5 Setting Appointment Reminder Options
1.6 Working with Calendar View Options
1.7 Printing Your Calendar
2.0 Planning Meetings & Appointments
2.1 Creating & Sending a Meeting Request
2.2 Using the Meeting Ribbon
2.3 Responding to a Meeting Request
2.4 Updating a Meeting Request
2.5 Searching for Appointments
3.0 Advanced Contact Options
3.1 Viewing Contacts
3.2 Editing Contacts
3.3 Searching for Contacts
3.4 Sorting Contacts
3.5 Forwarding Contacts
3.6 Printing Contacts
4.0 Using Tasks
4.1 Creating a Task
4.2 Using the Task Ribbon
4.3 Editing, Sorting & Viewing Tasks
4.4 Creating a Recurring Task
4.5 Creating a Task Request
4.6 Responding to a Task Request
4.7 Marking a Task as Complete
4.8 Setting Task Default Options
5.0 Using Notes
5.1 Creating Notes
5.2 Using the Notes Ribbon
5.3 Editing, Sorting & Viewing Notes
5.4 Formatting Notes
6.0 Advanced Mail Message Options
6.1 Using Spell Check
6.2 Using the Thesaurus & Research Task Pane
6.3 Creating & Editing Signatures
6.4 Using Stationery
6.5 Creating Custom Stationery
6.6 Recalling a Message
Microsoft Outlook 2007: Advanced
Introduction
1.0 Filtering, Finding & Flagging Messages
1.1 Filtering Messages
1.2 Finding Messages
1.3 Flagging Messages
1.4 Flagging a Message from a Particular Sender
1.5 Completing & Clearing a Flag
2.0 Archiving Outlook Data
2.1 About Archiving Data
2.2 Running the Manual Archive
2.3 Retrieving Archived Items
2.4 Enabling & Disabling AutoArchive
2.5 Setting Archive Properties for Items
3.0 Personal File Folders
3.1 About Personal File Folders
3.2 Creating a Personal File Folder
3.3 Moving & Copying Messages
4.0 Using the Journal
4.1 About Journal Entries
4.2 Creating a Journal Entry
4.3 Using the Journal Entry Ribbon
4.4 Creating Automatic Journal Entries
4.5 Editing a Journal Entry
4.6 Journal Entry Views
5.0 Organizing Your Outlook Items
5.1 Using Search Folders
5.2 Creating Rules
5.3 Editing & Deleting Rules
5.4 Using Conditional Formatting
5.5 Grouping Items
5.5 Grouping Items
6.0 Custom Forms
6.1 About Outlook Forms
6.2 Creating a Custom Form
6.3 Testing a Custom Form
6.4 Sharing a Custom Form
7.0 Customizing Outlook
7.1 Working with Outlook Options
7.2 Setting Outlook Default Properties
7.3 Customizing Toolbars
7.4 Creating a New Toolbar Button
Microsoft PowerPoint 2007: Beginner
Introduction
1.0 Getting Started
1.1 Launching PowerPoint 2007
1.2 Touring the PowerPoint Window
1.3 Using the Office Menu
1.4 Using the Quick Access Toolbar
1.5 Save vs. Save As
1.6 File & Folder Management
1.7 Opening & Closing Files
1.8 Navigating Through a Presentation
1.9 Presentation Views
2.0 Creating a New Presentation
2.1 Creating a New Presentation from a Template
2.2 Creating a New Presentation from Scratch
2.3 Using the Home Ribbon
2.4 Adding & Editing Text
2.5 Undo & Redo
2.6 Inserting a New Slide
2.7 Working with Slide Layouts
2.8 Choosing a Design Template
3.0 Modifying an Existing Presentation
3.1 Working with Text Boxes
3.2 Moving & Copying Text & Text Boxes
3.3 Formatting Text
3.4 Using Bullets & Numbering
3.5 AutoCorrect & AutoFormat
3.6 Working withIndents & Line Spacing
4.0 Getting Help
4.1 Getting Help Locally on Your Computer
4.2 Getting Help from Microsoft Online
5.0 Preparing a Presentation for Delivery
5.1 Using Spell Check
5.2 Using the Thesaurus & Research Panes
5.3 Using the View Ribbon
5.4 Working with Speaker Notes
5.5 Adding a Header & Footer
5.6 Using the Slide Show Ribbon
5.7 Viewing a Presentation in Slide Show View
6.0 Printing Presentations
6.1 About the Print Dialog Box
6.2 Printing a Presentation
6.3 Printing Speaker Notes
6.4 Printing Handouts
Microsoft PowerPoint 2007:Intermediate
Introduction
1.0 Outlines
1.1 Entering Slide Text in Outline View
1.2 Editing Slide Text in Outline View
1.3 Formatting Slide Text in Outline View
1.4 Inserting Slide Text from Microsoft Word
1.5 Exporting a PowerPoint Outine
2.0 Working with Pictures and Shapes
2.1 Using the Insert Ribbon
2.2 Inserting ClipArt & Pictures
2.3 Drawing AutoShapes
2.4 Using the Pictures Tools Tab
2.5 Resizing Objects
2.6 Grouping & Ungrouping Objects
2.7 Layering Objects
2.8 Formatting Objects
3.0 Viewing & Changing Presentation Colors
3.1 Using the Design Ribbon
3.2 Applying Themes
3.3 Creating Custom Themes
4.0 Adding Animation
4.1 Using the Animation Ribbon
4.2 Adding Entrance & Exit Animation
4.3 Adding Emphasis
4.4 Using Motion Paths
4.5 Assigning the Order of Animation Effects
5.0 Organizing & Enhancing Your Presentation
5.1 Duplicating & Deleting Slides
5.2 Hiding Slides
5.3 Rearranging Slides
5.4 Adding Slide Transitions
6.0 Managing Presentations
6.1 Inserting Slides from Other Presentations
6.2 Using Find & Replace
7.0 Customizing Excel
7.1 Customizing the Quick Access Toolbar
7.2 Modifying PowerPoint Options
Microsoft PowerPoint 2007: Advanced
Introduction
1.0 Working with Tables
1.1 Adding a Table to a Slide
1.2 Navigating in a Table
1.3 Inserting & Deleting Columns & Rows
1.4 Formatting a Table
1.5 Insert a Table from Word or Excel
2.0 Working with Charts
2.1 Creating a Chart
2.2 Using the Chart Tab
2.3 Adding & Removing Chart Data
2.4 Format & Resize Charts
3.0 WordArt & SmartArt
3.1 Insert a WordArt Object
3.2 Editing a WordArt Object
3.3 About SmartArt
3.4 Creating a List
3.5 Creating a Hierarchy
3.6 Creating a Pyramid
3.7 Creating an Organization Chart
3.8 Editing SmartArt
4.0 Working with Templates
4.1 Creating a Custom Template
4.2 Working with Custom Layouts
4.3 Saving a Custom Template
4.4 Using a Custom Template
5.0 Saving Presentations for the Web
5.1 Adding a Hyperlink to a Slide
5.2 Working with a Group Home Page
5.3 Publishing a Presentation to the Web
5.4 Saving a Presentation as PDF
6.0 Collaboration
6.1 Using the Review Ribbon
6.2 Tracking Changes
6.3 Insert, View & Edit Comments
6.4 Accepting & Rejecting Changes
6.5 Comparing & Merging Presentations
6.6 Setting Password Protection
6.7 Marking a Presentation as Final
7.0 Advanced Presentation Delivery Option
7.1 Working with Action Buttons
7.2 Creating a Custom Slide Show
7.3 Annotating a Presentation
7.4 Using Slide Timings & Narration
7.5 Slide Show Options
Microsoft Word 2007: Beginner
Introduction
1.0 Getting Started
1.1 Launching Word 2007
1.2 Touring the Word Window
1.3 Using the Office Menu
1.4 Using the Quick Access Toolbar
1.5 Getting Help
2.0 Creating New Documents
2.1 Starting a New Document
2.2 Editing Text
2.3 Saving Your Work
2.4 Preview & Print a Document
2.5 Using a Template
2.6 Exiting Word
3.0 Editing Existing Documents
3.1 Opening a Document
3.2 Navigating a Document
3.3 Working with Multiple Page Documents
4.0 Essential Word 2007 Skills
4.1 Selecting Text
4.2 Moving & Copying Text
4.3 Clipboard Task Pane
4.4 Undo, Redo & Repeat
4.5 AutoCorrect
5.0 Formatting Text & Paragraphs
5.1 Using the Home Tab
5.2 Using the Quick Format Mini Toolbar
5.3 Working with Text Formatting
5.4 Working with Line & Paragraph Spacing
5.5 Using FormatPainter
5.6 Adding Symbols & Special Characters
6.0 Proofing Tools
6.1 Spelling & Grammar
6.2 Using the Thesaurus & Other Research Options
6.3 Checking Character & Word Count
6.4 Working with the Custom Dictionary
6.5 Editing in Print Preview
7.0 Changing Your Page Appearance
7.1 Using the Page Layout Tab
7.2 Changing Margins & Page Orientation
7.3 Working with Page Breaks
7.4 Adding Line Numbers
Microsoft Word 2007: Intermediate
Introduction
1.0 Managing Documents
1.1 Document Views
1.2 Using the View Tab
1.3 Working with Multiple Documents
1.4 Saving Your Word Document as a Web Page
2.0 Additional Editing Tools
2.1 Go To, Find & Replace
2.2 Format Painter
2.3 AutoCorrect
3.0 Paragraph Formatting
3.1 Bullets & Numbering
3.2 Tabs & Indents
3.3 Borders & Shading
3.4 Using Styles
4.0 Introduction to Graphics
4.1 Inserting ClipArt & Pictures
4.2 Inserting Watermarks
4.3 Using the Format Tabs
4.4 AutoShapes
4.5 Editing Images
4.6 Using Captions
4.7 Working with Text Boxes
4.8 WordArt
5.0 Document Formatting
5.1 Section Breaks
5.2 Headers & Footers
5.3 Page Backgrounds & Page Borders
5.4 Drop Caps
5.5 Columns
6.0 Tables
6.1 Creating Tables
6.2 Using Table Contextual Tabs
6.3 Navigating & Selecting in a Table
6.4 Inserting & Deleting Columns and Rows
6.5 Sorting
6.6 Formatting Tables
6.7 Performing Calculations in a Table
6.8 Converting a Table to Text
7.0 Customizing Word
7.1 Customizing the Quick Access Toolbar
7.2 Customizing Word Options
Microsoft Word 2007: Advanced
Introduction
1.0 Working with Document Templates
1.1 Creating & Editing a Template
1.2 Creating Forms
1.3 Protect & Restrict Forms & Documents
2.0 Mail Merge
2.1 The Mail Merge Process
2.2 Using the Mailing Tab
2.3 Working with a Data Source
2.4 Creating Form Letters
2.5 Creating Envelopes
2.6 Creating Labels
3.0 Macros
3.1 Creating a Macro
3.2 Running a Macro
3.3 Editing a Macro
4.0 Working with Themes
4.1 Using Themes
4.2 Creating Custom Themes
5.0 SmartArt
5.1 About SmartArt
5.2 Creating a List
5.3 Creating a Hierarchy
5.4 Creating a Pyramid
5.5 Editing SmartArt
6.0 Long or Complex Documents
6.1 Using the References Tab
6.2 Bookmarks
6.3 Footnotes & Endnotes
6.4 Table of Contents & Index
6.5 Table of Figures & Table of Authorities
7.0 Collaborating
7.1 Using the Review Tab
7.2 Using Track Changes
7.3 Inserting Comments
7.4 Compare & Combine Document Versions
7.5 Ways to Secure a Document
7.6 Attaching Digital Signatures
8.0 Using Word with Other Programs
8.1 Linking vs. Embedding
8.2 Word & Excel
8.3 Word & PowerPoint
8.4 Word & Outlook
9.0 Using XML
9.1 Overview of XML
9.2 Saving as XM
