Microsoft Access 2007: Beginner
- Getting Started
- About Relational Databases and Access 2007
- Launching Access 2007
- Touring the Access Environment
- Using the Office Menu
- Database Components
- Using the Navigation Pane
- Getting Help
- Opening and Closing Access Databases
- Creating an Access Database Using a Preloaded Template
- Working with an Existing Table
- Exploring Datasheet View
- Editing and Selecting Table Data
- Adding and Deleting Records
- Find and Replace
- Undo and Redo
- Working with an Existing Form
- Exploring Form View
- Editing and Selecting Form Data
- Adding and Deleting Records
- Find and Replace
- Sorting and Filtering
- Sorting a Table and a Form
- About Filters
- Common Filters
- Filter by Selection
- Filter by Form
- Advanced Filter
- Designing Select Queries
- Using the Query Wizard
- Using Query Design View
- Using Criteria
- Sorting and Showing Query Fields
- Adding Tables to a Query
- Form Basics
- Using the Forms Wizard
- Using the Form Tool
- Working with Form Design View
- Working with Form Layout View
- Working with Form Controls
- Report Basics
- Using the Reports Wizard
- Using the Report Tool
- Working with Report Design View
- Working with Report Layout View
- Working with Report Controls
- Printing Database Objects
- Printing Tables or Queries
- Printing Forms
- Printing Reports
Microsoft Access 2007: Intermediate
- Planning and Designing a Database
- Database Design Process
- Creating a Database Using a Wizard
- Creating a Database from Scratch
- Building and Modifying Tables
- Creating a Table Using a Table Template
- About Data Types
- Creating a Table in Datasheet View
- Creating a Table in Design View
- Using Field Templates
- Setting Primary Keys
- Working with Relationships
- Types of Relationships
- Referential Integrity
- Cascading Updates and Deletes
- Multi-Valued Fields
- Printing Relationships
- 4.0 Sharing Your Data
- Export Your Access Report to Word
- Export Your Access Table to Excel
- Import Your Excel Spreadsheet into Access
- Copying the Table Structure and Data
- 5.0 Enhancing Your Forms
- Using the Field List Task Pane
- Using the Forms Controls Group
- Adding and Formatting Labels
- Adding Graphics
- Adding Command Buttons
- Enhancing Your Reports
- Using the Reports Control Group
- Adding Graphic Details
- Working with White Space and Report Width
Microsoft Access 2007: Advanced
- Preventing Data Entry Errors
- Using the Lookup Wizard
- Data Validation
- Working with Combo Boxes
- Working with List Boxes
- Advanced Table Design
- Field Properties
- Using Input Masks
- Using the Datasheet Total Row
- Using Rich Text in the Memo Field
- Advanced Query Design
- Creating a Calculated Field
- Creating a Crosstab Query
- Advanced Form Design
- Split Forms
- Working with the Property Sheet
- Changing Control Tab Order
- Conditional Formatting
- Adding Tab Pages
- Advanced Report Design
- Creating Groups and Total Reports
- Working with Total Fields
- Adding Calculated Controls to a Report
- Managing Databases
- Identify Object Dependencies
- Database Documenter
Microsoft Access 2007: Expert
- Expertly Designed Select Queries
- Single Parameter Queries
- Multiple Parameter Queries
- Query Joins
- Action Queries
- Types of Action Queries
- Update Queries
- Append Queries
- Make Take Queries
- Delete Queries
- Expertly Designed Forms
- Creating a Lookup Field
- Using a Bitmap as a Form Background
- Adding Calculated Controls to a Form
- Expertly Designed Reports
- Setting Section Properties
- Adding Graphics
- Arranging Report Data Into Columns
- Data Access Pages
- Creating a Data Access Page
- Editing a Data Access Page
- Grouping a Data Access Page
- Creating a PivotTable Data Access Page
- 6.0 Macros
- Create a Macro
- Edit a Macro
- Attach a Macro to a Command Button
- Database Security
- About Database Security
- Using a Database Password
- Creating Users and Groups
Microsoft Excel 2007: Beginner
- Getting Started
- Launching Excel 2007
- Touring the Excel Window
- Using the Office Menu
- Using the Quick Access Toolbar
- Save vs. Save As
- File and Folder Management
- Opening and Closing Files
- Getting Help
- Entering Data
- Navigation and Selection Techniques
- Data Entry Techniques
- AutoFill
- AutoComplete
- Undo and Redo
- Exiting Excel
- Changing Worksheet Layout
- Inserting Rows, Columns and Cells
- Deleting Rows, Columns and Cells
- Adjusting Column Widths and Row Heights
- Hiding Columns and Rows
- Moving and Copying Data
- Create, Modify and Delete Named Ranges
- Go To, Find and Replace
- Entering Formulas
- Anatomy of a Formula
- Using the Formula Tab
- AutoSum
- Basic Functions
- Copying Formulas
- Formatting
- Using the Home Tab
- Using the Quick Format Mini Toolbar
- Number Formats
- Format as a Table
- Merging and Splitting Cells
- Applying Worksheet Backgrounds
- Using Themes and Styles
- Applying Themes
- Creating Custom Themes
- Applying Styles
- Creating Custom Styles
- Printing
- Using the Page Layout Tab
- Changing Margins and Page Orientation
- Exploring Worksheet Views
- Adding Headers and Footers
- Adding Print Titles and a Print Area
- Viewing and Setting Page Breaks
- Printing
- Charts
- Using the Insert Tab
- Creating a Chart
- Using the Chart Contextual Tabs
- Creating a Chart Sheet
- Adding and Removing Chart Data
- Format and Resize Charts
Microsoft Excel 2007: Intermediate
- Managing Workbooks
- Creating New Workbooks from a Template
- Rename and Move Workbook Tabs
- Insert and Delete Worksheets
- Copy and Paste Worksheets
- Using the View Tab
- Splitting Your Worksheet View
- Freezing and Unfreezing Your View
- Tables and Data Management
- Table Guidelines
- Using the Data Tab
- Sorting
- Grouping and Outlining Data
- AutoFilter
- Advanced Filter Using Single Criteria
- Advanced Filter Using Multiple Criteria
- Automatic Subtotals
- Using Cell References
- Using Relative Cell References
- Using Absolute Cell References
- Using Mixed Cell References
- Auditing
- About Auditing
- Tracing Precedents
- Tracing Dependents
- Tracing Errors
- Creating Web Pages from Workbooks
- Publishing a Web Page
- Viewing Your Published Web Page
- Using Excel with Other Applications
- Importing Data to Excel
- Exporting Data from Excel
- About XML
- Customizing Excel
- Customizing the Quick Access Toolbar
- Modifying Excel Options
- Using Scenarios and Watching Cells
- Creating and Displaying Scenarios
- Editing and Removing Scenarios
- Summarizing Scenarios
- Using the Watch Window
- PivotTables and PivotCharts
- About PivotTables and PivotCharts
- Creating a PivotTable
- Modifying a PivotTable
- Creating a PivotChart
- Modifying a PivotChart
Microsoft Excel 2007: Advanced
- Collaborating
- Inserting and Deleting Comments
- Viewing and Printing Comments
- Protecting Workbooks, Worksheets and Cells
- Enabling Workbook Security
- Sharing Workbooks
- 2.0 Advanced Formulas and Functions
- IF Functions
- Nested IF Functions
- Using the VLOOKUP Function
- Using the HLOOKUP Function
- Using the DSUM Function
- Data Consolidation
- About Data Consolidation
- Three Dimensional Formulas
- Data Consolidation by Position
- Data Consolidation by Category
- SmartArt
- About SmartArt
- Creating a List
- Creating a Hierarchy
- Creating a Pyramid
- Editing SmartArt
- Track Revisions
- Tracking Changes
- Accepting and Rejecting Changes
- Data Validation and Conditional Formatting
- Working with Data Validation Rules
- Set Conditional Formatting
- Use Expressions in Conditional Formatting
- Creating Templates
- Using Excel Pre-Defined Templates
- Creating and Modifying a Template
- Macros
- Create a Macro
- Run a Macro
- Edit a Macro
Microsoft Outlook 2007: Beginner
- Getting Started
- Launching Outlook 2007
- Touring the Outlook Window
- Using the Navigation Pane
- Exploring the To-Do Bar
- Reading & Sending E-mail
- Creating & Sending an E-mail Message
- Using the Message Tab
- Using the Address Book
- Saving a Message as a Draft
- Adding an Attachment to an E-mail Message
- Reading Messages
- Viewing Attachments
- Replying to & Forwarding Messages
- Reply vs. Reply to All
- Forwarding a Message
- Understanding Message Icons in Your Inbox
- Formatting Messages
- Using the Format Text Tab
- Using the Quick Format Mini Toolbar
- Marking Message Importance
- Working with Styles
- Using the Zoom Feature
- Using Find & Replace
- Working with E-mail Addresses
- Adding & Editing a Contact
- Using the Contact Tab
- Adding a Contact from an E-mail Message
- Sending a Message from Contact View
- Creating & Using Distribution Lists
- Exporting E-mail Addresses
- Importing E-mail Addresses
- Managing Mail
- Deleting Messages
- Emptying Your Deleted Items Folder
- Using Folders to Manage Your E-mail
- Move & Copy Messages to a Folder
- Renaming a Folder
- Printing E-mail Messages
- Using the Print Dialog Box
- Printing in Table vs. Memo Style
- Printing Attachments
Microsoft Outlook 2007: Intermediate
- Using the Calendar
- Creating an Appointment
- Using the Appointment Tab
- Creating a Recurring Appointment
- Editing an Appointment
- Setting Appointment Reminder Options
- Working with Calendar View Options
- Printing Your Calendar
- Planning Meetings & Appointments
- Creating & Sending a Meeting Request
- Using the Meeting Tab
- Responding to a Meeting Request
- Updating a Meeting Request
- Searching for Appointments
- Advanced Contact Options
- Viewing Contacts
- Searching for Contacts
- Sorting Contacts
- Forwarding Contacts
- Printing Contacts
- Using Tasks
- Creating a Task
- Using the Task Tab
- Editing, Sorting & Viewing Tasks
- Creating a Recurring Task
- Creating a Task Request
- Responding to a Task Request
- Marking a Task as Complete
- Using Notes
- Creating Notes
- Editing, Viewing & Sorting Notes
- Formatting Notes
- Advanced Mail Message Options
- Using Spell Check
- Creating & Editing Signatures
- Using Stationery
- Working with Themes
- Using Themes
- Creating Custom Themes
Microsoft Outlook 2007: Advanced
- Filtering, Finding & Flagging Messages
- Filtering Messages
- Finding Messages
- Flagging Messages
- Completing & Clearing a Flag
- Archiving Outlook Data
- About Archiving Data
- Enabling & Disabling AutoArchive
- Running the Manual Archive
- Personal File Folders
- About Personal File Folders
- Creating a Personal File Folder
- Moving & Copying Messages
- Using the Journal
- Creating a Journal Entry
- Creating Automatic Journal Entries
- Editing a Journal Entry
- Organizing Your Outlook Items
- Creating Rules
- Editing & Deleting Rules
- Using Conditional Formatting
- Grouping Items
- Custom Forms
- Creating a Custom Form
- Using a Custom Form
- Working with Pictures and Shapes
- Using the Insert Tab
- Inserting ClipArt & Pictures
- Drawing AutoShapes
- 7sing the Format Tabs
- Resizing Objects
- Layering Objects
- Working with WordArt & SmartArt
- Inserting a WordArt Object
- Editing a WordArt Object
- About SmartArt
- Creating a List
- Creating a Hierarchy
- Creating a Pyramid
- Editing SmartArt
- Customizing Outlook
- Working with the Quick Access Toolbar
- Working with Outlook Options
- Customizing Toolbars
Microsoft Powerpoint 2007: Beginner
- Getting Started
- Launching PowerPoint 2007
- Touring the PowerPoint Window
- Using the Office Menu
- Using the Quick Access Toolbar
- Getting Help
- Opening & Closing Files
- Creating a New Presentation
- Creating a New Presentation from a Template
- Creating a New Presentation from Scratch
- Using the Home Tab
- Adding & Editing Text
- Undo, Redo & Repeat
- Save vs. Save As
- File & Folder Management
- Exiting PowerPoint
- Viewing Presentations
- Navigating Through a Presentation
- Presentation Views
- Using Slide Show View
- Modifying an Existing Presentation
- Slide Basics
- Choosing a Design Theme
- Working with Text Boxes
- Formatting Text
- Using Bullets & Numbering
- Working with Indents & Line Spacing
- AutoCorrect
- Preparing a Presentation for Delivery
- Using Spell Check
- Using the Thesaurus & Research Panes
- Working with Speaker Notes
- Adding a Header & Footer
- Printing Presentations and Handouts
Microsoft Powerpoint 2007: Intermediate
- Outlines
- Adding & Editing Slides in Outline View
- Formatting Slide Text in Outline View
- Exporting a PowerPoint Outline
- Working with Pictures and Shapes
- Using the Insert Tab
- Inserting ClipArt & Pictures
- Working with AutoShapes
- Using the Format Tabs
- Grouping & Ungrouping Objects
- Layering Objects
- Working with Presentation Colors
- Using the Design Tab
- Applying Themes
- Creating Custom Themes
- Working with Animation
- Using the Animations Tab
- Adding Entrance & Exit Animation
- Adding Emphasis
- Using Motion Paths
- Assigning the Order of Animation Effects
- Organizing & Enhancing Your Presentation
- Duplicating & Deleting Slides
- Hiding Slides
- Rearranging Slides
- Adding Slide Transitions
- Managing Presentations
- Inserting Slides from Other Presentations
- Using Find & Replace
- Customizing PowerPoint
- Customizing the Quick Access Toolbar
- Modifying PowerPoint Options
Microsoft Powerpoint 2007: Advanced
- Working with Tables
- Adding a Table to a Slide
- Using Table Contextual Tabs
- Navigating & Selecting in a Table
- Inserting & Deleting Columns and Rows
- Formatting a Table
- Inserting an h3. Microsoft Excel Table
- Working with Charts
- Creating a Chart
- Using the Chart Tab
- Adding & Removing Chart Data
- Formatting & Resizing Charts
- WordArt & SmartArt
- Insert a WordArt Object
- Editing a WordArt Object
- About SmartArt
- Creating a List
- Creating a Hierarchy
- Creating a Pyramid
- Editing SmartArt
- Working with Templates, Masters & Custom Layouts
- Creating and Editing a Custom Template
- Working with Masters
- Working with Custom Layouts
- Saving Presentations for the Web
- Adding a Hyperlink to a Slide
- Publishing a Presentation to the Web
- Collaboration
- Using the Review Tab
- Inserting, Viewing & Editing Comments
- Advanced Presentation Delivery Options
- Working with Action Buttons
- Annotating a Presentation
- Using Slide Timings
- Slide Show Options
Microsoft Word 2007: Beginner
- Getting Started
- Launching Word 2007
- Touring the Word Window
- Using the Office Menu
- Using the Quick Access Toolbar
- Getting Help
- Creating New Documents
- Starting a New Document
- Editing Text
- Saving Your Work
- Preview & Print a Document
- Using a Template
- Exiting Word
- Editing Existing Documents
- Opening a Document
- Navigating a Document
- Working with Multiple Page Documents
- Essential Word 2007 Skills
- Selecting Text
- Moving & Copying Text
- Clipboard Task Pane
- Undo, Redo & Repeat
- AutoCorrect
- Formatting Text & Paragraphs
- Using the Home Tab
- Using the Quick Format Mini Toolbar
- Working with Text Formatting
- Working with Line & Paragraph Spacing
- Using Format Painter
- Adding Symbols & Special Characters
- Proofing Tools
- Spelling & Grammar
- Using the Thesaurus & Other Research Options
- Checking Character & Word Count
- Working with the Custom Dictionary
- Editing in Print Preview
- Changing Your Page Appearance
- Using the Page Layout Tab
- Changing Margins & Page Orientation
- Working with Page Breaks
- Adding Line Numbers
Microsoft Word 2007: Intermediate
- Managing Documents
- Document Views
- Using the View Tab
- Working with Multiple Documents
- Saving Your Word Document as a Web Page
- Additional Editing Tools
- Go To, Find & Replace
- Format Painter
- AutoCorrect
- Paragraph Formatting
- Bullets & Numbering
- Tabs & Indents
- Borders & Shading
- Using Styles
- Introduction to Graphics
- Inserting ClipArt & Pictures
- Inserting Watermarks
- Using the Format Tabs
- AutoShapes
- Editing Images
- Using Captions
- Working with Text Boxes
- WordArt
- Document Formatting
- Section Breaks
- Headers & Footers
- Page Backgrounds & Page Borders
- Drop Caps
- Columns
- Tables
- Creating Tables
- Using Table Contextual Tabs
- Navigating & Selecting in a Table
- Inserting & Deleting Columns and Rows
- Sorting
- Formatting Tables
- Performing Calculations in a Table
- Converting a Table to Text
- Customizing Word
- Customizing the Quick Access Toolbar
- Customizing Word Options
Microsoft Word 2007: Advanced
- Working with Document Templates
- Creating & Editing a Template
- Creating Forms
- Protect & Restrict Forms & Documents
- Mail Merge
- The Mail Merge Process
- Using the Mailing Tab
- Working with a Data Source
- Creating Form Letters
- Creating Envelopes
- Creating Labels
- Macros
- Creating a Macro
- Running a Macro
- Editing a Macro
- Working with Themes
- Using Themes
- Creating Custom Themes
- SmartArt
- About SmartArt
- Creating a List
- Creating a Hierarchy
- Creating a Pyramid
- Editing SmartArt
- Long or Complex Documents
- Using the References Tab
- Bookmarks
- Footnotes & Endnotes
- Table of Contents & Index
- Table of Figures & Table of Authorities
- Collaborating
- Using the Review Tab
- Using Track Changes
- Inserting Comments
- Compare & Combine Document Versions
- Ways to Secure a Document
- Attaching Digital Signatures
- Using Word with Other Programs
- Linking vs. Embedding
- Word & Excel
- Word & PowerPoint
- Word & Outlook
- Using XML
- Overview of XML
- Saving as XML