Exploring Microsoft Office 2007 Volume 2

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)

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.