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. KEY TOPICS: 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.

Full Product Details

Author:   Robert Grauer ,  Michelle Hulett ,  Cynthia Krebs ,  Maurie Lockley
Publisher:   Pearson Education (US)
Imprint:   Pearson
Dimensions:   Width: 23.40cm , Height: 3.90cm , Length: 28.10cm
Weight:   2.610kg
ISBN:  

9780136130376

ISBN 10:   0136130372
Pages:   1296
Publication Date:   30 August 2007
Audience:   Professional and scholarly ,  Professional & Vocational
Format:   Paperback
Publisher's Status:   Active
Availability:   Available To Order  
We have confirmation that this item is in stock with the supplier. It will be ordered in for you and dispatched immediately.

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)

Reviews

Author Information

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.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions