2007 Microsoft Office System Inside Out

Jim Boyce

Jeff Conrad

Mark Dodge

Stephanie Krieger

Mary Millhollon

Katherine Murray

S. E. Slack

Beth Sheresh

Doug Sheresh

Craig Stinson

John Viescas

John Pierce,
Contributing Editor

Microsoft

PUBLISHED BY
Microsoft Press
A Division of Microsoft Corporation
One Microsoft Way
Redmond, Washington 98052-6399

© 2007 by Microsoft Corporation

9780735623248

All rights reserved. No part of the contents of this book may be reproduced or transmitted in any form or by any means without the written permission of the publisher.

Library of Congress Control Number: 2006937710

1 2 3 4 5 6 7 8 9 QWT 2 1 0 9 8 7

Distributed in Canada by H.B. Fenn and Company Ltd.

A CIP catalogue record for this book is available from the British Library.

Microsoft Press books are available through booksellers and distributors worldwide. For further information about international editions, contact your local Microsoft Corporation office or contact Microsoft Press International directly at fax [phone]. Visit our Web site at www.microsoft.com/mspress. Send comments to [e-mail].

Microsoft, Microsoft Press, Active Directory, ActiveX, AutoSum, Cambria, DirectX, Excel, FrontPage, Groove, Hotmail, InfoPath, IntelliMouse, Internet Explorer, Jscript, MSDN, MSN, OneNote, Outlook, PivotChart, PivotTable, PowerPoint, Rushmore, Segoe, SharePoint, SmartArt, SQL Server, Visio, Visual Basic, Visual Studio, Windows, Windows Media, Windows Mobile, Windows NT, Windows Server, and Windows Vista are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. Other product and company names mentioned herein may be the trademarks of their respective owners.

The example companies, organizations, products, domain names, e-mail addresses, logos, people, places, and events depicted herein are fictitious. No association with any real company, organization, product, domain name, e-mail address, logo, person, place, or event is intended or should be inferred. This book expresses the author’s views and opinions. The information contained in this book is provided without any express, statutory, or implied warranties. Neither the authors, Microsoft Corporation, nor its resellers, or distributors will be held liable for any damages caused or alleged to be caused either directly or indirectly by this book.

• Acquisitions Editor: Juliana Aldous Atkinson

• Developmental Editor: Sandra Haynes

• Project Editor: Lisa Culver-Jones

• Editorial Production Vendor: Publishing.com

• Indexer: Rebecca Plunkett

• Technical Reviewer: Rozanne Murphy Whalen

• Copy Editor: Kim Wimpsett

• Proofreader: Andrea Fox

Body Part No. X12-65176

About the Authors

Jim Boyce has been a freelance author and consultant for almost 20 years. He has authored and coauthored more than 50 books on computer operating systems, hardware, and applications. Jim is a former contributing editor for Windows Magazine and a frequent contributor to Microsoft.com, techrepublic.com, the Office Letter (www.officeletter.com), and other print and online publications.

Jeff Conrad has written and assisted with technical articles about Microsoft Access and created several Access add-ins that are provided freely to the Access community. He has been awarded Microsoft’s Most Valuable Professional award for his continual involvement with the online Access community. Jeff is active in the Microsoft-sponsored Access public newsgroups and several other online forums where he is best known as the Access Junkie.

Mark Dodge started using spreadsheet programs in a corporate accounting office in 1985, began working in computer publishing in 1988, and has since written or edited more than two dozen books for Microsoft Press. Mark, an accomplished musician and award-winning photographer, lives with his wife on a beautiful island in Puget Sound, Washington.

Stephanie Krieger is a Microsoft Office System MVP and author of the book Microsoft Office Document Designer. A New York City-based consultant, she has helped many global companies develop enterprise solutions for Microsoft Office and taught numerous professionals and professional software trainers to build great documents by understanding the way that Microsoft Office programs “think.”

Mary Millhollon, a certified expert-level Microsoft Office User Specialist in Word, is the owner of Bughouse Productions and a bona fide computer geek. Mary is a freelance writer, editor, Web designer, and Internet expert, working daily (and nightly) with desktop applications and online technologies. Her most recent publication is Easy Web Page Creation (Microsoft Press).

Katherine Murray is the author of many books on technology, with a special emphasis on Microsoft Office. Her most recent book, First Look 2007 Microsoft Office System (Microsoft Press, 2006) is available as a free download on the 2007 Microsoft Office download site. Katherine is the coauthor of Microsoft Office Word 2007 Inside Out and MSN Spaces: Share Your Story. She publishes a blog, called BlogOffice, that offers tips, updates, news, and resources related to a variety of Microsoft Office versions and events.

John Pierce is a freelance writer and editor. He worked as an editor and writer at Microsoft Corporation for nearly 12 years. He is the author of Microsoft Office Access 2003 Inside Track (with Paul Pardi) and the coauthor of Microsoft Small Business Kit and other books about Microsoft software.

Beth Sheresh (CNE) has more than 15 years of computer industry experience, including writing and editing technical books; network administration and consulting; and technical training design, development, and delivery. Beth’s books include Understanding Directory Services (two editions) and Microsoft Windows NT Server Administrators Bible-Option Pack Edition. She also contributed chapters to Microsoft Windows Server 2003 Inside Out.

Doug Sheresh (MCSE) is an IT professional with over two decades of experience that encompasses network administration, consulting, technical support management, and managing technical writing projects. His expertise includes all aspects of technical training course development. He was the lead technical writer of the Microsoft Windows 95 Resource Kit and coauthor of Understanding Directory Services, 2nd Edition and Microsoft Windows NT Server Administrators Bible-Option Pack Edition.

Sally Slack is a writer and author with more than 16 years of experience in business and technical writing. She has also been an executive and business transformation communications consultant to IBM, Lenovo International, and State Farm Insurance, and she routinely writes for Microsoft, IBM, Sony, and other companies. She is a regular contributor to a variety of Microsoft Web sites, including Microsoft At Home and Work Essentials.

Craig Stinson, an industry journalist since 1981, was editor of Softalk for the IBM Personal Computer, one of the earliest machine-specific computer magazines. He is the author of more than 20 Microsoft Press books about Microsoft Windows and Excel. Craig lives with his wife and two children in Bloomington, Indiana.

John L. Viescas is the author of Microsoft Office Access 2003 Inside Out and the popular Running Microsoft Access books from Microsoft Press. He is president of Viescas Consulting, Inc., a respected provider of database application design and editorial consulting services. He has been recognized by Microsoft Product Support Services as a Most Valuable Professional (MVP) every year since 1993 for his contributions to the community of Access users.

Acknowledgments

Thanks first and foremost to the authors who contributed their expertise to this book: Jim Boyce, jeff Conrad, Mark Dodge, Stephanie Krieger, Mary Millhollon, Katherine Murray, Beth Sheresh and Doug Sheresh, Sally Slack, Craig Stinson, and John Viescas. Deep appreciation also goes to Lisa Culver-Jones, the book’s project editor, and to Curt Philips and his associates, who gracefully and professionally handled the effort required to edit and produce this book. Thanks finally to friends and colleagues at Microsoft Press, especially Juliana Aldous Atkinson, Sandra Haynes, Lucinda Rowley, and Sally Stickney.

Your All-in-One Resource

On the CD that accompanies this book, you’ll find additional resources to extend your learning.

The reference library includes the following fully searchable titles:

• Microsoft Computer Dictionary, 5th ed.

• First Look 2007 Microsoft Office System by Katherine Murray

• Windows Vista Product Guide

Also provided are a sample chapter and poster from Look Both Ways: Help Protect Your Family on the Internet by Linda Criddle.

The CD interface has a new look. You can use the tabs for an assortment of tasks:

• Check for book updates (if you have Internet access)

• Install the book’s sample files

• Find links to helpful tools and resources

• Go online for product support or CD support

• Send us feedback

The following screen shot gives you a glimpse of the new interface.