You are previewing 2007 Microsoft® Office System Inside Out.
O'Reilly logo
2007 Microsoft® Office System Inside Out

Book Description

Learn everything you need to know for working with the 2007 Microsoft Office system--from the inside out! This book packs hundreds of time-saving solutions, troubleshooting tips, and workarounds for using the 2007 release of Microsoft Office--all in concise, fast-answer format. Whether you are upgrading from Office 97 or Office 2003, you'll be able to dig in to the work-ready resources that help you take your Microsoft Office experience to the next level. This comprehensive guide to the 2007 Microsoft Office suites helps you navigate new features and capabilities in the Office programs you use everyday, including the new, easy-to-use user interface and new formatting and editing capabilities. You'll learn how to use the new graphics features in Microsoft Office Excel® and Microsoft Office PowerPoint®, create a database with Microsoft Office Access, and manage tasks by using Microsoft Office Outlook®. You'll even discover how to use shared workspaces and the Internet to collaborate with others. Plus, you'll get tools, eBooks, and more on the companion CD. With INSIDE OUT, you get all muscle and no fluff!

Table of Contents

  1. 2007 Microsoft® Office System Inside Out
    1. SPECIAL OFFER: Upgrade this ebook with O’Reilly
    2. A Note Regarding Supplemental Files
    3. Acknowledgments
    4. About the CD
      1. What’s on the CD
      2. Using the CD
      3. System Requirements
      4. Support Information
    5. Conventions and Features Used in This Book
      1. Text Conventions
      2. Design Conventions
    6. 1. Introduction
      1. Who This Book Is For
      2. How This Book Is Organized
    7. 1. Getting Started
      1. 1. Overview of the 2007 Microsoft Office System
        1. The New World of Work
          1. Collaboration Workspaces and Tools
          2. Business Intelligence on Your Desktop
        2. The New Microsoft Office User Interface
          1. The Ribbon
          2. Galleries and Live Preview
        3. The New Microsoft Office XML File Formats
        4. What Else Is New?
          1. Microsoft Office Word 2007
          2. Microsoft Office Excel 2007
          3. Microsoft Office PowerPoint 2007
          4. Microsoft Office Outlook 2007
          5. Microsoft Office Access 2007
          6. 2007 Office System Servers
            1. Forms Server
            2. Groove Server
            3. Project Server
          7. Templates and Assistance from Microsoft Office Online
      2. 2. The 2007 Office System User Interface: What’s Changed, What’s the Same
        1. A Quick Tour and Comparison
        2. The Ribbon and Command Tabs
        3. Customizing the Quick Access Toolbar
        4. The Microsoft Office Button and Menu
        5. Working in Context: More Tabs, Plus Some Menus and Toolbars
          1. Contextual Tabs
          2. Shortcut Menus and the Mini Toolbar
        6. Galleries and Live Preview
        7. Getting Help
          1. Searching Online Help
      3. 3. Managing Security and Privacy in the 2007 Office System
        1. Working in the Trust Center
          1. Digital Signatures and Trusted Publishers
          2. Using Trusted Locations
          3. Setting Security Options for Macros and Add-Ins
          4. Security Settings for ActiveX Controls
        2. Setting Your Privacy Options
        3. Removing Hidden Data and Personal Information from Microsoft Office Documents
        4. Applying Information Rights Management
          1. Configuring Your Computer to Use Information Rights Management
          2. Restricting Permissions
        5. Assigning a Password to a Document
          1. Changing a Password
          2. Removing a Password
        6. Avoiding Phishing Schemes
    8. 2. Collaboration Essentials
      1. 4. Collaborating and Sharing with Others
        1. Understanding and Using the 2007 Office System Collaboration Environments
        2. Creating and Using Shared Workspaces with Windows SharePoint Services
          1. Understanding the Workspace
            1. Libraries
            2. Lists and Other Communication Tools
          2. Accessing or Adding Content in a SharePoint Document Library
            1. Adding Content to a Library or List
          3. Creating or Editing a Windows SharePoint Services Shared Workspace
            1. Adding Sites, Pages, or Lists
            2. Understanding and Using Web Parts
            3. Managing Site Settings and Permissions
        3. Creating and Using Groove Workspaces
          1. Understanding Your Workspace
            1. Managing Files in a Workspace
          2. Creating a Workspace
            1. Adding Tools to Your Workspace
          3. Inviting Others to Join a Workspace
            1. Setting Roles and Permissions
        4. Using Office OneNote 2007 as a Collaboration Tool
          1. Shared Notebooks and Live Sharing Sessions
            1. Creating a Live Sharing Session
            2. Creating a Shared Notebook
      2. 5. Organizing and Finding Information in Microsoft Office OneNote
        1. Organizing a OneNote Notebook
          1. Creating a Notebook
          2. Working in the OneNote Window
          3. Organizing Notebook Sections
          4. Adding and Grouping Notebook Pages
        2. Adding Notes and Information to a Notebook
          1. Adding and Working with Text Notes
          2. Tagging Types of Notes
          3. Printing to OneNote
          4. Embedding References to Files
          5. Using Office OneNote and Office Outlook Together
          6. Inserting Audio or Video Recordings
          7. Adding Information to a Notebook from the Web
          8. Capturing Information on Your Windows Mobile–Powered Device
          9. Inserting an Image in a Notebook
          10. Creating a Drawing in OneNote
          11. Creating and Working with Tables in OneNote
        3. Finding Your Information
        4. Using a Notebook on More Than One Computer
          1. Creating a Notebook for Use on More Than One Computer
          2. Share an Existing Notebook Among Your Computers
        5. Working as a Team with Office OneNote 2007
          1. Working with a Shared Notebook
          2. Protecting a Shared Section
          3. Sharing an Existing Notebook
          4. Sharing a Notebook in a Live Session
          5. Sharing Notes Using E-Mail
      3. 6. Working as a Team in a Microsoft Office Groove Workspace
        1. Getting Started with Groove
        2. Setting Up a Groove Account
        3. The View from the Launchbar
        4. Groove Workspace Basics
          1. Creating a Workspace
          2. Inviting Workspace Members and Assigning Member Roles
          3. Using Your Groove Account on a Second Computer
          4. Knowing When Members Are Present and Accounted For
          5. Chatting with Workspace Members
          6. Setting Roles and Changing Role Permissions
          7. Exploring a Groove Workspace
        5. Outfitting a Groove Workspace with Tools
          1. Keeping a Calendar
          2. Topics Under Discussion
          3. Making Meetings More Effective
          4. Storing, Organizing, and Sharing Files
          5. Tracking Issues
          6. Taking Notes
          7. Adding Pictures to a Workspace
          8. Sketching Your Ideas
      4. 7. Sharing and Communicating Using Microsoft Office Groove
        1. Setting Up and Using a File-Sharing Workspace
          1. Downloading Files in a File-Sharing Workspace
        2. Managing Groove Communications
          1. Using the Communications Manager
            1. Pausing Communications
            2. Working with Groove Offline
            3. Viewing and Modifying Network Settings
          2. Groove Instant Messaging
            1. Managing Groove Messages and Message History
          3. Managing Groove Alerts
        3. Working with Groove Contacts
          1. Managing Contacts from the Launchbar
          2. Viewing a Digital Fingerprint
          3. Verifying Contact Identities
        4. Introducing the Groove Forms Tool
          1. Designing a Form
          2. Designing a View
          3. Testing and Publishing Your Form
        5. Managing Workspace Archives and Templates
    9. 3. Word
      1. 8. Mastering Page Setup and Pagination
        1. Basic Page Setup Options
        2. Changing Margins and Orientation
          1. Changing Margin Settings
          2. Choosing Orientation
        3. Selecting a Paper Size and Source
          1. Choosing a Paper Size
          2. Selecting the Paper Source
          3. Saving Page Setup Defaults to the Current Template
        4. Controlling Page and Section Breaks
          1. Adding Manual Page Breaks
          2. Creating Additional Sections
          3. Inserting Text Wrapping Breaks
        5. Working with Varying Page Settings
          1. Multiple Page Settings
          2. Aligning Content Vertically Between Margins
        6. Including Headers and Footers
          1. Adding Page Numbers
          2. Creating Headers and Footers
          3. Deleting Headers and Footers
        7. Working with the Document Grid
          1. Specifying Document Grid Settings
          2. Displaying the Drawing Grid
        8. Adding and Controlling Line Numbers
      2. 9. Outlining Documents for Clarity and Structure
        1. Outlining Enhancements in Word 2007
        2. Creative Outlining with Word 2007
        3. Eleven Reasons to Outline Your Next Complex Document
        4. Viewing a Document in Outline View
          1. Exploring the Outlining Tools
        5. Creating a New Outline
        6. Choosing Outline Display
          1. Displaying Different Levels of Text
          2. Showing the First Line of Text
          3. Removing and Showing Formatting
        7. Working with Headings in Outline View
          1. Adding a Heading
          2. Applying Outline Levels
          3. Promoting and Demoting Headings
        8. Displaying Outline and Print Layout View at the Same Time
        9. Changing Your Outline
          1. Expanding and Collapsing the Outline
          2. Moving Outline Topics
            1. Moving Topics Up and Down
            2. Cutting and Pasting Parts of the Outline
            3. Dragging to a New Location
        10. Printing Your Outline
        11. Using the Document Map vs. Using Outline View
      3. 10. Advanced Layout and Formatting
        1. Layout and Design Fundamentals
        2. Using Backgrounds and Watermarks
          1. Creating Backgrounds and Watermarks
            1. Adding Backgrounds to Online Pages
            2. Adding Watermarks to Documents
          2. Changing and Removing Backgrounds and Watermarks
        3. Controlling Text Placement and Formatting with Text Boxes, Shapes, and Frames
          1. Creating Text Boxes
          2. Inserting Text into Text Boxes and Shapes
          3. Using Floating Frames for Comments, Footnotes, Tables, and Fields
          4. Formatting Text Boxes and AutoShapes
            1. Controlling Text in Text Boxes and Shapes
            2. Changing Text Box Shapes
            3. Resizing Text Boxes or AutoShapes Automatically to Show All Content
          5. Linking Text Boxes to Flow Text from One Text Box to Another
          6. Moving Between Linked Text Boxes
          7. Copying or Moving Linked Text Boxes
          8. Breaking Text Box Links
          9. Deleting Linked Text Boxes Without Losing Text
          10. Switching Between Text Boxes and Frames
        4. Configuring Word 2007 Layout Options
        5. Commanding Attention with Borders and Shading
        6. Adding a Simple Border
        7. Creating Enhanced Borders
          1. Choosing Border Options
          2. Selecting Line Styles for Borders
          3. Choosing a Border Color
          4. Controlling Border Width
        8. Creating Partial Borders
        9. Using a Page Border
          1. Creating a Page Border
          2. Adding an Artistic Border
        10. Adding Borders to Document Sections and Paragraphs
          1. Bordering Sections
        11. Adjusting Border Spacing
        12. Inserting Graphical Horizontal Lines
          1. Adding a Graphical Horizontal Line
          2. Formatting a Graphical Horizontal Line
          3. Importing a Custom Line
        13. Adding Borders to Pictures
          1. Using the Picture Border Tool
          2. Adding a Picture Border by Formatting the Picture
        14. Adding Table Borders
        15. Applying Shading Behind Content
          1. Applying Shades to Tables and Paragraphs
          2. Shading Considerations
      4. 11. Revising Documents Using Markup Tools
        1. Benefits of an Organized Revision Process
        2. Familiarizing Yourself with Markup Tools
        3. Using the Highlight Tool
          1. Highlighting Information
          2. Removing Highlighting from Documents
          3. Finding Highlighted Items
          4. Reformatting Highlighted Items with Another Highlight Color
        4. Adding and Managing Comments Effectively
          1. Configuring Reviewers’ User Names
          2. Configuring Colors Associated with Reviewers
          3. Allowing Reviewers to Use Only the Comments Feature
          4. Inserting Standard Comments
          5. Configuring Comment Balloon and Reviewing Pane Options
            1. Changing the Styles of Balloon and Reviewing Pane Text and Labels
            2. Showing and Hiding Balloons
            3. Adjusting Balloon Size and Location for Online Viewing
          6. Reviewing Comments
          7. Deleting Comments
          8. Printing Comments
          9. Saving a Document with Comments as a Web Page
        5. Tracking Changes
          1. Tracking Changes While You Edit
          2. Adjusting the Appearance of Tracked Changes
            1. Specifying How Insertions and Formatting Changes Are Displayed
            2. Tracking Moved Text and Inline Shapes
            3. Showing Revisions in Tables
            4. Customizing the Appearance of Changed Lines
          3. Accepting and Rejecting Proposed Edits
            1. Addressing Tracked Changes One at a Time
            2. Accepting or Rejecting All Tracked Changes at Once
            3. Printing Documents That Contain Revisions
        6. Comparing and Combining Documents
          1. Comparing Two Versions of a Document (Legal Blackline)
          2. Combining Revisions from Multiple Authors
    10. 4. Excel
      1. 12. How to Work a Worksheet and a Workbook
        1. Moving Around Regions
          1. Navigating Regions with the Keyboard
          2. Navigating Regions with the Mouse
          3. Navigating with Special Keys
        2. Understanding Selection
          1. Selecting with the Mouse
            1. Zooming to Select Large Worksheet Areas
            2. Selecting Columns, Rows, and Multiple Areas
            3. Selecting Regions
          2. Using the Find & Select Commands
          3. Selecting with Go To Special
            1. Selecting Precedents and Dependents
            2. Selecting Row or Column Differences
        3. Techniques for Entering Data
          1. Making Entries in Cells and in the Formula Bar
            1. Entering Simple Numeric and Text Values
            2. Using Special Characters
            3. Understanding the Difference Between Displayed Values and Underlying Values
            4. Creating Long Text Values
            5. Using Text Wrapping
            6. Understanding Numeric Text Entries
            7. Entering Symbols
          2. Making Entries in Ranges
          3. Editing and Undoing Entries
        4. Managing Worksheets
          1. Inserting and Deleting Worksheets
          2. Naming and Renaming Worksheets
          3. Moving and Copying Worksheets
        5. Viewing Worksheets
          1. Splitting Worksheets into Panes
          2. Freezing Panes
          3. Zooming Worksheets
          4. Using Custom Views
        6. Protecting Worksheets
          1. Unlocking Individual Cells
          2. Protecting the Workbook
          3. Allowing Password Access to Specific Cell Ranges
          4. Hiding Cells and Worksheets
          5. Using Passwords
        7. Managing Multiple Workbooks
          1. Navigating Between Open Workbooks
          2. Arranging Workbook Windows
          3. Getting the Most Out of Your Screen
          4. Comparing Worksheets Side by Side
        8. Opening Multiple Windows for the Same Workbook
          1. Useful Inconsistencies of New Windows
        9. Hiding and Protecting Workbooks
          1. Hiding Workbooks
          2. Protecting Workbooks
          3. Encrypting Workbooks
          4. Saving Workbooks or Windows as Hidden
          5. Hiding Worksheets
      2. 13. Building Formulas
        1. Formula Fundamentals
          1. Understanding the Precedence of Operators
          2. Using Cell References in Formulas
            1. Entering Cell References by Clicking
            2. Understanding Relative, Absolute, and Mixed References
            3. Creating References to Other Worksheets in the Same Workbook
            4. Creating References to Worksheets in Other Workbooks
            5. Understanding Row-Column Reference Style
            6. How Copying Affects Cell References
              1. Copying Relative References
              2. Copying Absolute References
              3. Copying Mixed References
          3. Editing Formulas
            1. Understanding Reference Syntax
            2. Using Numeric Text in Formulas
            3. About Text Values
          4. Understanding Error Values
        2. Using Functions: A Preview
          1. Using the Sum Button
          2. Inserting a Function
          3. Using Formula AutoComplete
        3. Working with Formulas
          1. Naming Cells and Cell Ranges
            1. Using Names in Formulas
            2. Defining and Managing Names
            3. Editing Names
            4. Workbook-Wide vs. Worksheet-Only Names
            5. Creating Names Semiautomatically
            6. Naming Constants and Formulas
              1. Using Relative References in Named Formulas
            7. Creating Three-Dimensional Names
            8. Using Names in Formulas
            9. Creating a List of Names
            10. Replacing References with Names
            11. Using Go To with Names
          2. Getting Explicit About Intersections
          3. Creating Three-Dimensional Formulas
          4. Formula-Bar Formatting
          5. Using Structured References
            1. Understanding Structured Reference Syntax
            2. Using Operators with Column Specifiers
            3. About the Special Item Specifiers
            4. Using Formula AutoComplete with Structured References
            5. Filling and Copying Structured References
        4. Worksheet Calculation
          1. Recalculating Manually
          2. Calculating Part of a Formula
          3. Working with Circular References
          4. Understanding the Precision of Numeric Values
        5. Using Arrays
          1. One-Dimensional Arrays
          2. Array Formula Rules
          3. Two-Dimensional Arrays
          4. Single-Cell Array Formulas
          5. Using Array Constants
          6. Understanding Array Expansion
        6. Linking Workbooks
          1. Saving Linked Workbooks
          2. Opening a Dependent Workbook
          3. Editing Links
          4. Copying, Cutting, and Pasting in Linked Workbooks
            1. Copying and Pasting Between Workbooks
            2. Cutting and Pasting Between Workbooks
        7. Creating Conditional Tests
          1. Using the Conditional Sum and Lookup Wizards
          2. Creating Conditional Sum Formulas
          3. Creating Lookup Formulas
      3. 14. Using Functions
        1. Using the Built-In Function Reference in Excel
        2. Exploring the Syntax of Functions
          1. Expressions as Arguments
          2. Types of Arguments
            1. Numeric Values
            2. Text Values
            3. Logical Values
            4. Named References
            5. Arrays
            6. Mixed Argument Types
        3. Inserting Functions
          1. Inserting References and Names
        4. Understanding Mathematical Functions
          1. Using the SUM Function
            1. The Sum Button
          2. Using Selected Mathematical Functions
            1. The PRODUCT and SUMPRODUCT Functions
            2. The MOD Function
            3. The COMBIN Function
            4. The RAND and RANDBETWEEN Functions
          3. Using the Rounding Functions
            1. The ROUND, ROUNDDOWN, and ROUNDUP Functions
            2. The EVEN and ODD Functions
            3. The FLOOR and CEILING Functions
            4. The INT Function
            5. The TRUNC Function
        5. Understanding Text Functions
          1. Using Selected Text Functions
            1. The TEXT Function
            2. The DOLLAR Function
            3. The LEN Function
            4. The ASCII Functions: CHAR and CODE
            5. The Cleanup Functions: TRIM and CLEAN
            6. The EXACT Function
            7. The Case Functions: UPPER, LOWER, and PROPER
          2. Using the Substring Text Functions
            1. The FIND and SEARCH Functions
            2. The RIGHT and LEFT Functions
            3. The MID Function
            4. The REPLACE and SUBSTITUTE Functions
            5. The CONCATENATE Function
        6. Understanding Logical Functions
          1. Using Selected Logical Functions
            1. The IF Function
            2. The AND, OR, and NOT Functions
            3. Nested IF Functions
            4. Other Uses for Conditional Functions
        7. Understanding Information Functions
          1. Using Selected Information Functions
            1. The TYPE and ERROR.TYPE Functions
            2. The COUNTBLANK Function
          2. Using the IS Information Functions
        8. Understanding Lookup and Reference Functions
          1. Using Selected Lookup and Reference Functions
            1. The VLOOKUP and HLOOKUP Functions
            2. The LOOKUP Function
            3. The ADDRESS Function
            4. The CHOOSE Function
            5. The MATCH Function
            6. The INDEX Function
            7. The INDIRECT Function
            8. The ROW and COLUMN Functions
            9. The ROWS and COLUMNS Functions
            10. The AREAS Function
            11. The TRANSPOSE Function
      4. 15. Analyzing Data with PivotTable Reports
        1. Introducing PivotTables
        2. Creating a PivotTable
        3. Rearranging PivotTable Fields
        4. Refreshing a PivotTable
        5. Changing the Numeric Format of PivotTable Data
        6. Choosing Report Layout Options
        7. Formatting a PivotTable
          1. Customizing the Display of Empty or Error Cells
          2. Merging and Centering Field Labels
          3. Hiding Outline Controls
          4. Hiding Row Labels and Column Labels
        8. Displaying Totals and Subtotals
          1. Customizing Subtotals
        9. Sorting PivotTable Fields
        10. Filtering PivotTable Fields
        11. Changing PivotTable Calculations
          1. Using a Different Summary Function
          2. Applying Multiple Summary Functions to the Same Field
          3. Using Custom Calculations
          4. Using Calculated Fields and Items
            1. Creating a Calculated Field
            2. Creating a Calculated Item
            3. Displaying a List of Calculated Fields and Items
        12. Grouping and Ungrouping Data
          1. Creating Ad Hoc Item Groupings
          2. Grouping Items in Date or Time Ranges
        13. Displaying the Details Behind a Data Value
        14. Creating PivotCharts
    11. 5. PowerPoint
      1. 16. Introduction to PowerPoint 2007
        1. Command Locations
        2. Customizing Office PowerPoint 2007
          1. Customizing the Quick Access Toolbar
          2. Setting PowerPoint 2007 Options
            1. PowerPoint Options: Popular
            2. PowerPoint Options: Proofing
            3. PowerPoint Options: Save
            4. PowerPoint Options: Advanced
            5. PowerPoint Options: Add-Ins
            6. PowerPoint Options: Trust Center
            7. PowerPoint Options: Resources
        3. File Formats
          1. Opening a PowerPoint 2007 Presentation in PowerPoint 97–2003
          2. Saving to PowerPoint 95 and Earlier File Formats
          3. About PDF and XPS File Formats
        4. Formatting
        5. PowerPoint 2007 Views
          1. Slide Masters
        6. Themes
          1. Saving a Document Theme
        7. Tables
          1. Adding a New Table to Your Presentation
          2. Drawing a Table in Your Presentation
          3. Copying a Table from Word 2007 or Excel 2007
          4. Inserting an Excel 2007 Spreadsheet
          5. A Word About Table Styles
        8. Custom Slide Layouts
          1. Creating a Custom Slide Layout
        9. PowerPoint 2007 Slide Libraries
        10. Program Recovery
      2. 17. Working with Text
        1. Adding a Text Box to a Slide
        2. Finding and Replacing Words or Phrases
        3. Creating and Saving Customized Theme Fonts
        4. Formatting with WordArt
          1. WordArt Styles
          2. Adding WordArt Style to Text
        5. Adding Punch to Your Bulleted Lists
        6. Writing on Slides During a Presentation
        7. Using Headers and Footers
        8. Working with Proofing Tools
      3. 18. Working with Objects, Diagrams, and Charts in PowerPoint 2007
        1. Working with Pictures
          1. Adjust Your Pictures
          2. Adding a Picture Style
          3. Arrange Pictures
          4. Size
        2. Adding Clip Art
        3. Using SmartArt
          1. Creating a SmartArt Graphic from Scratch
          2. Adding a SmartArt Style to Your Graphic
          3. Adding Pictures to a SmartArt Graphic
          4. Using Picture Placeholders in a Shape
          5. Customizing Your SmartArt Graphic
        4. Adding Sounds
        5. Including Movies
        6. Playing with Animations
        7. Animating SmartArt Graphics
        8. Creating Charts and Diagrams
          1. Saving a Chart Template
          2. Chart Formatting Options
      4. 19. Collaborating and Sharing
        1. Using Templates
        2. Working with Windows SharePoint Services
        3. Reviewing, Approving, and Tracking Changes
          1. Adding Comments
          2. Editing and Deleting Comments
        4. Protecting Your Document
        5. Securing Your Presentation
        6. Using the Document Inspector
      5. 20. Working with External Data in PowerPoint 2007
        1. Working with Earlier Versions of PowerPoint
        2. Working with Excel 2007
          1. Create a New Excel 2007 Table in PowerPoint 2007
          2. Add an Existing Excel Table from Excel 2007
        3. Working with Access 2007
          1. Add an Existing Table, Form, Report, or Other Object from Access 2007
          2. Use a Screen Capture to Copy Content from Access 2007
        4. Blocking and Unblocking External Content
        5. Using Trusted Locations
          1. Create a Trusted Location
          2. Remove a Trusted Location
          3. Modify a Trusted Location
        6. Setting Up Security Alerts and Trusted Publishers
      6. 21. Setting Up and Presenting a Slide Show
        1. Learning the Basics
          1. Keep Your Viewers on Track
          2. Copyright Your Work
          3. Secure Your Document When It’s Complete
          4. Verify Your Slide Show Before Delivery
        2. Creating Custom Slide Shows
          1. Create a Basic Custom Show
          2. Create a Hyperlinked Custom Show
          3. Run a Custom Show
        3. Adding Transitions
        4. Using Presenter View
        5. Working with Photo Albums
          1. Publish Your Photo Album to the Web
        6. Exploring Printing Options
    12. 6. Outlook
      1. 22. Introducing Outlook 2007
        1. A New Interface
          1. The Ribbon
          2. The Navigation Pane
          3. The To-Do Bar
          4. Other Interface Changes
        2. Instant Search
        3. Calendar Changes
        4. E-Mail Changes
        5. Color Categories
        6. Collaboration and Sharing Improvements
          1. Integration with Office SharePoint Server
          2. Shared Calendars
          3. Shared Business Cards
        7. Overview of Outlook 2007 Capabilities
          1. Messaging
            1. Exchange Server
            2. Internet E-Mail
            3. HTTP-Based E-Mail
            4. Fax Send and Receive
            5. Extensible E-Mail Support
          2. Scheduling
          3. Contact Management
          4. Task Management
          5. Tracking with the Outlook Journal
          6. Organizing Your Thoughts with Notes
        8. How Outlook Stores Data
          1. Personal Folders—.pst Files
          2. Options for Working Offline
          3. Sharing Storage Files
        9. Understanding Messaging Protocols
          1. SMTP/POP3
          2. IMAP
          3. MAPI
          4. LDAP
          5. NNTP
          6. HTML
          7. MIME
          8. S/MIME
          9. MHTML
          10. iCalendar, vCalendar, and vCard
        10. Security Provisions in Outlook
          1. Protection Against Web Beacons
          2. Attachment and Virus Security
          3. Macro Viruses
          4. Digital Signatures
          5. Message Encryption
          6. Security Labels
          7. Understanding Outlook Service Options
        11. Options for Starting Outlook
          1. Normal Startup
          2. Safe Mode Startup
          3. Starting Outlook Automatically
          4. Adding Outlook to the Quick Launch Bar
          5. Changing the Outlook Shortcut
          6. Using RUNAS to Change User Context
          7. Startup Switches
          8. Choosing a Startup View
          9. Creating Shortcuts to Start New Outlook Items
      2. 23. Finding and Organizing Messages
        1. Finding and Organizing Messages with Search Folders
          1. Using Search Folders
          2. Customizing Search Folders
          3. Creating a New Search Folder
        2. Flagging and Monitoring Messages and Contacts
          1. Flagging Received and Previously Sent Messages
          2. Flagging Outgoing Messages
          3. Viewing and Responding to Flagged Messages
          4. Flagging Contact Items
        3. Grouping Messages by Customizing the Folder View
        4. Filtering a View Using Categories
        5. Managing E-Mail Effectively
      3. 24. Securing Your System, Messages, and Identity
        1. Configuring HTML Message Handling
        2. Protecting Messages with Digital Signatures
          1. Understanding Digital Certificates and Signatures
          2. Obtaining a Digital Certificate
          3. Copying a Certificate to Another Computer
            1. Backing Up Your Certificate
            2. Installing Your Certificate from a Backup
        3. Signing Messages
          1. Understanding S/MIME and Clear-Text Options
          2. Adding Your Digital Signature
          3. Setting Global Security Options
          4. Creating and Using Security Profiles
          5. Reading Signed Messages
          6. Changing Certificate Trust Relationships
          7. Configuring CA Trust
          8. Configuring CA Trust for Multiple Computers
          9. Viewing and Validating a Digital Signature
        4. Encrypting Messages
          1. Getting Ready for Encryption
            1. Swapping Certificates
            2. Obtaining a Recipient’s Public Key from a Public CA
          2. Sending Encrypted Messages
          3. Reading Encrypted Messages
          4. Importing Certificates from Outlook Express
        5. Protecting Data with Information Rights Management
          1. Using Microsoft’s IRM Service
          2. Viewing IRM-Protected Messages
          3. Working with Multiple Accounts
      4. 25. Collaboration with Outlook and Windows SharePoint Services
        1. Understanding Windows SharePoint Services Collaboration
        2. Setting Up Alerts
        3. Working with Shared Documents
          1. Uploading a Document
          2. Creating a Document from the Site
          3. Working with Existing Documents and Version Control
        4. Working with Shared Contacts
          1. Viewing Contacts on a Windows SharePoint Services Site
          2. Linking Windows SharePoint Services 2.0 Contacts Lists to Outlook
          3. Copying Contacts from Windows SharePoint Services 2.0 to Outlook
          4. Copying Contacts from Outlook to Windows SharePoint Services 2.0
        5. Linking a Team Calendar to Outlook
        6. Configuring Alerts in Outlook
          1. Adding Alerts from Outlook
          2. Editing and Deleting Alerts from Outlook
          3. Rules Based on Alerts
        7. Using Outlook to Work with SharePoint Libraries and Files
          1. Connecting a SharePoint Library to Outlook
          2. Downloading Files from a SharePoint Library to Outlook
          3. Opening Files from a SharePoint Site in Outlook
          4. Editing Files from a SharePoint Site in Outlook
          5. Removing SharePoint Files in Outlook
          6. Removing SharePoint Folders in Outlook
          7. Using E-Mail to Add a File to a SharePoint Library
    13. 7. Access
      1. 26. Exploring the New Look of Access 2007
        1. Opening Access for the First Time
        2. Getting Started—A New Look for Access
          1. Opening an Existing Database
          2. Exploring the Microsoft Office Button
          3. Taking Advantage of the Quick Access Toolbar
        3. Understanding Content Security
          1. Temporarily Enabling a Database That Is Not Trusted
          2. Understanding the Trust Center
          3. Enabling Content by Defining Trusted Locations
        4. Understanding the New Ribbon Feature
          1. Home Tab
          2. Create Tab
          3. External Data Tab
          4. Database Tools Tab
        5. Understanding the New Navigation Pane
          1. Exploring Navigation Pane Object Views
          2. Working with Custom Categories and Groups
            1. Exploring the Navigation Options Dialog Box
            2. Creating and Modifying a Custom Category
            3. Creating and Modifying Groups in a Custom Category
            4. Creating Object Shortcuts in Custom Groups
            5. Hiding Custom Groups in a Category
            6. Hiding and Renaming Object Shortcuts
            7. Revealing Hidden Shortcuts
          3. Sorting and Selecting Views in the Navigation Pane
          4. Manually Sorting Objects in the Navigation Pane
          5. Searching for Database Objects
        6. Using the Single-Document vs. Multiple-Document Interface
        7. Modifying Global Settings via the Access Options Dialog Box
      2. 27. Creating Your Database and Tables
        1. Creating a New Database
          1. Using a Database Template to Create a Database
          2. Creating a New Empty Database
        2. Creating Your First Simple Table by Entering Data
        3. Creating a Table Using a Table Template
        4. Creating a Table in Design View
        5. Defining Fields
          1. Understanding Field Data Types
          2. Setting Field Properties
          3. Completing the Fields in the Companies Table
          4. Defining Simple Field Validation Rules
          5. Defining Input Masks
        6. Defining a Primary Key
        7. Defining a Table Validation Rule
        8. Understanding Other Table Properties
        9. Defining Relationships
          1. Defining Your First Relationship
          2. Creating a Relationship on Multiple Fields
        10. Adding Indexes
          1. Single-Field Indexes
          2. Multiple-Field Indexes
        11. Setting Table Design Options
        12. Creating a Default Template for New Databases
        13. Printing a Table Definition
        14. Database Limitations
      3. 28. Creating and Working with Simple Queries
        1. Selecting Data from a Single Table
          1. Specifying Fields
          2. Setting Field Properties
          3. Entering Selection Criteria
            1. Working with Dates and Times in Criteria
            2. AND vs. OR
            3. Between, In, and Like
          4. Using Expressions
            1. Creating Text Expressions
            2. Defining Arithmetic Expressions
          5. Using the Expression Builder
          6. Specifying Field Names
          7. Sorting Data
        2. Testing Validation Rule Changes
          1. Checking a New Field Validation Rule
          2. Checking a New Table Validation Rule
        3. Working in Query Datasheet View
          1. Moving Around and Using Keyboard Shortcuts
          2. Working with Subdatasheets
          3. Changing Data
            1. Understanding Record Indicators
            2. Adding a New Record
            3. Selecting and Changing Data
            4. Replacing Data
            5. Copying and Pasting Data
            6. Deleting Rows
          4. Working with Hyperlinks
            1. Activating a Hyperlink
            2. Inserting a New Hyperlink
            3. Editing an Existing Hyperlink
          5. Sorting and Searching for Data
            1. Sorting Data
            2. Searching For and Filtering Data
              1. Using Find
              2. Filtering by Selection
              3. Using the Filter Window
              4. Using Filter By Form
      4. 29. Building a Form
        1. Forms and Object-Oriented Programming
        2. Starting from Scratch—A Simple Input Form
          1. Building a New Form with Design Tools
            1. The Form Design Tools Contextual Ribbon Tabs
            2. The Field List
            3. The Property Sheet
          2. Building a Simple Input Form for the tblCompanies Table
            1. Moving and Sizing Controls
            2. The Font Group
            3. Setting Border Color, Type, Line Thickness, and Special Effect
            4. Setting Text Box Properties
            5. Setting Label Properties
            6. Setting Form Properties
          3. Customizing Colors and Checking Your Design Results
        3. Working with Quick Create Commands and the Form Wizard
          1. Creating a Form with the Quick Create Commands
          2. Creating the Basic Products Form with the Form Wizard
          3. Modifying the Products Form
        4. Simplifying Data Input with a Form
          1. Taking Advantage of Combo Boxes and List Boxes
          2. Using Toggle Buttons, Check Boxes, and Option Buttons
      5. 30. Constructing a Report
        1. Starting from Scratch—A Simple Report
          1. Building the Report Query
          2. Designing the Report
          3. Grouping Sorting, and Totaling Information
          4. Completing the Report
        2. Using the Report Command
        3. Using the Report Wizard
          1. Specifying Report Wizard Options
          2. Viewing the Result
          3. Modifying a Wizard-Created Report in Layout View
        4. Building a Report in Layout View
          1. Starting with a Blank Report
          2. Adding Grouping and Sorting
          3. Working with Control Layouts
          4. Adding Totals to Records
          5. Applying an AutoFormat
    14. 8. Microsoft Office Programming Primer
      1. 31. VBA Primer
        1. When and Why to Use VBA
        2. Introduction to the VBA Language and Code Structure
          1. Recording Macros
          2. How to Read VBA Code
          3. Statements, Procedures, Modules, and Projects
        3. Understanding and Using the Visual Basic Editor
          1. The Code Window
          2. Project Explorer
          3. The Properties Window
          4. Setting Up Your Workspace
        4. Writing, Editing, and Sharing Simple Macros
          1. Creating Modules and Starting Procedures
          2. Objects, Properties, and Methods
          3. Object Models
          4. Using Auto Lists
          5. Variables
            1. Introducing Variable Data Types
            2. Declaring Variables
            3. Sharing Variables Throughout a Project
            4. Document Variables
            5. Object Model Member Arguments
          6. Constants
          7. Collection Objects
          8. Grouping Statements
          9. Loops
            1. For Each...Next and For...Next Loops
            2. Do Loops
          10. Conditional Structures
          11. Operators
          12. Message Boxes and Input Boxes
            1. Message Boxes
            2. Input Boxes
          13. Running One Macro from Another
          14. Setting Macros to Conditionally Stop Executing Commands
          15. Running Macros and Compiling Projects
            1. Running Macros
            2. Compiling Projects
          16. Understanding Errors
            1. Testing Your Macros and Debugging Errors
          17. Creating Error Handlers
            1. Trapping Individual Errors
          18. Getting Help
          19. Saving and Sharing Macros
            1. Sharing Projects
        5. Using VBA to Save Time on Document Production and Troubleshooting
          1. Using the Immediate Window
        6. Introduction to Using Events
        7. Creating UserForms (Dialog Boxes)
          1. Designing a UserForm
          2. Automating a UserForm
        8. Next Steps for Working with Automation in Microsoft Office
      2. 32. Office Open XML Essentials
        1. Chapter Assumptions
        2. XML Basics for Reading Your Documents
          1. Reading a Markup Language
          2. Understanding Key Terms
          3. XML Editing Options
        3. Getting to Know the Office Open XML Formats
          1. Breaking into Your Document
          2. The Office Open XML File Structure
          3. Taking a Closer Look at Key Document Parts
          4. Building a Basic Word Document from Scratch
            1. Create the Folder Structure
            2. Create the Main Document File
            3. Create the Content_Types File
            4. Create the .rels File
            5. Compile and Open Your New Document
            6. Add More Content Types, Document Parts, and Relationships
        4. Editing and Managing Documents Through XML
          1. Before You Begin Editing a Document Part
          2. Editing Text and Formatting
            1. Edit Text and Settings in document.xml
            2. Add Formatting to Text in document.xml
            3. Edit Custom Styles in styles.xml
          3. Editing Pictures
          4. Removing a Document Part
        5. Customizing the Ribbon
          1. The Basic Components of Ribbon Customization
          2. Adding a Ribbon Tab
          3. Add a Group to a Built-In Ribbon Tab
        6. Binding Data to Content Controls
          1. The Components of a Bound Content Control
          2. Binding a Control to Custom XML
            1. Create the Custom XML Files
            2. Binding Custom XML to Content Controls
        7. Next Steps for Working with the Office Open XML Formats
    15. A. Appendix: Installing and Configuring the 2007 Office System
      1. Installing the Microsoft Office System from the CD
      2. Changing Your 2007 Office System Setup
        1. Changing Your Setup from Control Panel
        2. Changing Setup and Getting Updates from the Options Dialog Box
    16. B. Index to Troubleshooting Topics
    17. C. About the Authors
    18. D. Choose the Right Book for You
    19. Index
    20. About the Author
    21. SPECIAL OFFER: Upgrade this ebook with O’Reilly