Microsoft Office Word 2007

    Chapter 1 - What Will Word Processing Do for Me?

    Section 1 Introduction to Word Processing

        Understanding Word Basics

        Using AutoText

        Viewing a Document

        Using the Mini Toolbar

            Hands-On Exercise #1:  Introduction to Microsoft Word

    Section 2 Document Formatting

        Setting Margins and Specifying Page Orientation

        Inserting Page Breaks

        Adding Page Numbers

        Inserting Headers and Footers

        Creating Sections

        Inserting a Cover Page

        Using Find and Replace Commands

            Hands-On Exercise #2: Document Organization

    Section 3 The Final Touches

        Checking Spelling and Grammar

        Using Save and Backup Options

        Selecting Printing Options

        Customizing Word

            Hands-On Exercise #3: The Final Touches

    Summary

    Key Terms

    Practice Exercises

    Mid-Level Exercises

   Capstone Exercise

    Mini Cases

Chapter 2 - Gaining Proficiency: Editing and Formatting

    Section 1 Text Formatting

        Applying Font Attributes Through the Font Dialog Box

        Highlighting Text

        Controlling Word Wrapping with Nonbreaking Hyphens and Nonbreaking Spaces

        Copying Formats with the Format Painter

            Hands-on exercise #1: Character Formatting

    Section 2 Paragraph Formats

        Setting Off Paragraphs with Tabs, Borders, Lists, and Columns

        Applying Paragraph Formats

            Hands-on exercise #2: Paragraph formatting

    Section 3 Styles and Document References

        Creating and Modifying Styles

            Hands-on exercise #3: Styles

        Table of Contents and Indexes

            Hands-on exercise #4: Reference Pages

    Summary

    Key Terms

    Practice Exercises

    Mid-Level Exercises

    Capstone Exercise

    Mini Cases

Microsoft Office Excel 2007

Chapter 1 - Introduction to Excel

    Section 1: Introduction to Spreadsheets

        Defining Worksheets and Workbooks

        Using Spreadsheets Across Disciplines

        Planning for Good Workbook and Worksheet Design

        Identifying Excel Window Components

        Entering and Editing Data in Cells

            Hands-On Exercise #1:  Introduction to Microsoft Excel

    Section 2: Mathematics and Formulas

        Describing and Using Symbols and the Order of Precedence

        Displaying Cell Formulas

        Inserting and Deleting Rows and Columns

        Using Cell Ranges, Excel Move, Copy, Paste and Paste Special, and AutoFill

            Hands-On Exercise #2:  Jakes Gym Continued

    Section 3: Workbook and Worksheet Enhancements

        Managing Worksheets

        Formatting Worksheets

            Hands-On Exercise #3: Formatting Jake's Gym Worksheet

    Section 4: Page Setup and Printing

        Selecting Page Setup Options for Printing

        Managing Cell Comments

            Hands-On Exercise #4: Printing Jake's Gym Worksheet

    Summary

    Key Terms

    Multiple Choice

    Practice Exercises

    Mid-Level Exercises

    Capstone Exercise

    Mini Cases

Chapter 2 - Microsoft Excel: Formulas and Functions 

    Section 1: Formula Basics         

        Creating and Copying Formulas  

        Using Relative and Absolute Cell Addresses        

            Hands-On Exercise #1:  Smithtown Hospital Radiology Department Payroll           

    Section 2: Function Basics        

        Using AutoSum

        Inserting Basic Statistical Functions       

        Using Date Functions    

            Hands-On Exercise #2:  Completing the Smithtown Hospital Radiology Department

    Section 3: Logical and Lookup Functions

        Using the IF Function

        Using the VLOOKUP Function

            Hands-On Exercise #3:  Athletic Department Eligibility Gradebook

    Section 4: Financial Functions   

        Using the PMT Function

        Using the FV Function   

            Hands-On Exercise #4: Purchasing a Van for the School for Exceptional Children  

    Summary         

    Key Terms       

    Multiple Choice 

    Practice Exercises        

    Mid-Level Exercises      

    Capstone Exercise        

    Mini Cases

Microsoft Access 2007

Chapter 1 - Introduction to Access: Finding Your Way through a Database

    Section 1: Data and Files Everywhere!

        Exploring, Describing, and Navigating Among the Objects in an Access Database

        Understanding the Difference Between Working in Storage and Memory

        Practicing Good File Management

        Backing up, Compacting, and Repairing Access Files

            Hands-On Exercises 1 Introduction to Databases

    Section 2: Filters, Sorts, and Access Versus Excel

        Creating Filters

        Sorting Table Data on One or More Fields

        Knowing When to Use Access or Excel  to Manage Data

            Hands-On Exercises 2: Data Manipulation: Filters and Sorts

    Section 3: The Relational Database

        Using the Relationship Window

        Understanding Relational Power

            Hands-On Exercises 3: Introduction to Relationships

    Summary

    Key Terms

    Multiple Choice

    Practice Exercises

    Mid-Level Exercises

    Capstone Exercise

    Mini Cases

Chapter 2 - Relational Databases and Multi-Table Queries: Designing Databases and Using

    Section 1: Related Data

        Table Design, Properties, Views, and Wizards

        Designing Data

        Creating Tables

            Hands-On Exercises 1: Table Design, Properties, Views, and Wizards

    Section 2: Multiple Table Database

        Understanding Table Relationships

        Sharing Data with Excel

        Establishing Table Relationships

            Hands-on Exercises 2: Imports and Relationships

    Section 3: Queries

        Creating a Query

        Specifying Criteria for Different Data Types

        Copying and Running a Query

        Using the Query Wizard

        Understanding Large Database Differences

            Hands-On Exercises 3: Multi-Table Query

    Summary

    Key Terms

    Multiple Choice

    Practice Exercises

    Mid-Level Exercises

    Capstone Exercise

    Mini Cases

Microsoft Office PowerPoint 2007

Chapter 1 - Introduction to PowerPoint

        Purpose of PowerPoint Presentations

        Understanding the PowerPoint Interface

        Creating a Basic Slide Show

        Running a Slide Show

        Page Setup

        Printing with PowerPoint

            Hands-on Exercises 1-4

            Capstone Exercise

            Mini-Cases 1-3

            (Content Application, Disaster Recovery, Research)

    Chapter 2 - Developing a Presentation

        Planning Process

        AutoContent Wizard

        Outline Tab

        Import Outlines

        Animate Text

        Print Outline

        Export Outline to Word

        Headers and Footers

            Hands-on Exercises 1-4

            Capstone Exercise

            Mini-Cases 1-3

            (Content Application, Disaster Recovery, Research)

Office Applications  [EXPLORING SERIES 2007 / 2003]   (CIS: Office Applications)

For the CIS: Office Applications Discipline

PHIT TIPS Microsoft Access 2007
PrenticeHall
©2008   |   Prentice Hall   |   Study Card; 4 pp   |   Instock
ISBN-10: 0131588346   |   ISBN-13: 9780131588349
Suggested retail price: $8.67  Buy from myPearsonStoreNet price: $6.50  (What's this?)

PHIT Tips: File Management
PrenticeHall
©2008   |   Prentice Hall   |   Study Card; 2 pp   |   Instock
ISBN-10: 0131588354   |   ISBN-13: 9780131588356
Suggested retail price: $8.67  Buy from myPearsonStoreNet price: $6.50  (What's this?)

Phit TIPS: Microsoft Excel 2007
PrenticeHall
©2008   |   Prentice Hall   |   Study Card; 4 pp   |   Instock
ISBN-10: 0136128017   |   ISBN-13: 9780136128014
Suggested retail price: $8.67  Buy from myPearsonStoreNet price: $6.50  (What's this?)

PHIT Tips: Microsoft Office 2007
PrenticeHall
©2008   |   Prentice Hall   |   Study Card; 4 pp   |   Instock
ISBN-10: 0132332221   |   ISBN-13: 9780132332224
Suggested retail price: $8.67  Buy from myPearsonStoreNet price: $6.50  (What's this?)

PHIT Tips: Microsoft Outlook 2007
PrenticeHall
©2008   |   Prentice Hall   |   Study Card; 4 pp   |   Instock
ISBN-10: 0132050625   |   ISBN-13: 9780132050623
Suggested retail price: $8.67  Buy from myPearsonStoreNet price: $6.50  (What's this?)

PHIT Tips: Microsoft PowerPoint 2007
PrenticeHall
©2008   |   Prentice Hall   |   Study Card; 4 pp   |   Instock
ISBN-10: 0132332558   |   ISBN-13: 9780132332552
Suggested retail price: $8.67  Buy from myPearsonStoreNet price: $6.50  (What's this?)

PHIT Tips: Microsoft Word 2007
PrenticeHall
©2008   |   Prentice Hall   |   Study Card; 4 pp   |   Instock
ISBN-10: 0132050617   |   ISBN-13: 9780132050616
Suggested retail price: $8.67  Buy from myPearsonStoreNet price: $6.50  (What's this?)

PHIT Tips: WinZip for Microsoft Office 2007
PrenticeHall
©2008   |   Prentice Hall   |   Study Card   |   Instock
ISBN-10: 0131588311   |   ISBN-13: 9780131588318
Suggested retail price: $8.67  Buy from myPearsonStoreNet price: $6.50  (What's this?)

Shortcut Key Card: Microsoft Office 2007
PrenticeHall
©2008   |   Prentice Hall   |   Study Card; 2 pp   |   Instock
ISBN-10: 0131588400   |   ISBN-13: 9780131588400
Suggested retail price: $8.67  Buy from myPearsonStoreNet price: $6.50  (What's this?)

Windows Vista PHIT Tip
Prentice Hall
©2008   |   Prentice Hall   |   Study Card; 4 pp   |   Instock
ISBN-10: 0136128025   |   ISBN-13: 9780136128021
Suggested retail price: $8.67  Buy from myPearsonStoreNet price: $6.50  (What's this?)

Pearson Higher Education offers special pricing when you choose to package your text with other student resources. If you're interested in creating a cost-saving package for your students, browse our available packages below, or contact your Pearson Higher Education representative to create your own package.

Package ISBN-10: 0136043577 | ISBN-13: 9780136043577
©2008 | Instock
Suggested retail price: $100.00  Buy from myPearsonStore
Net price: $75.00  (What's this?)
This package contains:

Package ISBN-10: 0138153787 | ISBN-13: 9780138153786
©2008 | Instock
Suggested retail price: $131.87  Buy from myPearsonStore
Net price: $98.90  (What's this?)
This package contains:

Package ISBN-10: 0137133421 | ISBN-13: 9780137133420
©2008 | Instock
Suggested retail price: $238.00  Buy from myPearsonStore
Net price: $228.50  (What's this?)
This package contains:

Package ISBN-10: 0132161834 | ISBN-13: 9780132161831
©2011 | Not Yet Published
Suggested retail price: $346.67  
Net price: $260.00  (What's this?)
This package contains:

Package ISBN-10: 0135085926 | ISBN-13: 9780135085929
©2009 | Instock
Suggested retail price: $338.67  Buy from myPearsonStore
Net price: $254.00  (What's this?)
This package contains:

Package ISBN-10: 0131391844 | ISBN-13: 9780131391840
©2010 | Not Yet Published
Suggested retail price: $349.33  
Net price: $262.00  (What's this?)
This package contains:

Package ISBN-10: 0135106745 | ISBN-13: 9780135106747
©2010 | Instock
Suggested retail price: $358.67  Buy from myPearsonStore
Net price: $269.00  (What's this?)
This package contains:

Package ISBN-10: 0135057132 | ISBN-13: 9780135057131
©2008 | Out of Stock
Suggested retail price: $147.47  Buy from myPearsonStore
Net price: $110.60  (What's this?)
This package contains:

This package contains:
•   Grauer, Hulett, Krebs, Mulbery, Lockley & Scheeren, Exploring Microsoft Office 2007 Brief (2008)
•   Grauer, Exploring MS Office 2007 Brief Student CD (2008)