Special Edition Using Microsoft Office Excel 2007 (Adobe Reader)

This is the eBook version of the printed book. Special Edition Using Microsoft® Office 2007 THE ONLY OFFICE BOOK YOU NEED We crafted this book to grow with you, providing the reference material you need as you move toward Office proficiency and use of more advanced features. If you buy only one book on Office 2007, Special Edition Using Microsoft® Office 2007 is the only book you need. If you own a copy of Office 2007, you deserve a copy of this book! Although this book is aimed at the Office veteran, Ed and Woody’s engaging style will appeal to beginners, too. Written in clear, plain English, readers will feel as though they are learning from real humans and not Microsoft clones. Sprinkled with a wry sense of humor and an amazing depth of field, this book most certainly isn’t your run-of-the-mill computer book. You should expect plenty of hands-on guidance and deep but accessible reference material. This isn’t your Dad’s Office! For the first time in a decade, Microsoft has rolled out an all-new user interface. Menus? Gone. Toolbars? Gone. For the core programs in the Office family, you now interact with the program using the Ribbon–an oversize strip of icons and commands, organized into multiple tabs, that takes over the top of each program’s interface. If your muscles have memorized Office menus, you’ll have to unlearn a lot of old habits for this version. Ed Bott is an award-winning computer journalist and one of the most widely recognized voices in the computing world, with nearly two decades of experience as a writer and editor at leading magazines, such as PC World, PC Computing, and Smart Business. Ed has written many of Que’s all-time bestsellers, including Special Edition Using Office 2000, Special Edition Using Windows 98, and Special Edition Using Windows Me. Curmudgeon, critic, and perennial “Office Victim,” Woody Leonhard runs the fiercely independent AskWoody.com website with up-to-the-nanosecond news, observations, tips and help for both Office and Windows. In the past 15 years, Woody has written more than three dozen books, drawing an unprecedented six Computer Press Association awards and two American Business Press awards. Woody was one of the first Microsoft Consulting Partners and is a charter member of the Microsoft Solutions Provider organization. Introduction I Common Tasks and Features 1 Getting Started with Office 2007 . . . . . . . . . . . . . . . . . . . . 9 2 Using and Customizing the Office 2007 Interface . . 27 3 Managing Office Files and Formats . . . . . . . . . . . . . . . . 53 4 Creating, Editing, and Formatting Documents . . . . . 75 5 Creating, Editing, and Using Pictures and Graphics . . . 103 6 Sharing and Reviewing Office Files . . . . . . . . . . . . . . . 135 7 Office Security and Privacy . . . . . . . . . . . . . . . . . . . . . . . . 159 II Using Outlook 8 Outlook Essentials . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 177 9 Reading, Writing, and Organizing Email . . . . . . . . . . 219 10 Keeping Your Contacts List Under Control . . . . . . . 259 ...

Every business professional faces challenges in managing their time to be as efficient and productive as possible. Information management has become an important everyday task in helping manage these challenges successfully, and Microsoft Outlook is the gold standard to help users stay organized. Outlook not only helps manage contacts, appointments, and tasks, it also serves as the e-mail and fax client. Outlook 2007 has been redesigned and improved with a new user interface, electronic business cards, RSS support, smart scheduling, anti-phishing capabilities, junk e-mail filter, and more. Case study sections called Improving Your Outlook illustrate how to apply the information learned in real-world situations. Troubleshooting sections in each chapter illustrate common problems that occur when using Outlook, followed by a detailed solution. With this book, you learn the latest features and improvements in Outlook by focusing on user productivity through real-world techniques in real-world environments.

 

Introduction

I Setting Up and Configuring Outlook

1 What’s New in Outlook . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9

2 Getting Started and Getting Help . . . . . . . . . . . . . . . . . . . 25

3 Managing Outlook Folders . . . 39

4 Creating Views and Print Styles . . . . . . . . . . . . . . . . . . . . . 79

5 Customizing Command Bars . . 117

II Outlook as a Personal Information Manager

6 Managing Personal Information

Using Outlook . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 139

7 Creating and Using Categories . . . . . . . . . . . . . 145

8 Customizing Outlook Today . . . 161

9 Creating Contacts . . . . 179

10 Working with Contacts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 207

11 Address Books and Directory Services . . . . . . . . . . . . 247

12 Using the Outlook Calendar . . . . . . . . . . . . . . . . . . . . . . . 257

13 Collaborating with Calendars . . . . . . . . . . . . . . . . . . . . . . 301

14 Working with Tasks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 321

15 Staying Organized with the Outlook Journal . . . . . 349

16 Using Outlook Notes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 367

III Outlook as a Mail Client

17 Working with Mail Accounts . . . . . . . . . . . . . . . . . . . . . . . 379

18 Creating New Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . 407

19 Receiving Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 435

20 Using Templates . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 463

21 Setting Outlook Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . 475

22 Finding and Organizing Outlook Items . . . . . . . . . . . . 511

23 Importing, Exporting, and Backing Up

Outlook Information . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 537

24 Compacting and Archiving Items . . . . . . . . . . . . . . . . . . 561

25 Using Outlook Securely . . . . . . . . . . . . . . . . . . . . . . . . . . . . 583

IV Outlook as the Client for Exchange Server

26 Using Outlook as an Exchange Client . . . . . . . . . . . . . 621

27 Creating and Using Rules . . . . . . . . . . . . . . . . . . . . . . . . . . 651

28 Advanced Exchange Options . . . . . . . . . . . . . . . . . . . . . . 683

29 Exchange Public Folders . . . . . . . . . . . . . . . . . . . . . . . . . . . 695

30 Working Remotely with Exchange Server . . . . . . . . . 721

31 Advances with Outlook and Exchange

Server 2007 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 747

V Programming and Advanced Outlook Topics

32 Creating and Using Custom Forms . . . . . . . . . . . . . . . . 757

33 Using VBA in Outlook . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 795

34 Advanced Outlook Programming Topics . . . . . . . . . . 819

35 Business Contact Manager . . . . . . . . . . . . . . . . . . . . . . . . . 833

36 Reading RSS Feeds in Outlook . . . . . . . . . . . . . . . . . . . . 879

VI Appendices

A Installing Outlook 2007 . . . . . . . . . . . . . . . . . . . . . . . . . . . . 897

B Using the Office Resource Kit . . . . . . . . . . . . . . . . . . . . . . 907

C Outlook’s Files, Folders, and Registry Keys . . . . . . . 915

D Outlook’s Resources . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 921

E Working with the Windows Registry . . . . . . . . . . . . . . 927

F Outlook Shortcut Keys . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 939

G Outlook Fields and Equivalent Properties . . . . . . . . 951

Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 961

 

Every business professional faces challenges in managing their time to be as efficient and productive as possible. Information management has become an important everyday task in helping manage these challenges successfully, and Microsoft Outlook is the gold standard to help users stay organized. Outlook not only helps manage contacts, appointments, and tasks, it also serves as the e-mail and fax client. Outlook 2007 has been redesigned and improved with a new user interface, electronic business cards, RSS support, smart scheduling, anti-phishing capabilities, junk e-mail filter, and more. Case study sections called "Improving Your Outlook" illustrate how to apply the information learned in real-world situations. Troubleshooting sections in each chapter illustrate common problems that occur when using Outlook, followed by a detailed solution. With this book, you learn the latest features and improvements in Outlook by focusing on user productivity through real-world techniques in real-world environments. Introduction I Setting Up and Configuring Outlook 1 Whats New in Outlook . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 2 Getting Started and Getting Help . . . . . . . . . . . . . . . . . . . 25 3 Managing Outlook Folders . . . 39 4 Creating Views and Print Styles . . . . . . . . . . . . . . . . . . . . . 79 5 Customizing Command Bars . . 117 II Outlook as a Personal Information Manager 6 Managing Personal Information Using Outlook . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 139 7 Creating and Using Categories . . . . . . . . . . . . . 145 8 Customizing Outlook Today . . . 161 9 Creating Contacts . . . . 179 10 Working with Contacts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 207 11 Address Books and Directory Services . . . . . . . . . . . . 247 12 Using the Outlook Calendar . . . . . . . . . . . . . . . . . . . . . . . 257 13 Collaborating with Calendars . . . . . . . . . . . . . . . . . . . . . . 301 14 Working with Tasks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 321 15 Staying Organized with the Outlook Journal . . . . . 349 16 Using Outlook Notes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 367 III Outlook as a Mail Client 17 Working with Mail Accounts . . . . . . . . . . . . . . . . . . . . . . . 379 18 Creating New Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . 407 19 Receiving Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 435 20 Using Templates . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 463 21 Setting Outlook Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . 475 22 Finding and Organizing Outlook Items . . . . . . . . . . . . 511 23 Importing, Exporting, and Backing Up Outlook Information . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 537 24 Compacting and Archiving Items . . . . . . . . . . . . . . . . . . 561 25 Using Outlook Securely . . . . . . . . . . . . . . . . . . . . . . . . . . . . 583 IV Outlook as the Client for Exchange Server 26 Using Outlook as an Exchange Client . . . . . . . . . . . . . 621 27 Creating and Using Rules . . . . . . . . . . . . . . . . . . . . . . . . . . 651 28 Advanced Exchange Options . . . . . . . . . . . . . . . . . . . . . . 683 29 Exchange Public Folders . . . . . . . . . . . . . . . . . . . . . . . . . . . 695 30 Working Remotely with Exchange Server . . . . . . . . . 721 31 Advances with Outlook and Exchange Server 2007 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 747 V Programming and Advanced Outlook Topics 32 Creating and Using Custom Forms . . . . . . . . . . . . . . . . 757 33 Using VBA in Outlook . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 795 34 Advanced Outlook Programming Topics . . . . . . . . . . 819 35 Business Contact Manager . . . . . . . . . . . . . . . . . . . . . . . . . 833 36 Reading RSS Feeds in Outlook . . . . . . . . . . . . . . . . . . . . 879 VI Appendices A Installing Outlook 2007 . . . . . . . . . . . . . . . . . . . . . . . . . . . . 897 B Using the Office Resource Kit . . . . . . . . . . . . . . . . . . . . . . 907 C Outlooks Files, Folders, and Registry Keys . . . . . . . 915 D Outlooks Resources . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 921 E Working with the Windows Registry . . . . . . . . . . . . . . 927 F Outlook Shortcut Keys . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 939 G Outlook Fields and Equivalent Properties . . . . . . . . 951 Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 961

THE ONLY WORD 2007 BOOK YOU NEED

This book will help you build solid skills to create the documents you need right now, and expert-level guidance for leveraging Word’s most advanced features whenever you need them. If you buy only one book on Word 2007, Special Edition Using Microsoft Office Word 2007 is the book you need.

• Come up to speed quickly with the new Word 2007 Ribbon interface

• Streamline document formatting with styles, templates, and themes

• Collaborate with others using comments and tracked changes

• Master mail merges, master documents, and other advanced features

• Manage large documents with indexes, TOCs, and automatically numbered references

• Use fields and forms to collect and manage information

• Illustrate key concepts with SmartArt diagrams

• Create and apply custom themes that control fonts, color schemes, and effects

• Manage academic research citations and generate bibliographies in any popular documentation format

On the Web

Includes complete instructions and a command reference you can use to customize the Ribbon with RibbonX, even if you have little or no previous XML experience. You can also download additional RibbonX examples and an easy-to-use RibbonCustomizer utility from this book’s companion web site, quepublishing.com/usingword2007.

Contents

About the Authors xxx

Introduction 1

Part I Working with Text Documents

Chapter 1Introducing Word 2007 7

Chapter 2 Creating and Saving Documents 27

Chapter 3 Typing and Editing Text 59

Chapter 4 Using Spelling, Grammar, and Research Tools 95

Chapter 5 Printing and Faxing Documents 133

Part II Formatting a Document

Chapter 6 Applying Character Formatting 155

Chapter 7 Formatting Paragraphs and Lists 191

Chapter 8 Creating and Applying Styles and Themes 227

Chapter 9 Formatting Documents and Sections 263

Chapter 10 Using and Creating Project Templates 297

Chapter 11 Working with Nonstandard Document Layouts 319

Part III Tables and Graphics

Chapter 12 Creating and Formatting Tables 353

Chapter 13 Working with Photos 395

Chapter 14 Working with Clip Art and the Clip Organizer 425

Chapter 15 Working with Drawings and WordArt 455

Chapter 16 Working with Charts 491

Chapter 17 'Working with SmartArt and Math Formulas 533

Part IV Collecting and Managing Data

Chapter 18 Performing Mail and Data Merges 563

Chapter 19 Copying, Linking, and Embedding Data 601

Chapter 20 Working with Fields 631

Chapter 21 Creating Forms 655

Part V Long Documents

Chapter 22 Outlining and Summarizing Documents 681

Chapter 23 Using Master Documents 703

Chapter 24 Citing Sources and References 719

Chapter 25 Creating Tables of Contents and Other Listings 747

Chapter 26 Building Effective Indexes 765

Part VI Collaboration and Online Sharing

Chapter 27 Collaborating with Others 783

Chapter 28 Protecting and Securing Documents 805

Chapter 29 Online Collaboration with Office Live and SharePoint Team Services 823

Chapter 30 Working with Blogs and Email 847

Chapter 31 Developing Web Content 857

Chapter 32 Using Word to Develop XML Content 875

Part VII Customizing and Extending Word

Chapter 33 Macros and Add-Ins 905

Chapter 34 Customizing the Word Interface 935

Chapter 35 Customizing Word 2007’s Ribbon with RibbonX 945

Part VIII Appendixes

Appendix A Recovering Files and Repairing Word 975

Appendix B Converting from Other Word Processing Systems 985

Appendix C Accessibility Tips and Techniques 991

Appendix D Command Reference: Word 2003 to Word 2007 999

Appendix E Setting Up and Modifying Office 2007 1017

Index 1025

<>This book offers you comprehensive, information on using the new version of Access. Not only updated for the latest version, new chapters have been added on application automation with Access macros and collaboration with Microsoft SharePoint Team Server, both of which are hot topics. All chapters are updated for the transition from Jet to the new Access database engine. Detailed, step-by-step instructions with icons guide you through Access through table design, data addition, importing data from external sources, query design and execution, and designing data entry forms and printed reports.

FM

Introduction

I Getting Acquainted with Access 2007

1 Access 2007 for Access 200x Users: What’s New

2 Building Simple Tracking Applications

3 Navigating the New Access User Interface

II Learning the Fundamentals of Access

Databases

4 Exploring Relational Database Theory and Practice

5 Working with Access Databases and Tables

6 Entering, Editing, and Validating Access Table Data

7 Sorting, Finding, and Filtering Data

8 Linking, Importing, and Exporting Data

III Transforming Data with Queries and

PivotTables

9 Designing Queries for Access Databases

10 Understanding Access Operators and Expressions

11 Creating Multitable and Crosstab Queries

12 Working with PivotTable and PivotChart Views

13 Creating and Updating Access Tables with Action

Queries

IV Designing Forms and Reports

14 Creating and Using Basic Access Forms

15 Designing Custom Multitable Forms

16 Working with Simple Reports and Mailing Labels

17 Preparing Advanced Reports

18 Adding Graphs, PivotCharts, and PivotTables

V Moving to Networked Multiuser Applications

19 Linking Access Front Ends to Access and

Client/Server Tables

20 Exploring Access Data Projects and SQL

Server 2005

21 Moving from Access Queries to Transact-SQL

22 Upsizing Access Applications to Access Data

Projects

VI Collaborating with Access Data

23 Importing and Exporting Web Pages

24 Integrating with XML and InfoPath 2007

25 Collaborating with Windows SharePoint Services

VII Programming and Converting Access

Applications

26 Automating Access Applications with Macros 2007

27 Learning Visual Basic for Applications

28 Handling Events with VBA and Macros

29 Programming Combo and List Boxes

30 Understanding Data Access Objects, OLE DB,

and ADO

31 Upgrading 200X Applications to Access 2007

VIII Appendix

A Glossary

Index

Special Edition Using Microsoft Office Excel 2007 will ease the upgrade path to the lastest version of Microsoft best-selling spreadsheet program. The author,'Mr. Excel'introduces you to the new interface, allowing you to quickly get back up-to-speed in performing your job, and will then introduce the powerful new features available in Excel 2007. Among other skills, you will learn how to create amazing data visualizations using conditional formatting and in-cell data bars. This is the only book you need on Microsoft Office Excel 2007! “ Excel 2007 is the biggest, most exciting release of Excel ever. This book's straightforward approach explains the most important features of Excel 2007 in a thorough, easy-to-understand format. Further, it clearly compares older versions of Excel with Excel 2007, which makes for a seamless transition to this newest version of the program. It is a must-have desk reference for today's business professional.” —David Gainer, Group Program Manager, Microsoft Excel THE ONLY EXCEL BOOK YOU NEED We crafted this book to grow with you, providing the reference material you need as you move toward Excel proficiency and use of more advanced features. If you buy only one book on Excel, Special Edition Using Microsoft® Office Excel® 2007 is the book you need. Does your life play out in a spreadsheet? Do numbers in columns and rows make or break you in the work world? Tired of having numbers kicked in your face by other Excel power users who make your modest spreadsheets look paltry compared to their fancy charts and pivot tables? If you answered yes to any of these questions, Special Edition Using Microsoft® Office Excel® 2007 is the bookthat will make it all better. Learn quickly and efficientlyfrom a true Excel master using the tried and true SpecialEdition Using formula for success. Here, you'll findinformation that's undocumented elsewhere—even inMicrosoft's own Help systems. You'll learn from finelycrafted, real-life examples built by an author who livesand dies by the integrity of his spreadsheets. Excel's backbone is its formulas and functions. Master those and you will master your spreadsheets. Special Edition Using Microsoft Office® Excel® 2007 provides more down and dirty help with your formulas and functions than you'll find in any other book! See how it's done in real life! Don't settle for lame pivot table and chart examples found in other books... This book provides beautifully detailed examples that not only show you how it should be done, but how to be the local worksheet hero! Special Edition Using Microsoft Office Excel 2007 will ease the upgrade path to the lastest version of Microsoft best-selling spreadsheet program. The author, "Mr. Excel " introduces you to the new interface, allowing you to quickly get back up-to-speed in performing your job, and will then introduce the powerful new features available in Excel 2007. Among other skills, you will learn how to create amazing data visualizations using conditional formatting and in-cell data bars. This is the only book you need on Microsoft Office Excel 2007! “Excel 2007 is the biggest, most exciting release of Excel ever. This book’s straightforward approach explains the most important features of Excel 2007 in a thorough, easy-to-understand format. Further, it clearly compares older versions of Excel with Excel 2007, which makes for a seamless transition to this newest version of the program. It is a must-have desk reference for today’s business professional.”–David Gainer,Group Program Manager,Microsoft ExcelTHE ONLY EXCEL BOOK YOU NEEDWe crafted this book to grow with you, providing the reference material you need as you move toward Excel proficiency and use of more advanced features. If you buy only one book on Excel, Special Edition Using Microsoft® Office Excel® 2007 is the book you need.Does your life play out in a spreadsheet? Do numbers in columns and rows make or break you in the work world? Tired of having numbers kicked in your face by other Excel power users who make your modest spreadsheets look paltry compared to their fancy charts and pivot tables?If you answered yes to any of these questions, Special Edition Using Microsoft® Office Excel® 2007 is the bookthat will make it all better. Learn quickly and efficientlyfrom a true Excel master using the tried and true SpecialEdition Using formula for success. Here, you’ll findinformation that’s undocumented elsewhere–even inMicrosoft’s own Help systems. You’ll learn from finelycrafted, real-life examples built by an author who livesand dies by the integrity of his spreadsheets.Excel’s backbone is its formulas and functions. Master those and you will master your spreadsheets. Special Edition Using Microsoft Office® Excel® 2007 provides more down and dirty help with your formulas and functions than you’ll find in any other book! See how it’s done in real life! Don’t settle for lame pivot table and chart examples found in other books... This book provides beautifully detailed examples that not only show you how it should be done, but how to be the local worksheet hero! Special Edition Using Microsoft Office Excel 2007 will ease the upgrade path to the lastest version of Microsoft best-selling spreadsheet program. The author, "Mr. Excel " introduces you to the new interface, allowing you to quickly get back up-to-speed in performing your job, and will then introduce the powerful new features available in Excel 2007. Among other skills, you will learn how to create amazing data visualizations using conditional formatting and in-cell data bars. This is the only book you need on Microsoft Office Excel 2007! " Excel 2007 is the biggest, most exciting release of Excel ever. This book's straightforward approach explains the most important features of Excel 2007 in a thorough, easy-to-understand format. Further, it clearly compares older versions of Excel with Excel 2007, which makes for a seamless transition to this newest version of the program. It is a must-have desk reference for today's business professional."--David Gainer, Group Program Manager, Microsoft Excel THE ONLY EXCEL BOOK YOU NEED We crafted this book to grow with you, providing the reference material you need as you move toward Excel proficiency and use of more advanced features. If you buy only one book on Excel, Special Edition Using Microsoft® Office Excel® 2007 is the book you need. Does your life play out in a spreadsheet? Do numbers in columns and rows make or break you in the work world? Tired of having numbers kicked in your face by other Excel power users who make your modest spreadsheets look paltry compared to their fancy charts and pivot tables? If you answered yes to any of these questions, Special Edition Using Microsoft® Office Excel® 2007 is the bookthat will make it all better. Learn quickly and efficientlyfrom a true Excel master using the tried and true SpecialEdition Using formula for success. Here, you'll findinformation that's undocumented elsewhere-even inMicrosoft's own Help systems. You'll learn from finelycrafted, real-life examples built by an author who livesand dies by the integrity of his spreadsheets. Excel's backbone is its formulas and functions. Master those and you will master your spreadsheets. Special Edition Using Microsoft Office® Excel® 2007 provides more down and dirty help with your formulas and functions than you'll find in any other book! See how it's done in real life! Don't settle for lame pivot table and chart examples found in other books ... This book provides beautifully detailed examples that not .. THE ONLY WORD 2007 BOOK YOU NEED This book will help you build solid skills to create the documents you need right now, and expert-level guidance for leveraging Word's most advanced features whenever you need them. If you buy only one book on Word 2007, Special Edition Using Microsoft Office Word 2007 is the book you need. • Come up to speed quickly with the new Word 2007 Ribbon interface • Streamline document formatting with styles, templates, and themes • Collaborate with others using comments and tracked changes • Master mail merges, master documents, and other advanced features • Manage large documents with indexes, TOCs, and automatically numbered references • Use fields and forms to collect and manage information • Illustrate key concepts with SmartArt diagrams • Create and apply custom themes that control fonts, color schemes, and effects • Manage academic research citations and generate bibliographies in any popular documentation format On the Web Includes complete instructions and a command reference you can use to customize the Ribbon with RibbonX, even if you have little or no previous XML experience. You can also download additional RibbonX examples and an easy-to-use RibbonCustomizer utility from this book's companion web site, www.quepublishing.com/usingword2007. Contents About the Authors xxx Introduction 1 Part I Working with Text Documents Chapter 1 Introducing Word 2007 7 Chapter 2 Creating and Saving Documents 27 Chapter 3 Typing and Editing Text 59 Chapter 4 Using Spelling, Grammar, and Research Tools 95 Chapter 5 Printing and Faxing Documents 133 Part II Formatting a Document Chapter 6 Applying Character Formatting 155 Chapter 7 Formatting Paragraphs and Lists 191 Chapter 8 Creating and Applying Styles and Themes 227 Chapter 9 Formatting Documents and Sections 263 Chapter 10 Using and Creating Project Templates 297 Chapter 11 Working with Nonstandard Document Layouts 319 Part III Tables and Graphics Chapter 12 Creating and Formatting Tables 353 Chapter 13 Working with Photos 395 Chapter 14 Working with Clip Art and the Clip Organizer 425 Chapter 15 Working with Drawings and WordArt 455 Chapter 16 Working with Charts 491 Chapter 17 Working with SmartArt and Math Formulas 533 Part IV Collecting and Managing Data Chapter 18 Performing Mail and Data Merges 563 Chapter 19 Copying, Linking, and Embedding Data 601 Chapter 20 Worki.. This book offers you comprehensive, information on using the new version of Access. Not only updated for the latest version, new chapters have been added on application automation with Access macros and collaboration with Microsoft SharePoint Team Server, both of which are hot topics. All chapters are updated for the transition from Jet to the new Access database engine. Detailed, step-by-step instructions with icons guide you through Access through table design, data addition, importing data from external sources, query design and execution, and designing data entry forms and printed reports. FM Introduction I Getting Acquainted with Access 2007 1 Access 2007 for Access 200x Users: What's New 2 Building Simple Tracking Applications 3 Navigating the New Access User Interface II Learning the Fundamentals of Access Databases 4 Exploring Relational Database Theory and Practice 5 Working with Access Databases and Tables 6 Entering, Editing, and Validating Access Table Data 7 Sorting, Finding, and Filtering Data 8 Linking, Importing, and Exporting Data III Transforming Data with Queries and PivotTables 9 Designing Queries for Access Databases 10 Understanding Access Operators and Expressions 11 Creating Multitable and Crosstab Queries 12 Working with PivotTable and PivotChart Views 13 Creating and Updating Access Tables with Action Queries IV Designing Forms and Reports 14 Creating and Using Basic Access Forms 15 Designing Custom Multitable Forms 16 Working with Simple Reports and Mailing Labels 17 Preparing Advanced Reports 18 Adding Graphs, PivotCharts, and PivotTables V Moving to Networked Multiuser Applications 19 Linking Access Front Ends to Access and Client/Server Tables 20 Exploring Access Data Projects and SQL Server 2005 21 Moving from Access Queries to Transact-SQL 22 Upsizing Access Applications to Access Data Projects VI Collaborating with Access Data 23 Importing and Exporting Web Pages 24 Integrating with XML and InfoPath 2007 25 Collaborating with Windows SharePoint Services VII Programming and Converting Access Applications 26 Automating Access Applications with Macros 2007 27 Learning Visual Basic for Applications 28 Handling Events with VBA and Macros 29 Programming Combo and List Boxes 30 Understanding Data Access Objects, OLE DB, and ADO 31 Upgrading 200X Applications to Access 2007 VIII Appendix A Glossary