1. STORING INFORMATION IN TABLES

   1. Chapter 1 Creating your First Database

      1. Understanding Access Databases
      2. Getting Started
      3. Saving and Opening Access Databases
      4. The Navigation Pane

   2. Chapter 2 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 3 Mastering the Datasheet: Sorting, Searching, Filtering, and More

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

   4. Chapter 4 Blocking Bad Data

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

   5. Chapter 5 Linking Tables with Relationships

      1. Relationship Basics
      2. Using a Relationship
      3. More Exotic Relationships
      4. Relationship Practice

2. MANIPULATING DATA WITH QUERIES

   1. Chapter 6 Queries that Select Records

      1. Query Basics
      2. Creating Queries
      3. Queries and Related Tables
      4. Query Power: Calculated Fields and Text Expressions
      5. Calculated Fields

   2. Chapter 7 Queries that Update Records

      1. Understanding Action Queries
      2. Update Queries
      3. Append Queries
      4. Delete Queries

3. PRINTING REPORTS AND USING FORMS

   1. Chapter 8 Creating Reports

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

   2. Chapter 9 Creating Simple Forms

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

4. SHARING ACCESS WITH THE REST OF THE WORLD

   1. Chapter 10 Importing and Exporting Data

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

1. Colophon

Sanders Kleinfeld was the production editor for Access 2007 for Starters: The Missing Manual. Philip Dangler and Colleen Gorman provided quality control. Lucie Haskins wrote the index.

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.

Tom Ingalls designed the interior layout, which was modified by Ron Bilodeau. Abby Fox converted the text and prepared it for layout. Robert Romano and Jessamyn Read produced the illustrations.