Master your Minecraft
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Tour our stores


    Recently Viewed clear list


    Best Books of the Year | December 7, 2014

    Gigi Little: IMG Best Kids' Books of 2014



    No, I'm sorry, it's impossible. The best kids' books of 2014? The best? Can't do it. There have been entirely too many exceptional examples of the... Continue »
    1. $11.87 Sale Board Book add to wish list

      Countablock

      Christopher Franceschelli and Peskimo 9781419713743

    spacer
Qualifying orders ship free.
$94.00
List price: $140.35
Used Spiral
Ships in 1 to 3 days
Add to Wishlist
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
3 Partner Warehouse General- General

This title in other editions

Exploring Microsoft Office 2007, Volume 2 (08 Edition)

by

Exploring Microsoft Office 2007, Volume 2 (08 Edition) Cover

 

Synopses & Reviews

Please note that used books may not include additional media (study guides, CDs, DVDs, solutions manuals, etc.) as described in the publisher comments.

Publisher Comments:

The Exploring series helps students master the "How and Why" of performing tasks in Office to gain a greater understanding of how to use the individual applications together to solve business problems. Exploring titles feature “Perfect pages” where every step of every hands-on exercise as well as every end-of-chapter problem begins on a new page and has its own screen shot to make it easier to follow. Each chapter contains Hands-on Exercises, Capstone Exercises, and Mini-Cases for practicing and reviewing skills acquired. Exploring Microsoft Office 2007 Volume 2, 1/e covers intermediate and advanced-level features of Word, Excel, Access, and PowerPoint. Ideal for anyone looking to advance their Microsoft Office skills.

 

Synopsis:

< P style="MARGIN: 0px"> < B> < /B> The Exploring series helps students master the "How and Why" of performing tasks in Office to gain a greater understanding of how to use the individual applications together to solve business problems. Exploring titles feature & #8220; Perfect pages& #8221; where every step of every hands-on exercise as well as every end-of-chapter problem begins on a new page and has its own screen shot to make it easier to follow. Each chapter contains Hands-on Exercises, Capstone Exercises, and Mini-Cases for practicing and reviewing skills acquired.< B> < /B> < I> Exploring Microsoft Office 2007 Volume 2, 1/e< /I> covers intermediate and advanced-level features of Word, Excel, Access, and PowerPoint. < B> < /B> Ideal for anyone looking to advance their Microsoft Office skills. < /P> < P style="MARGIN: 0px"> < I> & nbsp; < /I> < /P>

Synopsis:

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 eduaction. If you would like to purchase the full test without customization, please use

About the Author

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.

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

 

    Summary

    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

    Columns

        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

 

    Summary

    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

 

 

    Summary

    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

 

    Summary

    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

 

    Summary

    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

 

    Summary         

    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

 

    Summary

    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

 

    Summary

    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:

 

    Summary

    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

 

    Summary

    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

 

    Summary

    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

 

    Summary

    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:

 

    Summary

    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

 

    Summary

    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

 

    Summary

    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

 

    Masters

    Color Schemes

    Custom Template

    Custom Animation

    Create a Custom Show

    Hidden Slides

    Macros

 

        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

 

    Hyperlinks

    Buttons

    Web Pages

 

        Hands-on Exercises 1-4

        Capstone Exercise

        Mini-Cases 1-3

        (Content Application, Disaster Recovery, Research)

 

Chapter 8 — Collaborating with Others

 

    Comments

    Merge and Compare

    Package for CD

    Broadcast

 

        Hands-on Exercises 1-4

        Capstone Exercise

        Mini-Cases 1-3

        (Content Application, Disaster Recovery, Research)

Product Details

ISBN:
9780136130376
Author:
Grauer, Robert
Publisher:
Prentice Hall
Author:
Scheeren, Judy
Author:
Krebs, Cyndi
Author:
Krebs, Cynthia
Author:
Hulett, Michelle
Author:
Lockley, Maurie
Author:
Grauer, Robert T.
Author:
Barber, Maryann
Subject:
Business Software - MSOffice
Subject:
Business Software - General
Copyright:
Edition Description:
Trade paper
Series:
Exploring Series Exploring
Publication Date:
June 2007
Binding:
Paperback
Grade Level:
College/higher education:
Language:
English
Illustrations:
Y
Pages:
1296
Dimensions:
11.07x9.23x1.58 in. 5.72 lbs.

Related Subjects

Computers and Internet » Networking » General
Education » Writing
History and Social Science » Economics » General
Languages » ESL » General
Science and Mathematics » Biology » Genetics

Exploring Microsoft Office 2007, Volume 2 (08 Edition) Used Spiral
0 stars - 0 reviews
$94.00 In Stock
Product details 1296 pages Prentice Hall - English 9780136130376 Reviews:
"Synopsis" by , < P style="MARGIN: 0px"> < B> < /B> The Exploring series helps students master the "How and Why" of performing tasks in Office to gain a greater understanding of how to use the individual applications together to solve business problems. Exploring titles feature & #8220; Perfect pages& #8221; where every step of every hands-on exercise as well as every end-of-chapter problem begins on a new page and has its own screen shot to make it easier to follow. Each chapter contains Hands-on Exercises, Capstone Exercises, and Mini-Cases for practicing and reviewing skills acquired.< B> < /B> < I> Exploring Microsoft Office 2007 Volume 2, 1/e< /I> covers intermediate and advanced-level features of Word, Excel, Access, and PowerPoint. < B> < /B> Ideal for anyone looking to advance their Microsoft Office skills. < /P> < P style="MARGIN: 0px"> < I> & nbsp; < /I> < /P>
"Synopsis" by ,

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 eduaction. If you would like to purchase the full test without customization, please use

spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.