Exploring Microsoft Office 2007 Volume 2

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.

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)