1. Word 2007

   1. Chapter 1 Creating, Opening, and Saving Documents

      1. What Word Does
      2. Launching Word
      3. Creating a New Document
      4. Opening an Existing Document
      5. Your Different Document Views
      6. Saving and Closing Documents

   2. Chapter 2 Entering and Editing Text

      1. Typing in Word
      2. Selecting Text
      3. Cutting, Copying, and Pasting
      4. Finding and Replacing Text
      5. Saving Keystrokes with Quick Parts

   3. Chapter 3 Formatting Text, Paragraphs, and Headings

      1. Formatting Basics
      2. Formatting Characters
      3. Formatting Paragraphs
      4. Creating Bulleted and Numbered Lists
      5. Setting Tabs
      6. Using Word's Rulers
      7. Fast Formatting with Format Painter
      8. Formatting with Styles
      9. Modifying Styles
      10. Managing Style Sets

   4. Chapter 4 Setting Up the Document

      1. Choosing Paper Size and Layout
      2. Setting Document Margins
      3. Applying Page Borders
      4. Adding Headers and Footers
      5. Working with Multiple Columns
      6. Hyphenation
      7. Dividing Your Document into Sections

   5. Chapter 5 Themes and Templates

      1. Choosing a Theme
      2. Choosing a Template

   6. Chapter 6 Spelling, Grammar, and Reference Tools

      1. Turning on Spelling and Grammar Checking
      2. Checking Spelling
      3. Checking Grammar and Style
      4. Controlling AutoCorrect
      5. Exploring Word's Research Tools
      6. Accessing Word's Thesaurus
      7. Translating Text
      8. Checking Your Word Count

   7. Chapter 7 Printing Word Documents

      1. Quick and Easy Printing
      2. Print Preview
      3. Choosing a Printer
      4. Printing to an Adobe PDF File
      5. Faxing with Word
      6. Changing Print Settings
      7. Printing Envelopes
      8. Printing Labels
      9. >Setting Print Options

   8. Chapter 8 Planning with Outlines

      1. Switching to Outline View
      2. Promoting and Demoting Headings
      3. Moving Outline Items
      4. Showing Parts of Your Outline

2. Excel 2007

   1. Chapter 9 Creating and Navigating Worksheets

      1. What You Can Do with Excel
      2. Excel's New Features
      3. Creating a Basic Worksheet
      4. Editing Data
      5. Navigating in Excel
      6. Saving Files
      7. Opening Files

   2. Chapter 10 Adding Information to Worksheets

      1. Adding Different Types of Data
      2. Quick Ways to Add Data

   3. Chapter 11 Moving Data Around a Worksheet

      1. Selecting Cells
      2. Moving Cells Around
      3. Adding and Moving Columns or Rows

   4. Chapter 12 Managing Worksheets and Workbooks

      1. Worksheets and Workbooks
      2. Find and Replace
      3. Spell Check

   5. Chapter 13 Formatting Cells

      1. Formatting Cell Values
      2. Formatting Cell Appearance

   6. Chapter 14 Viewing and Printing Worksheets

      1. Controlling Your View
      2. Printing
      3. Controlling Pagination

   7. Chapter 15 Building Basic Formulas

      1. Creating a Basic Formula
      2. Formula Shortcuts
      3. Copying Formulas

   8. Chapter 16 Tables and Charts

      1. The Basics of Tables
      2. Sorting and Filtering a Table
      3. Charting 101

3. PowerPoint 2007

   1. Chapter 17 Creating a Basic Presentation

      1. What You Can Do with PowerPoint 2007
      2. What's New in PowerPoint 2007
      3. Beginning a New Presentation
      4. Choosing a Theme for Your Presentation
      5. Adding Text
      6. Adding More Slides
      7. Moving Around Inside a Presentation

   2. Chapter 18 Editing Slides

      1. Editing Text
      2. Reversing an Action (Undo)
      3. Finding and Replacing Text Automatically
      4. Checking Spelling
      5. Adding Special Characters

   3. Chapter 19 Formatting and Aligning Your Text

      1. Automating Text Formatting
      2. Manually Formatting Text Appearance
      3. Manually Aligning and Indenting Text
      4. Formatting Text Boxes

   4. Chapter 20 Formatting and Laying Out Your Slides

      1. Changing Slide Layout
      2. Changing Background Color
      3. Reapplying Themes, Colors, and Fonts

   5. Chapter 21 Editing Your Slideshow

      1. Viewing Multiple Slides
      2. Adding, Deleting, and Moving Slides
      3. Inserting Slides from Other Slideshows
      4. Editing Slide and Layout Masters
      5. Adding Headers and Footers

   6. Chapter 22 Adding Charts, Diagrams, and Tables

      1. Creating Charts
      2. Creating Diagrams
      3. Creating Tables

   7. Chapter 23 Delivering Presentations

      1. Setting Up a Slideshow
      2. Slideshows for Multiple Audiences
      3. Presenting Your Slideshow
      4. Creating PowerPoint Shows
      5. Emailing Your Presentation
      6. Packaging Presentations for CD

   8. Chapter 24 Printing Presentations

      1. Printing Slides (One Slide per Page)
      2. Handouts (Multiple Slides per Page)
      3. Overhead Transparencies
      4. Speaker Notes
      5. Presentation Outline

   9. Chapter 25 Images and Transitions

      1. Drawing on Slides
      2. Adding Pictures from Other Programs
      3. Slide Transitions

4. Access 2007

   1. Chapter 26 Creating Your First Database

      1. What You Can Do with Access
      2. Understanding Access Databases
      3. Getting Started
      4. Saving and Opening Access Databases
      5. The Navigation Pane

   2. Chapter 27 Building Smarter Tables

      1. Understanding Data Types
      2. Design View
      3. Access Data Types
      4. The Primary Key
      5. Six Principles of Database Design

   3. Chapter 28 Mastering the Datasheet

      1. Datasheet Customization
      2. Datasheet Navigation
      3. Printing the Datasheet

   4. Chapter 29 Blocking Bad Data

      1. Data Integrity Basics
      2. Input Masks
      3. Validation Rules
      4. Lookups

   5. Chapter 30 Linking Tables with Relationships

      1. Relationship Basics
      2. Using a Relationship

   6. Chapter 31 Queries: Reusable Searches

      1. Query Basics
      2. Creating Queries
      3. Understanding Action Queries

   7. Chapter 32 Creating Reports

      1. Report Basics
      2. Printing, Previewing, and Exporting a Report
      3. Formatting a Report
      4. Filtering and Sorting a Report

   8. Chapter 33 Creating Simple Forms

      1. Form Basics
      2. Sorting and Filtering in a Form
      3. The Form Wizard

   9. Chapter 34 Importing and Exporting Data

      1. The Case for Importing and Exporting
      2. Using the Clipboard
      3. Import and Export Operations

5. Appendixes

   1. Appendix A Customizing the Quick Access Toolbar

      1. The Quick Access Toolbar

   2. Appendix B Getting Help

      1. Using Office 2007's Built-in Help
      2. Using Microsoft's Office Web Site
      3. Third-Party Web Sites

1. Colophon

Sanders Kleinfeld and Marlowe Shaeffer provided quality control for Office 2007: The Missing Manual. Michele Fishie wrote the index for the Word section. Lucie Haskins wrote the index for the Access section. Dawn Mann wrote the index for the Excel and PowerPoint sections.

The cover of this book is based on a series design originally created by David Freedman and modified by Mike Kohnke, Karen Montgomery, and Fitch (www.fitch.com). Back cover design, dog illustration, and color selection by Fitch.

David Futato designed the interior layout, based on a series design by Phil Simpson. This book was converted to FrameMaker 5.5.6 and prepared for layout by Abby Fox. The text font is Adobe Minion; the heading font is Adobe Formata Condensed; and the code font is LucasFont's TheSans Mono Condensed. The illustrations that appear in the book were produced by Robert Romano and Jessamyn Read using Macromedia FreeHand MX and Adobe Photoshop CS.