Exploring Microsoft Office 2007 Volume 2 / Edition 1

Exploring Microsoft Office 2007 Volume 2 / Edition 1

by Robert T. Grauer, Maryann Barber, Keith Mulbery, Cyndi Krebs
     
 

ISBN-10: 0136130372

ISBN-13: 9780136130376

Pub. Date: 09/13/2007

Publisher: Prentice Hall

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

Overview

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.

Product Details

ISBN-13:
9780136130376
Publisher:
Prentice Hall
Publication date:
09/13/2007
Series:
Exploring
Edition description:
New Edition
Pages:
1296
Product dimensions:
9.34(w) x 10.82(h) x 1.61(d)

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

Extensible Markup Language

Hands-On Exercise #3 Introduction to

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)

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >