You are previewing Office 2007: The Missing Manual.
O'Reilly logo
Office 2007: The Missing Manual

Book Description

Quickly learn the most useful features of Microsoft Office 2007 with our easy to read four-in-one guide. This fast-paced book gives you the basics of Word, Excel, PowerPoint and Access so you can start using the new versions of these major Office applications right away. Unlike every previous version, Office 2007 offers a completely redesigned user interface for each program. Microsoft has replaced the familiar menus with a new tabbed toolbar (or "ribbon"), and added other features such as "live preview" that lets you see exactly what each option will look like in the document before you choose it. This is good news for longtime users who never knew about some amazing Office features because they were hidden among cluttered and outdated menus. Adapting to the new format is going to be a shock -- especially if you're a longtime user. That's where Office 2007: The Missing Manual comes in. Rather than present a lot of arcane detail, this quick & friendly primer teaches you how to work with the most-used Office features, with four separate sections covering the four programs. The book offers a walkthrough of Microsoft's redesigned Office user interface before taking you through the basics of creating text documents, spreadsheets, presentations, and databases with:

  • Clear explanations

  • Step-by-step instructions

  • Lots of illustrations

  • Plenty of friendly advice

It's a great way to master all 4 programs without having to stock up on a shelf-load of different books. This book has everything you need to get you up to speed fast. Office 2007: The Missing Manual is truly the book that should have been in the box.

Table of Contents

  1. Office 2007: The Missing Manual
    1. SPECIAL OFFER: Upgrade this ebook with O’Reilly
    2. The Missing Credits
      1. About the Author
      2. About the Creative Team
      3. Acknowledgements
      4. The Missing Manual Series
    3. Introduction
      1. What's New in Office 2007
        1. The Ribbon
          1. Tabs
          2. Groups
          3. Command buttons
          4. Dialog box launchers
        2. Using the Ribbon with the Keyboard
        3. The Office Menu
        4. The Quick Access Toolbar
        5. Live Preview
        6. Mini-Toolbar
      2. The Very Basics
      3. About This Book
        1. About the Outline
        2. About → These → Arrows
          1. Drop-down buttons
        3. Examples
        4. About MissingManuals.com
        5. Safari® Enabled
    4. I. Word 2007
      1. 1. Creating, Opening, and Saving Documents
        1. 1. What Word Does
          1. 1.1. The New Word
        2. 2. Launching Word
        3. 3. Creating a New Document
          1. 3.1. Creating a New Blank Document
          2. 3.2. Creating a New Document from an Existing Document
          3. 3.3. Creating a New Document from a Template
        4. 4. Opening an Existing Document
        5. 5. Your Different Document Views
          1. 5.1. Document Views: Five Ways to Look at Your Manuscript
          2. 5.2. Show and Hide Window Tools
          3. 5.3. Zooming Your View In and Out
            1. 5.3.1. Zooming by percentage
            2. 5.3.2. Zooming relative to page or text
            3. 5.3.3. Changing page view from the ribbon
          4. 5.4. The Window Group: Doing the Splits
            1. 5.4.1. Viewing multiple windows
        6. 6. Saving and Closing Documents
          1. 6.1. The Many Ways to Save Documents
            1. 6.1.1. Saving by keyboard shortcut
            2. 6.1.2. Saving by menu command
            3. 6.1.3. Saving with a new name
      2. 2. Entering and Editing Text
        1. 1. Typing in Word
          1. 1.1. Click and Type for Quick Formatting
        2. 2. Selecting Text
          1. 2.1. Selecting with the Mouse
          2. 2.2. Selecting with the Keyboard
          3. 2.3. Extending a Selection
          4. 2.4. Selecting Multiple Chunks of Text in Different Places
          5. 2.5. Moving Around Your Document
          6. 2.6. Keyboarding Around Your Document
          7. 2.7. Using the Scroll Bars
          8. 2.8. Browsing by Headings and Other Objects
          9. 2.9. Browsing by Bookmark
            1. 2.9.1. Creating bookmarks
            2. 2.9.2. Jumping to bookmarks
            3. 2.9.3. Deleting bookmarks
        3. 3. Cutting, Copying, and Pasting
          1. 3.1. Editing with the Ribbon
          2. 3.2. Editing with Keyboard Shortcuts
          3. 3.3. Editing with the Mouse
          4. 3.4. Moving Text Between Two Documents
          5. 3.5. Viewing and Pasting Clippings
        4. 4. Finding and Replacing Text
        5. 5. Saving Keystrokes with Quick Parts
      3. 3. Formatting Text, Paragraphs, and Headings
        1. 1. Formatting Basics
        2. 2. Formatting Characters
          1. 2.1. Formatting with the Ribbon or the Font Dialog Box
          2. 2.2. Formatting with the Mini-Toolbar
          3. 2.3. Formatting with Keyboard Shortcuts
          4. 2.4. Changing Capitalization
            1. 2.4.1. Small caps for headers
        3. 3. Formatting Paragraphs
          1. 3.1. Aligning Text
          2. 3.2. Indenting Paragraphs
          3. 3.3. Spacing Between Paragraphs
          4. 3.4. Spacing Between Lines
          5. 3.5. Inserting Page Breaks and Line Breaks
        4. 4. Creating Bulleted and Numbered Lists
          1. 4.1.
            1. 4.1.1. Bulleted paragraphs
            2. 4.1.2. Customizing bullets
            3. 4.1.3. Numbered paragraphs
            4. 4.1.4. Multilevel lists
        5. 5. Setting Tabs
          1. 5.1. How Tab Stops Work
          2. 5.2. Viewing Tab Marks in Your Text
          3. 5.3. Deleting and Editing Tabs
          4. 5.4. Types of Tabs
          5. 5.5. Tab Leaders
        6. 6. Using Word's Rulers
          1. 6.1. Managing Tab Settings with the Ruler
            1. 6.1.1. Setting tab stops
            2. 6.1.2. Adjusting and removing tab stops with the ruler
          2. 6.2. Setting Margins with the Ruler
          3. 6.3. Adjusting Paragraph Indents with the Ruler
        7. 7. Fast Formatting with Format Painter
        8. 8. Formatting with Styles
          1. 8.1. Applying Quick Styles
        9. 9. Modifying Styles
        10. 10. Managing Style Sets
          1. 10.1. Creating Your Own Style Set
      4. 4. Setting Up the Document
        1. 1. Choosing Paper Size and Layout
          1. 1.1. Changing Paper Size
            1. 1.1.1. Customizing paper size and source
          2. 1.2. Setting Paper Orientation
        2. 2. Setting Document Margins
          1. 2.1. Selecting Preset Margins
          2. 2.2. Setting Custom Margins
          3. 2.3. Setting Margins for Booklets
        3. 3. Applying Page Borders
        4. 4. Adding Headers and Footers
          1. 4.1. Introducing the Header and Footer Tools
          2. 4.2. Inserting and Modifying a Header Building Block
          3. 4.3. Adding a Matching Footer Building Block
          4. 4.4. Creating Custom Headers and Footers
          5. 4.5. Removing Headers, Footers, and Page Numbers
        5. 5. Working with Multiple Columns
          1. 5.1. Customizing Columns
        6. 6. Hyphenation
          1. 6.1. Automatic Hyphenation
          2. 6.2. Removing Hyphenation from Your Document
        7. 7. Dividing Your Document into Sections
          1. 7.1. Inserting Section Breaks
      5. 5. Themes and Templates
        1. 1. Choosing a Theme
          1. 1.1. Finding More Themes
            1. 1.1.1. Browsing for themes on your computer
            2. 1.1.2. Searching for themes online
        2. 2. Choosing a Template
          1. 2.1. Starting a Document from a Template
          2. 2.2. Using Installed Templates
      6. 6. Spelling, Grammar, and Reference Tools
        1. 1. Turning on Spelling and Grammar Checking
        2. 2. Checking Spelling
          1. 2.1. Checking Spelling As You Type
          2. 2.2. Checking Spelling Manually
          3. 2.3. Managing Custom Dictionaries
            1. 2.3.1. Removing a word from your custom dictionary
            2. 2.3.2. Adding professional dictionaries to Word
        3. 3. Checking Grammar and Style
        4. 4. Controlling AutoCorrect
          1. 4.1. How AutoCorrect Works
          2. 4.2. Fine-tuning AutoCorrect Options
          3. 4.3. Autocorrecting Math, Formatting, and Smart Tags
        5. 5. Exploring Word's Research Tools
          1. 5.1. Finding Information with the Research Task Pane
        6. 6. Accessing Word's Thesaurus
        7. 7. Translating Text
          1. 7.1. Translation ScreenTips
        8. 8. Checking Your Word Count
      7. 7. Printing Word Documents
        1. 1. Quick and Easy Printing
        2. 2. Print Preview
        3. 3. Choosing a Printer
          1. 3.1. Setting Your Default Printer
          2. 3.2. Exploring Printer-Specific Properties
        4. 4. Printing to an Adobe PDF File
        5. 5. Faxing with Word
        6. 6. Changing Print Settings
          1. 6.1. Printing Part of Your Document
          2. 6.2. Printing and Collating Multiple Copies
          3. 6.3. Printing on Both Sides of the Page
        7. 7. Printing Envelopes
        8. 8. Printing Labels
        9. 9. >Setting Print Options
      8. 8. Planning with Outlines
        1. 1. Switching to Outline View
        2. 2. Promoting and Demoting Headings
          1. 2.1. Controlling Subheads During Promotion or Demotion
        3. 3. Moving Outline Items
        4. 4. Showing Parts of Your Outline
          1. 4.1. Expanding and Collapsing Levels
          2. 4.2. Showing and Hiding Text
          3. 4.3. Showing Only the First Line
          4. 4.4. Showing Text Formatting
    5. II. Excel 2007
      1. 9. Creating and Navigating Worksheets
        1. 1. What You Can Do with Excel
        2. 2. Excel's New Features
        3. 3. Creating a Basic Worksheet
          1. 3.1. Starting a New Workbook
          2. 3.2. Adding the Column Titles
          3. 3.3. Adding Data
        4. 4. Editing Data
        5. 5. Navigating in Excel
          1. 5.1. The Tabs of the Ribbon
          2. 5.2. The Formula Bar
          3. 5.3. The Status Bar
          4. 5.4. Excel Options
        6. 6. Saving Files
          1. 6.1. The Excel 2007 File Format
          2. 6.2. Saving Your Spreadsheet in Older Formats
          3. 6.3. Saving Your Spreadsheet As a PDF
          4. 6.4. Disaster Recovery
        7. 7. Opening Files
          1. 7.1. Opening Multiple Spreadsheets at Once
      2. 10. Adding Information to Worksheets
        1. 1. Adding Different Types of Data
          1. 1.1. Controlling Your Data Types
            1. 1.1.1. How Excel decides your data is text
            2. 1.1.2. How Excel decides your data is numeric
            3. 1.1.3. How Excel decides your data is a date or time
        2. 2. Quick Ways to Add Data
          1. 2.1. AutoComplete
          2. 2.2. AutoCorrect
          3. 2.3. AutoFill
            1. 2.3.1. Custom AutoFill lists
          4. 2.4. AutoFit
          5. 2.5. Redo
      3. 11. Moving Data Around a Worksheet
        1. 1. Selecting Cells
          1. 1.1. Making Continuous Range Selections
          2. 1.2. Making Non-Contiguous Selections
          3. 1.3. Automatically Selecting Your Data
          4. 1.4. Making Selections with the Keyboard
        2. 2. Moving Cells Around
          1. 2.1. A Simple Cut-and-Paste or Copy-and-Paste
          2. 2.2. A Fancy Cut-and-Paste or Copy-and-Paste
          3. 2.3. The Clipboard
          4. 2.4. Special Pasting
        3. 3. Adding and Moving Columns or Rows
          1. 3.1. Inserting Columns
          2. 3.2. Inserting Rows
          3. 3.3. Inserting Copied or Cut Cells
          4. 3.4. Deleting Columns and Rows
      4. 12. Managing Worksheets and Workbooks
        1. 1. Worksheets and Workbooks
          1. 1.1. Adding, Removing, and Hiding Worksheets
          2. 1.2. Naming and Rearranging Worksheets
        2. 2. Find and Replace
          1. 2.1. The Basic Find
          2. 2.2. Find All
          3. 2.3. More Advanced Searches
          4. 2.4. Finding Formatted Cells
          5. 2.5. Finding and Replacing Values
        3. 3. Spell Check
          1. 3.1. Spell Checking Options
      5. 13. Formatting Cells
        1. 1. Formatting Cell Values
          1. 1.1. Formatting Numbers
            1. 1.1.1. General
            2. 1.1.2. Number
            3. 1.1.3. Currency
            4. 1.1.4. Accounting
            5. 1.1.5. Percentage
            6. 1.1.6. Fraction
            7. 1.1.7. Scientific
            8. 1.1.8. Text
          2. 1.2. Formatting Dates and Times
          3. 1.3. Special Formats for Special Numbers
        2. 2. Formatting Cell Appearance
          1. 2.1. Alignment and Orientation
          2. 2.2. Fonts and Color
            1. 2.2.1. Special characters
          3. 2.3. Borders and Fills
          4. 2.4. Drawing Borders by Hand
      6. 14. Viewing and Printing Worksheets
        1. 1. Controlling Your View
          1. 1.1. Zooming
          2. 1.2. Viewing Distant Parts of a Spreadsheet at Once
          3. 1.3. Freezing Columns or Rows
          4. 1.4. Hiding Data
          5. 1.5. Saving View Settings
        2. 2. Printing
          1. 2.1. How to Print an Excel File
          2. 2.2. Quick Printing
          3. 2.3. Previewing Your Printout
          4. 2.4. Creating Headers and Footers
          5. 2.5. Customizing Print Settings
            1. 2.5.1. Margins
            2. 2.5.2. Paper size and orientation
            3. 2.5.3. Sheet settings
        3. 3. Controlling Pagination
          1. 3.1. Page Breaks
          2. 3.2. Scaling
          3. 3.3. Page Break Preview: A Bird's-Eye View of Your Worksheet
      7. 15. Building Basic Formulas
        1. 1. Creating a Basic Formula
          1. 1.1. Excel's Order of Operations
          2. 1.2. Cell References
          3. 1.3. How Excel Formats Cells That Contain Cell References
          4. 1.4. Functions
            1. 1.4.1. Using a function in a formula
            2. 1.4.2. Using cell references with a function
            3. 1.4.3. Using cell ranges with a function
          5. 1.5. Formula Errors
          6. 1.6. Logical Operators
        2. 2. Formula Shortcuts
          1. 2.1. Point-and-Click Formula Creation
          2. 2.2. Point-and-Click Formula Editing
          3. 2.3. The Formulas Tab
          4. 2.4. Using the Insert Function Button
        3. 3. Copying Formulas
          1. 3.1. Absolute Cell References
          2. 3.2. Partially Fixed References
      8. 16. Tables and Charts
        1. 1. The Basics of Tables
          1. 1.1. Creating a Table
          2. 1.2. Formatting a Table
          3. 1.3. Editing a Table
          4. 1.4. Selecting Parts of a Table
        2. 2. Sorting and Filtering a Table
          1. 2.1. Applying a Simple Sort Order
          2. 2.2. Sorting with Multiple Criteria
          3. 2.3. Filtering with the List of Values
          4. 2.4. Creating Smarter Filters
            1. 2.4.1. Filtering dates
            2. 2.4.2. Filtering numbers
            3. 2.4.3. Filtering text
        3. 3. Charting 101
          1. 3.1. Embedded and Standalone Charts
          2. 3.2. Creating a Chart with the Ribbon
          3. 3.3. The Chart Tools Ribbon Tabs
          4. 3.4. Printing Charts
    6. III. PowerPoint 2007
      1. 17. Creating a Basic Presentation
        1. 1. What You Can Do with PowerPoint 2007
        2. 2. What's New in PowerPoint 2007
          1. 2.1. New File Formats
          2. 2.2. Improved Graphics
          3. 2.3. More Theme Options
        3. 3. Beginning a New Presentation
          1. 3.1. Creating a New Presentation from Scratch
          2. 3.2. Creating a Presentation from an Existing Template, Theme, or Presentation
            1. 3.2.1. From an existing template
            2. 3.2.2. From an existing (built-in) theme
            3. 3.2.3. From an existing presentation
            4. 3.2.4. The New from Existing Presentation window
            5. 3.2.5. The Open window
        4. 4. Choosing a Theme for Your Presentation
        5. 5. Adding Text
          1. 5.1. Adding Text to an Existing Text Box
          2. 5.2. Adding a New Text Box
        6. 6. Adding More Slides
        7. 7. Moving Around Inside a Presentation
          1. 7.1. Navigating with the Scroll Bar
          2. 7.2. Navigation with the Slides and Outline Tabs
          3. 7.3. Using Find
          4. 7.4. Adding Speaker Notes
          5. 7.5. Creating and Printing Handouts
          6. 7.6. Saving and Closing a Presentation
          7. 7.7. Running a Presentation
      2. 18. Editing Slides
        1. 1. Editing Text
          1. 1.1. Selecting Text
          2. 1.2. Cutting Text
          3. 1.3. Copying Text
          4. 1.4. Pasting Text
            1. 1.4.1. Automatically pasting the last chunk of text you cut (or copied)
            2. 1.4.2. Choosing what to paste
            3. 1.4.3. Choosing how to paste
          5. 1.5. Moving Text
          6. 1.6. Deleting Text
        2. 2. Reversing an Action (Undo)
        3. 3. Finding and Replacing Text Automatically
        4. 4. Checking Spelling
          1. 4.1.
            1. 4.1.1. Setting up spelling
            2. 4.1.2. Automatic (continuous) spell checking
            3. 4.1.3. Manual spell checking
        5. 5. Adding Special Characters
      3. 19. Formatting and Aligning Your Text
        1. 1. Automating Text Formatting
          1. 1.1. Using AutoFormat
          2. 1.2. Using AutoFit
        2. 2. Manually Formatting Text Appearance
          1. 2.1. Changing the Font
          2. 2.2. Changing Font Size
          3. 2.3. Bolding, Italicizing, and Underlining Text
          4. 2.4. Changing Text Color and Background Color
          5. 2.5. Adding Special Text Effects
        3. 3. Manually Aligning and Indenting Text
          1. 3.1. Aligning Text and Creating Columns
          2. 3.2. Creating Lists
            1. 3.2.1. Customizing bulleted lists
            2. 3.2.2. Customizing numbered lists
            3. 3.2.3. Changing Indents
          3. 3.3. Changing Tab Stops
          4. 3.4. Changing Text Direction
            1. 3.4.1. Using the Text Direction option
        4. 4. Formatting Text Boxes
      4. 20. Formatting and Laying Out Your Slides
        1. 1. Changing Slide Layout
          1. 1.1. Applying a Layout
          2. 1.2. Switching Orientation from Landscape to Portrait (and Back)
          3. 1.3. Repositioning Text Boxes
          4. 1.4. Help for Positioning Text Boxes: Zoom, Guides, and Grid
        2. 2. Changing Background Color
          1. 2.1. Adding a Gradient Effect
        3. 3. Reapplying Themes, Colors, and Fonts
          1. 3.1. Reapplying a Theme
          2. 3.2. Reapplying a Color Scheme
          3. 3.3. Reapplying a Font
      5. 21. Editing Your Slideshow
        1. 1. Viewing Multiple Slides
          1. 1.1. Slides Pane
          2. 1.2. Slide Sorter View
        2. 2. Adding, Deleting, and Moving Slides
          1. 2.1. Adding Blank Slides
          2. 2.2. Deleting Slides
          3. 2.3. Moving Slides
          4. 2.4. Duplicating Slides
          5. 2.5. Cutting, Copying, and Pasting Slides
        3. 3. Inserting Slides from Other Slideshows
        4. 4. Editing Slide and Layout Masters
          1. 4.1. Applying Multiple Slide Masters
        5. 5. Adding Headers and Footers
          1. 5.1. Adding Footers to Your Slides
          2. 5.2. Adding Headers and Footers to Notes Pages and Handouts
      6. 22. Adding Charts, Diagrams, and Tables
        1. 1. Creating Charts
          1. 1.1. Choosing a Chart Type
          2. 1.2. Creating a Chart
          3. 1.3. Customizing Charts with Prebuilt Layouts and Styles
            1. 1.3.1. Applying prebuilt Chart Layouts
            2. 1.3.2. Applying prebuilt Chart Styles
            3. 1.3.3. Customizing chart titles
        2. 2. Creating Diagrams
          1. 2.1. Adding Diagrams to Slides
          2. 2.2. Turning Lists into Diagrams
          3. 2.3. Applying Prebuilt Styles and Color Themes to Diagrams
          4. 2.4. Tweaking Diagrams
            1. 2.4.1. Adding titles
            2. 2.4.2. Switching to a different type of diagram
            3. 2.4.3. Changing diagram text
        3. 3. Creating Tables
          1. 3.1. Creating a Basic Table
            1. 3.1.1. Creating rows and columns
            2. 3.1.2. Selecting cells, rows, and columns
            3. 3.1.3. Selecting entire tables
            4. 3.1.4. Adding data
            5. 3.1.5. Adding a title
            6. 3.1.6. Adding column headings
          2. 3.2. Tweaking Tables
            1. 3.2.1. Applying prebuilt styles
            2. 3.2.2. Highlighting rows and columns
            3. 3.2.3. Inserting and deleting rows and columns
            4. 3.2.4. Changing the width of a row or column
            5. 3.2.5. Aligning data inside cells
            6. 3.2.6. Merging (and splitting) cells
          3. 3.3. Resizing Tables
          4. 3.4. Repositioning Tables
          5. 3.5. Deleting Tables
      7. 23. Delivering Presentations
        1. 1. Setting Up a Slideshow
          1. 1.1. Choosing a Slideshow Mode
            1. 1.1.1. Full-screen mode
            2. 1.1.2. Browser mode
            3. 1.1.3. Kiosk mode
          2. 1.2. Hiding Individual Slides
          3. 1.3. Setting Up a Speaker Notes Screen
          4. 1.4. Setting Up Automatic Timing
          5. 1.5. Looping Continuously
        2. 2. Slideshows for Multiple Audiences
          1. 2.1. Creating a Custom Slideshow
          2. 2.2. Editing a Custom Slideshow
        3. 3. Presenting Your Slideshow
        4. 4. Creating PowerPoint Shows
        5. 5. Emailing Your Presentation
        6. 6. Packaging Presentations for CD
      8. 24. Printing Presentations
        1. 1. Printing Slides (One Slide per Page)
        2. 2. Handouts (Multiple Slides per Page)
        3. 3. Overhead Transparencies
        4. 4. Speaker Notes
        5. 5. Presentation Outline
      9. 25. Images and Transitions
        1. 1. Drawing on Slides
          1. 1.1. Drawing Lines and Shapes
          2. 1.2. Drawing Connectors
        2. 2. Adding Pictures from Other Programs
          1. 2.1. Inserting a Picture Stored on Your Computer
          2. 2.2. Adding Built-in Clip Art Drawings
        3. 3. Slide Transitions
          1. 3.1. Types of Transitions
          2. 3.2. Adding Transitions Between Slides
    7. IV. Access 2007
      1. 26. Creating Your First Database
        1. 1. What You Can Do with Access
          1. 1.1. The Two Sides of Access
          2. 1.2. Access vs. Excel
        2. 2. Understanding Access Databases
        3. 3. Getting Started
          1. 3.1. Creating a New Database
          2. 3.2. Understanding Tables
          3. 3.3. Creating a Simple Table
          4. 3.4. Editing a Table
            1. 3.4.1. Edit mode
            2. 3.4.2. Shortcut keys
            3. 3.4.3. Cut, copy, and paste
        4. 4. Saving and Opening Access Databases
          1. 4.1. Making Backups
          2. 4.2. Saving a Database with a Different Name or Format
          3. 4.3. Opening a Database
          4. 4.4. Opening More Than One Database at Once
          5. 4.5. Opening a Database Created in an Older Version of Access
          6. 4.6. Creating Another Database
        5. 5. The Navigation Pane
          1. 5.1. Browsing Tables with the Navigation Pane
          2. 5.2. Managing Database Objects
      2. 27. Building Smarter Tables
        1. 1. Understanding Data Types
        2. 2. Design View
          1. 2.1. Organizing and Describing Your Fields
          2. 2.2. How Updates Work in Design View
        3. 3. Access Data Types
          1. 3.1. Text
            1. 3.1.1. Text length
          2. 3.2. Memo
            1. 3.2.1. Formatted text
          3. 3.3. Number
            1. 3.3.1. Number size
            2. 3.3.2. Number formatting
          4. 3.4. Currency
          5. 3.5. Date/Time
          6. 3.6. Yes/No
          7. 3.7. Hyperlink
          8. 3.8. Attachment
          9. 3.9. AutoNumber
            1. 3.9.1. Using AutoNumbers without revealing the size of your table
            2. 3.9.2. Using Replication IDs
        4. 4. The Primary Key
          1. 4.1. Creating Your Own Primary Key Field
        5. 5. Six Principles of Database Design
          1. 5.1. 1. Choose Good Field Names
          2. 5.2. 2. Break Down Your Information
          3. 5.3. 3. Include All the Details in One Place
          4. 5.4. 4. Avoid Duplicating Information
          5. 5.5. 5. Avoid Redundant Information
          6. 5.6. 6. Include an ID Field
      3. 28. Mastering the Datasheet
        1. 1. Datasheet Customization
          1. 1.1. Formatting the Datasheet
          2. 1.2. Rearranging Columns
          3. 1.3. Resizing Rows and Columns
          4. 1.4. Hiding Columns
          5. 1.5. Freezing Columns
        2. 2. Datasheet Navigation
          1. 2.1. Sorting
            1. 2.1.1. Sorting on multiple fields
          2. 2.2. Filtering
            1. 2.2.1. Quick filters
            2. 2.2.2. Filter by selection
            3. 2.2.3. Filter by condition
          3. 2.3. Searching
        3. 3. Printing the Datasheet
          1. 3.1. Print Preview
            1. 3.1.1. Moving around the print preview
            2. 3.1.2. Changing the page layout
          2. 3.2. Fine-Tuning a Printout
      4. 29. Blocking Bad Data
        1. 1. Data Integrity Basics
          1. 1.1. Preventing Blank Fields
            1. 1.1.1. Blank values and empty text
          2. 1.2. Setting Default Values
          3. 1.3. Preventing Duplicate Values with Indexes
            1. 1.3.1. Multifield indexes
        2. 2. Input Masks
          1. 2.1. Using a Ready-Made Mask
        3. 3. Validation Rules
          1. 3.1. Applying a Field Validation Rule
          2. 3.2. Writing a Field Validation Rule
            1. 3.2.1. Validating numbers
            2. 3.2.2. Validating dates
            3. 3.2.3. Validating text
            4. 3.2.4. Combining validation conditions
          3. 3.3. Creating a Table Validation Rule
        4. 4. Lookups
          1. 4.1. Creating a Simple Lookup with Fixed Values
          2. 4.2. Adding New Values to Your Lookup List
      5. 30. Linking Tables with Relationships
        1. 1. Relationship Basics
          1. 1.1. Redundant Data vs. Related Data
          2. 1.2. Matching Fields: The Relationship Link
          3. 1.3. Linking with the ID Column
          4. 1.4. The Parent-Child Relationship
        2. 2. Using a Relationship
          1. 2.1. Defining a Relationship
          2. 2.2. Editing Relationships
          3. 2.3. Referential Integrity
            1. 2.3.1. Blank values for unlinked records
            2. 2.3.2. Cascading deletes
            3. 2.3.3. Cascading updates
          4. 2.4. Navigating a Relationship
          5. 2.5. Lookups with Related Tables
      6. 31. Queries: Reusable Searches
        1. 1. Query Basics
        2. 2. Creating Queries
          1. 2.1. Creating a Query in Design View
            1. 2.1.1. Building filter expressions
            2. 2.1.2. Getting the top records
          2. 2.2. Creating a Simple Query with the Query Wizard
        3. 3. Understanding Action Queries
          1. 3.1. Testing Action Queries (Carefully)
          2. 3.2. The Action Query Family
      7. 32. Creating Reports
        1. 1. Report Basics
          1. 1.1. Creating a Simple Report
          2. 1.2. Arranging a Report
          3. 1.3. Adding and Removing Fields
          4. 1.4. The Many Views of a Report
          5. 1.5. Creating a Report from Scratch
        2. 2. Printing, Previewing, and Exporting a Report
          1. 2.1. Previewing a Report
          2. 2.2. Exporting a Report
          3. 2.3. Getting the "Save As PDF" Add-in
        3. 3. Formatting a Report
          1. 3.1. Formatting Columns and Column Headers
            1. 3.1.1. Formatting numeric fields
            2. 3.1.2. Alternating row formatting
            3. 3.1.3. Gridlines
            4. 3.1.4. Borders
        4. 4. Filtering and Sorting a Report
          1. 4.1. Filtering a Report
          2. 4.2. Sorting a Report
      8. 33. Creating Simple Forms
        1. 1. Form Basics
          1. 1.1. Creating a Simple Form
          2. 1.2. Using a Form
            1. 1.2.1. Finding and editing a record
            2. 1.2.2. Adding a record
            3. 1.2.3. Deleting a record
            4. 1.2.4. Printing records
        2. 2. Sorting and Filtering in a Form
          1. 2.1. Sorting a Form
          2. 2.2. Filtering a Form
          3. 2.3. Using the Filter by Form Feature
          4. 2.4. Saving Filters for the Future
        3. 3. The Form Wizard
      9. 34. Importing and Exporting Data
        1. 1. The Case for Importing and Exporting
          1. 1.1. Understanding Exports
          2. 1.2. Understanding Imports
        2. 2. Using the Clipboard
          1. 2.1. Copying a Table from Access to Somewhere Else
          2. 2.2. Copying Cells from Excel into Access
        3. 3. Import and Export Operations
          1. 3.1. Importable File Types
          2. 3.2. Importing Data
          3. 3.3. Importing from an Excel File
          4. 3.4. Importing from a Text File
          5. 3.5. Exportable File Types
          6. 3.6. Exporting Data
    8. V. Appendixes
      1. A. Customizing the Quick Access Toolbar
        1. 1. The Quick Access Toolbar
          1. 1.1. Adding buttons
          2. 1.2. Customizing Specific Files
      2. B. Getting Help
        1. 1. Using Office 2007's Built-in Help
          1. 1.1. Using Help Articles
          2. 1.2. Displaying Screen Tips
        2. 2. Using Microsoft's Office Web Site
          1. 2.1. Discussion Groups
          2. 2.2. Tutorials
          3. 2.3. Online Articles, FAQs, and More
          4. 2.4. Direct Person-to-Person Help
        3. 3. Third-Party Web Sites
          1. 3.1. Word Help Sites
          2. 3.2. Excel Help Sites
          3. 3.3. PowerPoint Help Sites
          4. 3.4. Access Help Sites
    9. Index
    10. About the Authors
    11. Colophon
    12. SPECIAL OFFER: Upgrade this ebook with O’Reilly