Pierce J. (ed). 2007 Microsoft Office System: Inside Out

Microsoft Press, 2007. — 1209 с. (на англ. яз.)Подробное официальное руководство от первоисточника (Microsoft) по работе с офисными программами MS Office 2007 - Word, Excel, PowerPoint, Outlook, Access.
In Part 1, "Getting Started," you'll be introduced to the 2007 Microsoft Office system, including a full chapter about the Microsoft Office fluent interface. You'll learn about the security features in the 2007 Office release, including the Trust Center, where you set options for managing your privacy as well as for which macros you will allow to run.In Part 2, "Collaboration Essentials," you'll explore several of the 2007 Office release tools and programs that are designed for collaboration and sharing, including Microsoft Office OneNote 2007 and Microsoft Office Groove 2007. You'll also find an overview of how to use Microsoft Office with Windows SharePoint Services.Part 3 covers Microsoft Office Word 2007, including formatting and layout techniques, outlining, marking up and revising documents, and page setup. On the books' CD, you'll find additional infonnation about working with new features such as document Themes.Part 4 is about Microsoft Office Excel 2007. This part describes techniques for working with worksheets and workbooks, building formulas, using functions, and analyzing data. On the book's CD, you'll find additional information (from the Bonus Chapters tab) about working with charts in Excel and about connecting Excel worksheets to external data.Part 5 covers Microsoft Office PowerPoint 2007, including the basics of creating and formatting a presentation; how to work with text; and how to work with objects, diagrams, and charts in a presentation. This section also provides information about collaborating and sharing PowerPoint presentations and explains how to import or export data to and from your PowerPoint slides. In the last chapter in this section, you'll learn how to set up and present a slide show.Part 6 brings us to Microsoft Office Outlook, an application in which many information workers spend the better parts of their days-reading e-mail, scheduling meetings, and setting up tasks. To start this section you'll read an overview of Office Outlook 2007, it's new features, and its new user interface. In the chapters that follow you'll read about how to manage e-mail, about security features in Outlook 2007, and how to integrate your use of Outlook with Windows SharePoint Services. The Bonus Chapters area of the book's CD will lead you to chapters in which you can learn about managing tasks, meetings, appointments, and contacts in Outlook 2007.In Part 7 of the book, you'll learn about the latest release of Microsoft Office Access. You'll learn in detail about the new Access 2007 user interface, how to create a database and its tables, and how to work with database objects such as queries, forms, and reports. The book's CD includes an additional chapter that teaches you about how to work with Access together with a SharePoint site and an article that covers the fundamentals of database design.The final part of the book, "Office Programming Primer," presents an introduction to Visual Basic for Applications, the programming language you use to automate and extend the functionality of Microsoft Office programs, and a primer on workiing with the Office Open XML Formats, the framework at the heart of the 2007 Office release file formats.About the CD.
What’s on the CD.
Using the CD.
System Requirements.
Support Information.
Conventions and Features Used in This Book.
Text Conventions.
Design Conventions.Who This Book Is ForHow This Book Is Organized.Getting Started.
Overview of the 2007 Microsoft Office System.
The New World of Work.
Collaboration Workspaces and Tools.
Business Intelligence on Your Desktop.
The New Microsoft Office User Interface.
The Ribbon.
Galleries and Live Preview.
The New Microsoft Office XML File Formats.
What Else Is New?
Microsoft Office Word 2007.
Microsoft Office Excel 2007.
Microsoft Office PowerPoint 2007.
Microsoft Office Outlook 2007.
Microsoft Office Access 2007.
2007 Office System Servers.
Templates and Assistance from Microsoft Office Online.Chapter 2: The 2007 Office System User Interface: What’s Changed,
What’s the Same.
A Quick Tour and Comparison.
The Ribbon and Command Tabs.
Customizing the Quick Access Toolbar.
The Microsoft Office Button and Menu.
Working in Context: More Tabs, Plus Some Menus and Toolbars.
Contextual Tabs.
Shortcut Menus and the Mini Toolbar.
Galleries and Live Preview.
Getting Help.
Searching Online Help.Managing Security and Privacy in the 2007 Office System.
Working in the Trust Center.
Digital Signatures and Trusted Publishers.
Using Trusted Locations.
Setting Security Options for Macros and Add-Ins.
Security Settings for ActiveX Controls.
Setting Your Privacy Options.
Removing Hidden Data and Personal Information from Microsoft Office Documents.
Applying Information Rights Management.
Configuring Your Computer to Use Information Rights Management.
Restricting Permissions.
Assigning a Password to a Document.
Changing a Password.
Removing a Password.
Avoiding Phishing Schemes.Collaboration Essentials.
Collaborating and Sharing with Others.
Understanding and Using the 2007 Office System Collaboration Environments.
Creating and Using Shared Workspaces with Windows SharePoint Services.
Understanding the Workspace.
Accessing or Adding Content in a SharePoint Document Library.
Creating or Editing a Windows SharePoint Services Shared Workspace.
Creating and Using Groove Workspaces.
Understanding Your Workspace.
Creating a Workspace.
Inviting Others to Join a Workspace.
Using Office OneNote 2007 as a Collaboration Tool.
Shared Notebooks and Live Sharing Sessions. 89
Organizing and Finding Information in
Microsoft Office OneNote.
Organizing a OneNote Notebook.
Creating a Notebook.
Working in the OneNote Window.
Organizing Notebook Sections.
Adding and Grouping Notebook Pages.
Adding Notes and Information to a Notebook.
Adding and Working with Text Notes.
Tagging Types of Notes.
Printing to OneNote.
Embedding References to Files.
Using Office OneNote and Office Outlook Together.
Inserting Audio or Video Recordings.
Adding Information to a Notebook from the Web.
Capturing Information on Your Windows Mobile–Powered Device.
Inserting an Image in a Notebook.
Creating a Drawing in OneNote.
Creating and Working with Tables in OneNote.
Finding Your Information.
Using a Notebook on More Than One Computer.
Creating a Notebook for Use on More Than One Computer.
Share an Existing Notebook Among Your Computers.
Working as a Team with Office OneNote 2007.
Working with a Shared Notebook.
Protecting a Shared Section.
Sharing an Existing Notebook.
Sharing a Notebook in a Live Session.
Sharing Notes Using E-Mail.Working as a Team in a Microsoft Office Groove Workspace.
Getting Started with Groove.
Setting Up a Groove Account.
The View from the Launchbar.
Groove Workspace Basics.
Creating a Workspace.
Inviting Workspace Members and Assigning Member Roles.
Using Your Groove Account on a Second Computer.
Knowing When Members Are Present and Accounted For.
Chatting with Workspace Members.
Setting Roles and Changing Role Permissions.
Exploring a Groove Workspace.
Outfi tting a Groove Workspace with Tools.
Keeping a Calendar.
Topics Under Discussion.
Making Meetings More Effective.
Storing, Organizing, and Sharing Files. 157 Tracking Issues.
Taking Notes.
Adding Pictures to a Workspace.
Sketching Your Ideas.Sharing and Communicating Using Microsoft Office Groove.
Setting Up and Using a File-Sharing Workspace.
Downloading Files in a File-Sharing Workspace.
Managing Groove Communications.
Using the Communications Manager.
Groove Instant Messaging.
Managing Groove Alerts.
Working with Groove Contacts.
Managing Contacts from the Launchbar.
Viewing a Digital Fingerprint.
Verifying Contact Identities.
Introducing the Groove Forms Tool.
Designing a Form.
Designing a View.
Testing and Publishing Your Form.
Managing Workspace Archives and Templates.Word.
Mastering Page Setup and Pagination.
Basic Page Setup Options.
Changing Margins and Orientation.
Changing Margin Settings.
Choosing Orientation.
Selecting a Paper Size and Source.
Choosing a Paper Size.
Selecting the Paper Source.
Saving Page Setup Defaults to the Current Template.
Controlling Page and Section Breaks.
Adding Manual Page Breaks.
Creating Additional Sections.
Inserting Text Wrapping Breaks.
Working with Varying Page Settings.
Multiple Page Settings.
Aligning Content Vertically Between Margins.
Including Headers and Footers.
Adding Page Numbers.
Creating Headers and Footers.
Deleting Headers and Footers.
Working with the Document Grid.
Specifying Document Grid Settings.
Displaying the Drawing Grid.
Adding and Controlling Line Numbers. 231
Outlining Documents for Clarity and Structure.
Outlining Enhancements in Word 2007.
Creative Outlining with Word 2007.
Eleven Reasons to Outline Your Next Complex Document.
Viewing a Document in Outline View.
Exploring the Outlining Tools.
Creating a New Outline.
Choosing Outline Display.
Displaying Different Levels of Text.
Showing the First Line of Text.
Removing and Showing Formatting.
Working with Headings in Outline View.
Adding a Heading.
Applying Outline Levels.
Promoting and Demoting Headings.
Displaying Outline and Print Layout View at the Same Time.
Changing Your Outline.
Expanding and Collapsing the Outline.
Moving Outline Topics.
Printing Your Outline.
Using the Document Map vs. Using Outline View.Advanced Layout and Formatting.
Layout and Design Fundamentals.
Using Backgrounds and Watermarks.
Creating Backgrounds and Watermarks.
Changing and Removing Backgrounds and Watermarks.
Controlling Text Placement and Formatting with Text Boxes, Shapes, and Frames.
Creating Text Boxes.
Inserting Text into Text Boxes and Shapes.
Using Floating Frames for Comments, Footnotes, Tables, and Fields.
Formatting Text Boxes and AutoShapes.
Linking Text Boxes to Flow Text from One Text Box to Another.
Moving Between Linked Text Boxes.
Copying or Moving Linked Text Boxes.
Breaking Text Box Links.
Deleting Linked Text Boxes Without Losing Text.
Switching Between Text Boxes and Frames.
Configuring Word 2007 Layout Options.
Commanding Attention with Borders and Shading.
Adding a Simple Border.
Creating Enhanced Borders.
Choosing Border Options.
Selecting Line Styles for Borders.
Choosing a Border Color.
Controlling Border Width.
Creating Partial Borders.
Using a Page Border.
Creating a Page Border.
Adding an Artistic Border.
Adding Borders to Document Sections and Paragraphs.
Bordering Sections.
Adjusting Border Spacing.
Inserting Graphical Horizontal Lines.
Adding a Graphical Horizontal Line.
Formatting a Graphical Horizontal Line.
Importing a Custom Line.
Adding Borders to Pictures.
Using the Picture Border Tool.
Adding a Picture Border by Formatting the Picture.
Adding Table Borders.
Applying Shading Behind Content.
Applying Shades to Tables and Paragraphs.
Shading Considerations.Revising Documents Using Markup Tools.
Benefits of an Organized Revision Process.
Familiarizing Yourself with Markup Tools.
Using the Highlight Tool.
Highlighting Information.
Removing Highlighting from Documents.
Finding Highlighted Items.
Reformatting Highlighted Items with Another Highlight Color.
Adding and Managing Comments Effectively.
Configuring Reviewers’ User Names.
Configuring Colors Associated with Reviewers.
Allowing Reviewers to Use Only the Comments Feature.
Inserting Standard Comments.
Configuring Comment Balloon and Reviewing Pane Options.
Reviewing Comments.
Deleting Comments.
Printing Comments.
Saving a Document with Comments as a Web Page.
Tracking Changes.
Tracking Changes While You Edit.
Adjusting the Appearance of Tracked Changes.
Accepting and Rejecting Proposed Edits.
Comparing and Combining Documents.
Comparing Two Versions of a Document (Legal Blackline).
Combining Revisions from Multiple Authors.Excel.
How to Work a Worksheet and a Workbook.
Moving Around Regions.
Navigating Regions with the Keyboard.
Navigating Regions with the Mouse.
Navigating with Special Keys.
Understanding Selection.
Selecting with the Mouse.
Using the Find & Select Commands.
Selecting with Go To Special.
Techniques for Entering Data.
Making Entries in Cells and in the Formula Bar.
Making Entries in Ranges.
Editing and Undoing Entries.
Managing Worksheets.
Inserting and Deleting Worksheets.
Naming and Renaming Worksheets.
Moving and Copying Worksheets.
Viewing Worksheets.
Splitting Worksheets into Panes.
Freezing Panes.
Zooming Worksheets.
Using Custom Views.
Protecting Worksheets.
Unlocking Individual Cells.
Protecting the Workbook.
Allowing Password Access to Specific Cell Ranges.
Hiding Cells and Worksheets.
Using Passwords.
Managing Multiple Workbooks.
Navigating Between Open Workbooks.
Arranging Workbook Windows.
Getting the Most Out of Your Screen.
Comparing Worksheets Side by Side.
Opening Multiple Windows for the Same Workbook.
Useful Inconsistencies of New Windows.
Hiding and Protecting Workbooks.
Hiding Workbooks.
Protecting Workbooks.
Encrypting Workbooks.
Saving Workbooks or Windows as Hidden.
Hiding Worksheets.Building Formulas.
Formula Fundamentals.
Understanding the Precedence of Operators.
Using Cell References in Formulas.
Editing Formulas.
Understanding Error Values.
Using Functions: A Preview.
Using the Sum Button.
Inserting a Function.
Using Formula AutoComplete.
Working with Formulas.
Naming Cells and Cell Ranges.
Getting Explicit About Intersections.
Creating Three-Dimensional Formulas.
Formula-Bar Formatting.
Using Structured References.
Worksheet Calculation.
Recalculating Manually.
Calculating Part of a Formula.
Working with Circular References.
Understanding the Precision of Numeric Values.
Using Arrays.
One-Dimensional Arrays.
Array Formula Rules.
Two-Dimensional Arrays.
Single-Cell Array Formulas.
Using Array Constants.
Understanding Array Expansion.
Linking Workbooks.
Saving Linked Workbooks.
Opening a Dependent Workbook.
Editing Links.
Copying, Cutting, and Pasting in Linked Workbooks.
Creating Conditional Tests.
Using the Conditional Sum and Lookup Wizards.
Creating Conditional Sum Formulas.
Creating Lookup Formulas.Using Functions.
Using the Built-In Function Reference in Excel.
Exploring the Syntax of Functions.
Expressions as Arguments.
Types of Arguments.
Inserting Functions.
Inserting References and Names.
Understanding Mathematical Functions.
Using the SUM Function.
Using Selected Mathematical Functions.
Using the Rounding Functions.
Understanding Text Functions.
Using Selected Text Functions.
Using the Substring Text Functions.
Understanding Logical Functions.
Using Selected Logical Functions.
Understanding Information Functions.
Using Selected Information Functions.
Using the IS Information Functions.
Understanding Lookup and Reference Functions.
Using Selected Lookup and Reference Functions.Analyzing Data with PivotTable Reports.
Introducing PivotTables.
Creating a PivotTable.
Rearranging PivotTable Fields.
Refreshing a PivotTable.
Changing the Numeric Format of PivotTable Data.
Choosing Report Layout Options.
Formatting a PivotTable.
Customizing the Display of Empty or Error Cells.
Merging and Centering Field Labels.
Hiding Outline Controls.
Hiding Row Labels and Column Labels.
Displaying Totals and Subtotals.
Customizing Subtotals.
Sorting PivotTable Fields.
Filtering PivotTable Fields.
Changing PivotTable Calculations.
Using a Different Summary Function.
Applying Multiple Summary Functions to the Same Field.
Using Custom Calculations.
Using Calculated Fields and Items.
Grouping and Ungrouping Data.
Creating Ad Hoc Item Groupings.
Grouping Items in Date or Time Ranges.
Displaying the Details Behind a Data Value.
Creating PivotCharts.PowerPoint.
Introduction to PowerPoint 2007.
Command Locations.
Customizing Office PowerPoint 2007.
Customizing the Quick Access Toolbar.
Setting PowerPoint 2007 Options.
File Formats.
Opening a PowerPoint 2007 Presentation in PowerPoint 97–2003.
Saving to PowerPoint 95 and Earlier File Formats.
About PDF and XPS File Formats.
Formatting.
PowerPoint 2007 Views.
Slide Masters.
Themes.
Saving a Document Theme.
Tables.
Adding a New Table to Your Presentation.
Drawing a Table in Your Presentation.
Copying a Table from Word 2007 or Excel 2007.
Inserting an Excel 2007 Spreadsheet.
A Word About Table Styles.
Custom Slide Layouts.
Creating a Custom Slide Layout.
PowerPoint 2007 Slide Libraries.
Program Recovery.Working with Text.
Adding a Text Box to a Slide.
Finding and Replacing Words or Phrases.
Creating and Saving Customized Theme Fonts.
Formatting with WordArt.
WordArt Styles.
Adding WordArt Style to Text.
Adding Punch to Your Bulleted Lists.
Writing on Slides During a Presentation.
Using Headers and Footers.
Working with Proofing Tools.Working with Objects, Diagrams, and Charts in PowerPoint 2007.
Working with Pictures.
Adjust Your Pictures.
Adding a Picture Style.
Arrange Pictures.
Size.
Adding Clip Art.
Using SmartArt.
Creating a SmartArt Graphic from Scratch.
Adding a SmartArt Style to Your Graphic.
Adding Pictures to a SmartArt Graphic.
Using Picture Placeholders in a Shape.
Customizing Your SmartArt Graphic.
Adding Sounds.
Including Movies.
Playing with Animations.
Animating SmartArt Graphics.
Creating Charts and Diagrams.
Saving a Chart Template.
Chart Formatting Options.Collaborating and Sharing.
Using Templates.
Working with Windows SharePoint Services.
Reviewing, Approving, and Tracking Changes.
Adding Comments.
Editing and Deleting Comments.
Protecting Your Document.
Securing Your Presentation.
Using the Document Inspector.Working with External Data in PowerPoint 2007.
Working with Earlier Versions of PowerPoint.
Working with Excel 2007.
Create a New Excel 2007 Table in PowerPoint 2007.
Add an Existing Excel Table from Excel 2007.
Working with Access 2007.
Add an Existing Table, Form, Report, or Other Object from Access 2007.
Use a Screen Capture to Copy Content from Access 2007.
Blocking and Unblocking External Content.
Using Trusted Locations.
Create a Trusted Location.
Remove a Trusted Location.
Modify a Trusted Location.
Setting Up Security Alerts and Trusted Publishers.Setting Up and Presenting a Slide Show.
Learning the Basics.
Keep Your Viewers on Track.
Copyright Your Work.
Secure Your Document When It’s Complete.
Verify Your Slide Show Before Delivery.
Creating Custom Slide Shows.
Create a Basic Custom Show.
Create a Hyperlinked Custom Show.
Run a Custom Show.
Adding Transitions.
Using Presenter View.
Working with Photo Albums.
Publish Your Photo Album to the Web.
Exploring Printing Options. 624
Outlook.
Introducing Outlook 2007.
A New Interface.
The Ribbon.
The Navigation Pane.
The To-Do Bar.
Other Interface Changes.
Instant Search.
Calendar Changes.
E-Mail Changes.
Color Categories.
Collaboration and Sharing Improvements.
Integration with Office SharePoint Server.
Shared Calendars.
Shared Business Cards.
Overview of Outlook 2007 Capabilities.
Messaging.
Scheduling.
Contact Management.
Task Management.
Tracking with the Outlook Journal.
Organizing Your Thoughts with Notes.
How Outlook Stores Data.
Personal Folders—.pst Files.
Options for Working Offline.
Sharing Storage Files.
Understanding Messaging Protocols.
SMTP/POP3.
IMAP.
MAPI.
LDAP.
NNTP.
HTML.
MIME.
S/MIME.
MHTML.
iCalendar, vCalendar, and vCard.
Security Provisions in Outlook.
Protection Against Web Beacons.
Attachment and Virus Security.
Macro Viruses.
Digital Signatures.
Message Encryption.
Security Labels.
Understanding Outlook Service Options.
Options for Starting Outlook.
Normal Startup.
Safe Mode Startup.
Starting Outlook Automatically.
Adding Outlook to the Quick Launch Bar.
Changing the Outlook Shortcut.
Using RUNAS to Change User Context.
Startup Switches.
Choosing a Startup View.
Creating Shortcuts to Start New Outlook Items.Finding and Organizing Messages.
Finding and Organizing Messages with Search Folders.
Using Search Folders.
Customizing Search Folders.
Creating a New Search Folder.
Flagging and Monitoring Messages and Contacts.
Flagging Received and Previously Sent Messages.
Flagging Outgoing Messages.
Viewing and Responding to Flagged Messages.
Flagging Contact Items.
Grouping Messages by Customizing the Folder View.
Filtering a View Using Categories.
Managing E-Mail Effectively.Securing Your System, Messages, and Identity.
Configuring HTML Message Handling.
Protecting Messages with Digital Signatures.
Understanding Digital Certificates and Signatures.
Obtaining a Digital Certificate.
Copying a Certificate to Another Computer.
Signing Messages.
Understanding S/MIME and Clear-Text Options.
Adding Your Digital Signature.
Setting Global Security Options.
Creating and Using Security Profiles.
Reading Signed Messages.
Changing Certificate Trust Relationships.
Configuring CA Trust.
Configuring CA Trust for Multiple Computers.
Viewing and Validating a Digital Signature.
Encrypting Messages.
Getting Ready for Encryption.
Sending Encrypted Messages.
Reading Encrypted Messages.
Importing Certificates from Outlook Express.
Protecting Data with Information Rights Management.
Using Microsoft’s IRM Service.
Viewing IRM-Protected Messages.
Working with Multiple Accounts.Collaboration with Outlook and Windows SharePoint Services.
Understanding Windows SharePoint Services Collaboration.
Setting Up Alerts.
Working with Shared Documents.
Uploading a Document.
Creating a Document from the Site.
Working with Existing Documents and Version Control.
Working with Shared Contacts.
Viewing Contacts on a Windows SharePoint Services Site.
Linking Windows SharePoint Services 2.0 Contacts Lists to Outlook.
Copying Contacts from Windows SharePoint Services 2.0 to Outlook.
Copying Contacts from Outlook to Windows SharePoint Services 2.0.
Linking a Team Calendar to Outlook.
Configuring Alerts in Outlook.
Adding Alerts from Outlook.
Editing and Deleting Alerts from Outlook.
Rules Based on Alerts.
Using Outlook to Work with SharePoint Libraries and Files.
Connecting a SharePoint Library to Outlook.
Downloading Files from a SharePoint Library to Outlook.
Opening Files from a SharePoint Site in Outlook.
Editing Files from a SharePoint Site in Outlook.
Removing SharePoint Files in Outlook.
Removing SharePoint Folders in Outlook.
Using E-Mail to Add a File to a SharePoint Library.Access.
Exploring the New Look of Access 2007.
Opening Access for the First Time.
Getting Started—A New Look for Access.
Opening an Existing Database.
Exploring the Microsoft Office Button.
Taking Advantage of the Quick Access Toolbar.
Understanding Content Security.
Temporarily Enabling a Database That Is Not Trusted.
Understanding the Trust Center.
Enabling Content by Defining Trusted Locations.
Understanding the New Ribbon Feature.
Home Tab.
Create Tab.
External Data Tab.
Database Tools Tab.
Understanding the New Navigation Pane.
Exploring Navigation Pane Object Views.
Working with Custom Categories and Groups.
Sorting and Selecting Views in the Navigation Pane. 818 Manually Sorting Objects in the Navigation Pane.
Searching for Database Objects.
Using the Single-Document vs. Multiple-Document Interface.
Modifying Global Settings via the Access Options Dialog Box.Creating Your Database and Tables.
Creating a New Database.
Using a Database Template to Create a Database.
Creating a New Empty Database.
Creating Your First Simple Table by Entering Data.
Creating a Table Using a Table Template.
Creating a Table in Design View.
Defining Fields.
Understanding Field Data Types.
Setting Field Properties.
Completing the Fields in the Companies Table.
Defining Simple Field Validation Rules.
Defining Input Masks.
Defining a Primary Key.
Defining a Table Validation Rule.
Understanding Other Table Properties.
Defining Relationships.
Defining Your First Relationship.
Creating a Relationship on Multiple Fields.
Adding Indexes.
Single-Field Indexes.
Multiple-Field Indexes.
Setting Table Design Options.
Creating a Default Template for New Databases.
Printing a Table Definition.
Database Limitations.Creating and Working with Simple Queries.
Selecting Data from a Single Table.
Specifying Fields.
Setting Field Properties.
Entering Selection Criteria.
Using Expressions.
Using the Expression Builder.
Specifying Field Names.
Sorting Data.
Testing Validation Rule Changes.
Checking a New Field Validation Rule.
Checking a New Table Validation Rule.
Working in Query Datasheet View.
Moving Around and Using Keyboard Shortcuts.
Working with Subdatasheets.
Changing Data.
Working with Hyperlinks.
Sorting and Searching for Data.Building a Form.
Forms and Object-Oriented Programming.
Starting from Scratch—A Simple Input Form.
Building a New Form with Design Tools.
Building a Simple Input Form for the tblCompanies Table.
Customizing Colors and Checking Your Design Results.
Working with Quick Create Commands and the Form Wizard.
Creating a Form with the Quick Create Commands.
Creating the Basic Products Form with the Form Wizard.
Modifying the Products Form.
Simplifying Data Input with a Form.
Taking Advantage of Combo Boxes and List Boxes.
Using Toggle Buttons, Check Boxes, and Option Buttons.Constructing a Report.
Starting from Scratch—A Simple Report.
Building the Report Query.
Designing the Report.
Grouping Sorting, and Totaling Information.
Completing the Report.
Using the Report Command.
Using the Report Wizard.
Specifying Report Wizard Options.
Viewing the Result.
Modifying a Wizard-Created Report in Layout View.
Building a Report in Layout View.
Starting with a Blank Report.
Adding Grouping and Sorting.
Working with Control Layouts.
Adding Totals to Records.
Applying an AutoFormat.Microsoft Office Programming Primer.
VBA Primer.
When and Why to Use VBA.
Introduction to the VBA Language and Code Structure.
Recording Macros.
How to Read VBA Code.
Statements, Procedures, Modules, and Projects.
Understanding and Using the Visual Basic Editor.
The Code Window.
Project Explorer.
The Properties Window.
Setting Up Your Workspace.
Writing, Editing, and Sharing Simple Macros.
Creating Modules and Starting Procedures.
Objects, Properties, and Methods.
Object Models.
Using Auto Lists.
Variables.
Constants.
Collection Objects.
Grouping Statements.
Loops.
Conditional Structures.
Operators.
Message Boxes and Input Boxes.
Running One Macro from Another.
Setting Macros to Conditionally Stop Executing Commands.
Running Macros and Compiling Projects.
Understanding Errors.
Creating Error Handlers.
Getting Help.
Saving and Sharing Macros.
Using VBA to Save Time on Document Production and Troubleshooting.
Using the Immediate Window.
Introduction to Using Events.
Creating UserForms (Dialog Boxes).
Designing a UserForm.
Automating a UserForm.
Next Steps for Working with Automation in Microsoft Office.Office Open XML Essentials.
Chapter Assumptions.
XML Basics for Reading Your Documents.
Reading a Markup Language.
Understanding Key Terms.
XML Editing Options.
Getting to Know the Office Open XML Formats.
Breaking into Your Document.
The Office Open XML File Structure.
Taking a Closer Look at Key Document Parts.
Building a Basic Word Document from Scratch.
Create the Folder Structure.
Editing and Managing Documents Through XML.
Before You Begin Editing a Document Part.
Editing Text and Formatting.
Edit Text and Settings in document.xml.
Editing Pictures.
Removing a Document Part.
Customizing the Ribbon.
The Basic Components of Ribbon Customization.
Adding a Ribbon Tab.
Add a Group to a Built-In Ribbon Tab.
Binding Data to Content Controls.
The Components of a Bound Content Control.
Binding a Control to Custom XML.
Next Steps for Working with the Office Open XML Formats.
Appendix: Installing and Configuring the 2007 Office System.
Installing the Microsoft Office System from the CD.
Changing Your 2007 Office System Setup.
Changing Your Setup from Control Panel.
Changing Setup and Getting Updates from the Options Dialog Box.
Index to Troubleshooting Topics.