Exploring Microsoft Office 2007 Volume 2

Prentice Hall
Robert T. Grauer / Michelle Hulett / Cynthia Krebs / Maurie Lockley / Judy Scheeren  
Total pages
August 2007
Related Titles


The content associated with the traditional text has moved to Pearson Custom Library (PCL). PCL allows customers to create customized textbooks, giving students a more engaging and affordable education. If you would like to purchase the full test without customization, please use ISBN: 0558727883. For more information about customization opportunities, refer to www.pearsoncustomlibrary.com.


The goal of the Exploring series has been to move students beyond the point and click and help the student understand why and when they would perform a skill.   The system structure considers the following three points.


Students go to college now with a different set of skills than they did 5 years ago.  With this in mind, the new edition of Exploring moves students beyond the basics of the software at a faster pace, without sacrificing coverage of the fundamental skills that everybody needs to know.  This ensures that students will be engaged from Chapter 1 throughout the book.


Students have diverse career goals. The examples in the text (and the accompanying Instructor Resources) include the health sciences, hospitality, urban planning, business and more so Exploring will be relevant to every student in the course.


Students read, prepare and study differently than they used to. Rather than reading a book cover to cover students want to easily identify what they need to know, and then learn it efficiently.  The key features bring students into the content and make the text easy to use.


Students will be more engaged, achieve a higher level understanding in Office, and will successfully complete this course.


The Exploring Instructional System: Textbook, myitlab, and Annotated Instructor Resources


Instructor Resources

·        Reference Cards:

o       Case Study lecture Demonstration Document

Lecture demonstration that mimics each chapter project.


o       Concept Summary: 

Reference card that outlines chapter objectives and common pit falls.


Student Textbook

·        Beyond the Basics

o       More advanced skills are introduced earlier as students are learning basic skills faster.

·        White Pages/Yellow Pages

o       Clearly distinguish the theory from the skill exercises.

·        Objective Mapping

o       Allows students to skip the skills they know and quickly identify the skills they don't know.

·        Pull Quotes

o       Entice students into the theory/concepts by highlighting the most interesting points.

·        Case Study Related

o       Are icons that help students identify skills specific to the case study.

·        Conceptual Animations

o       Literally illustrates how Exploring connects the theory with the skills.


·        More Exercises

o       Offer the instructor even more options for assessment.  We offer 12-15 projects/chapter ranging from MC to open-ended projects.   Most competitors have 8-10.

·        Rubrics

o       Give both the instructors and students a guide to a solution.  Each Mini Cases has its own rubric.

·        Capstone Production Tests (one in the text and one in the IRCD)

o       Allow the instructors to assess all the skills in the chapter with a single project.



·        Online Assessment and Training

o       Seamlessly integrate online assessment and training with the new myitlab for Microsoft Office 2007!

o       Project-Driven assessment and outcomes-based training share content between the Exploring text and myITlab.

o       No more software installations

Table of Contents

Exploring Microsoft Office Word 2007 Comprehensive


Chapter 5 - Advanced Features: Wizards, Templates, and Mail Merge


Section 1 Automated Features

    Using shortcuts

        Hands-On Exercise #1:  Using a Wizard


Section 2 Mail Merge

    Creating Form Letters

        Hands-On Exercise #2: Using the Mail Merge Wizard


Section 3 Merge with External Source Data

    Merging with Excel and Access Data

        Hands-On Exercise #3: Merge with External Source Data



    Key Terms

    Practice Exercises

    Mid-Level Exercises

    Capstone Exercise

    Mini Cases


Chapter 6 - Desktop Publishing: Creating a Newsletter and Other Documents


Section 1 Introduction to Desktop Publishing

    The Newsletter


        Hands-On Exercise #1: Newspaper columns


Section 2 Elements of Graphic Design

    The Grid

    The Drawing Toolbar

        Hands-On Exercise #2: Complete the Newsletter


Section 3 Object Linking and Embedding

    Inserting Objects from other Applications

        Hands-On Exercise #3: Object Linking and Embeddings



    Key Terms

    Practice Exercises

    Mid-Level Exercises

    Capstone Exercise

    Mini Cases


Chapter 7 - The Expert User: Forms, Document Protection, and Macros


Section 1 Forms

    Creating an Electronic form

        Hands-On Exercise #1: Forms


Section 2 Protection and Authentication

    Adding Security

    Create an Electronic Stamp of Authenticity

        Hands-On Exercise #2: Secure a document and add a digital signature


Section 3 Automating Word

    Introduction to Macros

        Hands-On Exercise #3: Introduction to Macros




    Key Terms

    Practice Exercises

    Mid-Level Exercises

    Capstone Exercise

    Mini Cases


Chapter 8 - Introduction to xHTML: Creating a Home Page and a Web Site


Section 1 Online Resources

    Microsoft Word and the Internet

        Hands-On Exercise #1: Microsoft Word and the World Wide Web


Section 2 Creating a Home Page

    Using Word to Create a Web Page

    Developing a Web Site

        Hands-On Exercise #2: World Wide Travel Home Page


Section 3 Introduction to XML

    Extensible Markup Language

        Hands-On Exercise #3 Introduction to XML



    Key Terms

    Practice Exercises

    Mid-Level Exercises

    Capstone Exercise

    Mini Cases

Exploring Microsoft Office Excel 2007 Comprehensive


Chapter 5 - Convert Data to Information

 Section 1 Table Management

    Exploring Table and Data Theory

    Working with a Table Form

    Importing Text

        Hands-on Exercise 1:  Import Data and Maintain a List


Section 2 Data Management

    Defining Data and Information

        Hands-on Exercise 2: Data Versus Information


Section 3 Data Analysis

    Exploring Pivot Tables and Pivot Charts

        Hands-on Exercise 3: Pivot Tables and Pivot Charts



    Key Terms

    Multiple Choice

    Practice Exercises

    Mid-Level Exercises

    Capstone Exercise

    Mini Cases


Chapter 6 - Consolidate Data and Link Files   


Section 1 Data Consolidation

    Consolidating Data from multiple Worksheets

    Defining the Three-Dimensional Workbook

        Hands-on Exercise 1: Copy Worksheets


Section 2 Worksheet 3-D References

    Working with 3-D Refernces

        Hands-on Exercise 2: Worksheet References


Section 3 Workbook Linking and Documentation

    Linking Workbooks

    Creating the Cover Sheet

        Hands-on Exercise 3: Linking and Documentation



    Key Terms       

    Multiple Choice 

    Practice Exercises        

    Mid-Level Exercises      

    Capstone Exercise        

    Mini Cases


Chapter 7 - What-IF Analysis--Forecasting and Amortization


Section 1 Financial Analysis

    Defining Forecasting

    Using Scenario Manager

    Solving Problems with Goal Seek

        Hands-on Exercise 1: The Financial Forecast


Section 2 Functions for Amortization Table

    Working with Functions

    Using Name Manager

        Hands-on Exercise 2: The Amortization Schedule


Section 3 Workgroups and Auditing

    Validating Data

    Auditing Formulas

    Setting up a Watch Window

        Hands-on Exercise 3: Auditing



    Key Terms

    Multiple Choice

    Practice Exercises

    Mid-Level Exercises

    Capstone Exercise

    Mini Cases


Chapter 8 - Templates, Themes, and Web Pages


Section 1 Worksheet Automation

    Working with Existing Templates, Themes, and Styles

    Creating a Template

    Using Styles for Advanced Formatting

        Hands-on Exercise 1: Creating a Template


Section 2 Web Pages

    Creating a Web page

        Hands-on Exercise 2: Creating a Web Page


Section 3 Web Queries and  Web Data

    Creating Web Queries

        Hands-on Exercise 3: Web Queries



    Key Terms

    Multiple Choice

    Practice Exercises

    Mid-Level Exercises

    Capstone Exercise

    Mini Cases


Chapter 9 - Collaboration and Macros


Section 1 Excel Collaboration

    Sharing Data

    Copying to Word

    Copying to Power Point

        Hands-on Exercise 1:


Section 2 Repetitive Tasks

    Working with Macros

        Hands-on Exercise 2:



    Key Terms

    Practice Exercises

    Mid-Level Exercises

    Capstone Project

    Mini Cases


Chapter 10 - Data Analysis--A Capstone Chapter


Section 1 Drowning in Data

    The Admissions Office

        Hands-on Exercise 1: Case Relevant Scenario


Section 2 The Case Worksheet

        Hands-on Exercise 2: Case Relevant Scenario


Section 3 The Case Worksheet

        Hands-on Exercise 3: Case Relevant Scenario


Section 4 The Case Worksheet

        Hands-on Exercise 4: Case Relevant Scenario


Exploring Microsoft Access 2007 Comprehensive


Chapter 5 - Sub-reports, More Query Types, Pivot Tables and Charts


Section 1 Pivot Tables

    Creating Pivot Tables

        Hands-on Exercise 1: Pivot Tables


Section 2 Pivot Charts

    Recognizing Good Chart Design

    Creating Pivot Charts

    Editing Pivot Charts

        Hands-on Exercise 2: Pivot Charts


Section 3 Interactive Pivots

    Creating Multiple Pivots

        Hands-on Exercise 3: Interactive Pivots



    Key Terms

    Multiple Choice

    Practice Exercises

    Mid-Level Exercises

    Capstone Exercise

    Mini Cases


Chapter 6 - Data Protection - Working with Data Integrity

Section 1 Protecting Table Data

    Creating a table validation rule

        Hands-on Exercise 1: Data Validation


Section 2 Understanding the need for forms

    Planning the form

    Selecting and modifying Controls

        Hands-on Exercise 2: Form Creation


Section 3 - Advanced Forms

    Creating a calculated control in a form

    Adding a sub form

        Hands-on Exercise 3: Advanced Forms



    Key Terms

    Multiple Choice

    Practice Exercises

    Mid-Level Exercises

    Capstone Exercise

    Mini Cases


Chapter 7 - Database Maintenance - Creating Advanced Queries


Section 1 Maintenance Query Types

    Creating a Make Table Query

    Creating an Append Query

    Creating a Delete Query

    Creating an Update Query

        Hands-on Exercise 1: Creating Maintenance Queries


Section 2 Advanced Queries

    Crosstab Queries

    Using Table Field Indexes

        Hands-On Exercise 2: Cross tabbing and Indexing


Section 3 Housekeeping

    Setting the database to compact automatically

    Converting a database to previous Access versions

        Hands-on Exercise 3: Maintenance



    Key Terms

    Multiple Choice

    Practice Exercises

    Mid-Level Exercises

    Capstone Exercise

    Mini Cases


Chapter 8 - Integrating Access with the Internet


Section 1 Access and the Web

    Creating a Hyperlinked Field

    Inserting Hyperlinks to a File or Web Page

    Linking to an E-mail Address

        Hands-on Exercise 1: Getting Connected


Section 2 Access and the Web

    Exporting database objects as an HTML document

    Importing or Linking to an HTML File

    Viewing a Data Access Page

        Hands-on Exercise 2:


Section 3 Access and Excel

    Creating Data for Excel Users

        Hands-on Exercise 3:



    Key Terms

    Multiple Choice

    Practice Exercises

    Mid-Level Exercises

    Capstone Exercise

    Mini Cases


Chapter 9 - Bulletproofing the Database


Section 1 Data Protection

    Analyzing Database performance

    Managing and Securing the Data

    Using Performance Analyzer

    Using the Linked Table Manager

    Creating a database Replica

    Synchronizing the design and replica

        Hands-on Exercise 1: Performance Measurements


Section 2 Helping Database Users

    Creating a user interface

    Creating a switchboard

    Creating a dialog box

    Adding command buttons

    Viewing and testing a switchboard

        Hands-on Exercise 2: Switchboards and Commands


Section 3 Splits and Security

    Splitting a database

    Encrypting the data

    Establishing User-level security

    Testing security levels

    Normalizing a Database

        Hands-on Exercise 3: Split Database and User Securities



    Key Terms

    Multiple Choice

    Practice Exercises

    Mid-Level Exercises

    Capstone Exercise

    Mini Cases


Chapter 10 - Customizing a database with programming languages


Section 1

    Using SQL

    Viewing SQU statements in a query

    Modifying a SQL statement


Section 2

    Using VBA

    Introducing Events

    Working with procedures

    Creating Modules

    Displaying an Event Procedure

    Testing a procedure in an intermediate window

    Creating Class modules



    Key Terms

    Multiple Choice

    Practice Exercises

    Mid-Level Exercises

    Capstone Exercise

    Mini Cases


Exploring Microsoft Office PowerPoint 2007 Comprehensive


Chapter 5 - Working with Charts and Graphs


Text-based Charts

    Basic Statistical Charts and Graphs

    Advanced Statistical Charts and Graphs


        Hands-on Exercises 1-4

        Capstone Exercise

        Mini-Cases 1-3

        (Content Application, Disaster Recovery, Research)


Chapter 6 - Customizing a Slideshow



    Color Schemes

    Custom Template

    Custom Animation

    Create a Custom Show

    Hidden Slides



        Hands-on Exercises 1-4

        Capstone Exercise

        Mini-Cases 1-3

        (Content Application, Disaster Recovery, Research)


Chapter 7 - Saving a Web Page and Adding Interactivity




    Web Pages


        Hands-on Exercises 1-4

        Capstone Exercise

        Mini-Cases 1-3

        (Content Application, Disaster Recovery, Research)


Chapter 8 - Collaborating with Others



    Merge and Compare

    Package for CD



        Hands-on Exercises 1-4

        Capstone Exercise

        Mini-Cases 1-3

        (Content Application, Disaster Recovery, Research)


Dr. Robert T. Grauer

Dr. Robert T. Grauer is an Associate Professor in the Department of Computer Information Systems at the University of Miami, where he has been honored with the Outstanding Teacher Award in the School of Business.  He is the vision behind the Exploring Series, which is about to sell its 3 millionth copy.


Dr. Grauer has written more than 50 books on programming and information systems.  His work has been translated into three foreign languages and is used in all aspects of higher education at both national and international levels.


Dr. Grauer also has been a consultant to several major corporations including IBM and American Express.  He received his Ph.D. in operations research in 1972 from the Polytechnic Institute of Brooklyn.


Judith Scheeren

Judith Scheeren is a professor of computer technology at Westmoreland County Community College in Youngwood, Pennsylvania where she received the Outstanding Teacher award.  She holds an M.S.I.S. She holds an M.S. from the University of Pittsburgh and an advanced certificate in online teaching and learning from the University of California at Hayward.  She has several years of experience in the computer industry with Fortune 500 companies.  She has developed and written training materials for custom applications in both the public and private sectors.  She also has written books on desktop publishing.


Maurie Wigman Lockley

Maurie Wigman Lockley teaches desktop applications and management information systems classes at the University of North Carolina Greensboro.  She has been an instructor there since 1990.


She lives in a tiny piedmont North Carolina town with her husband, daughter, and two preschool-aged grandsons.  She spends her free time playing with the boys, reading, camping, playing computer games, and singing.  She serves on several not-for-profit boards and is active at her church.


Michelle Hulett

Michelle Hulett received a B.S. degree in CIS from the University of Arkansas and a M.B.A. from Missouri State University.  She has worked for various organizations as a programmer, network administrator, computer literacy coordinator, and educator.  She currently teaches computer literacy and Web design classes at Missouri State University.


When not teaching or writing, she enjoys flower gardening, traveling (Alaska and Hawaii are favorites), hiking, canoeing, and camping with her husband, John, and dog, Dakota.


Cynthia Krebs

Cynthia Krebs is a professor in the Digital Media Department at Utah Valley State College, where she has taught since 1988.  In addition to teaching classes in basic computer proficiency using Microsoft Office, she teaches classes in business presentations, business graphics, and an introduction to multimedia.  She has received the Teacher-of-the-Year Award in the School of Business twice during her tenure at UVSC.


She has written chapters for many texts, co-authored a text on advanced word processing, and has presented locally and nationally.  A graduate of Utah State University, Cynthia lives in Springville, Utah.


She has four children and one granddaughter.  When she isn't teaching or writing, she enjoys spending time with her children and spoiling her granddaughter.

Instructor Resources