1. Chapter 1 The Fundamentals

   1. Introduction to Databases

   2. What's New in Access 2003

   3. Starting Access and Opening a Database

   4. Understanding the Access Program Screen

   5. Using Menus

   6. Using Toolbars

   7. Filling Out Dialog Boxes

   8. Keystroke and Right Mouse Button Shortcuts

   9. Opening and Modifying Database Objects

   10. Working with Multiple Windows

   11. Tour of a Table

   12. Adding, Editing, and Deleting Records

   13. Tour of a Form

   14. Tour of a Query

   15. Tour of a Report

   16. Previewing and Printing a Database Object

   17. Selecting Data

   18. Cutting, Copying, and Pasting Data

   19. Using Undo

   20. Checking Your Spelling

   21. Getting Help

   22. Changing the Office Assistant and Using the Quick Reference Help Button

   23. Using the Zoom Box

   24. Closing a Database and Exiting Access

   25. Chapter One Review

2. Chapter 2 Creating and Working with a Database

   1. Planning a Database

   2. Creating a Database Using the Database Wizard

   3. Creating a Blank Database

   4. Creating a Table Using the Table Wizard

   5. Modifying a Table and Understanding Data Types

   6. Creating a New Table from Scratch

   7. Creating a Query in Design View

   8. Modifying a Query

   9. Sorting a Query Using Multiple Fields

   10. Developing AND and OR Operators

   11. Creating a Form with the Form Wizard

   12. Creating a Report with the Report Wizard

   13. Creating Mailing Labels with the Label Wizard

   14. Database Object Management

   15. File Management

   16. Compacting and Repairing a Database

   17. Converting an Access Database

   18. Chapter Two Review

3. Chapter 3 Finding, Filtering, and Formatting Data

   1. Finding and Replacing Information

   2. Sorting Records

   3. Filtering by Selection

   4. Filtering by Form

   5. Creating an Advanced Filter

   6. Adjusting Row Height and Column Width

   7. Rearranging Columns

   8. Changing Gridline and Cell Effects

   9. Freezing a Field

   10. Hiding a Column

   11. Changing the Datasheet Font

   12. Chapter Three Review

4. Chapter 4 Working with Tables and Fields

   1. Understanding Field Properties

   2. Indexing a Field

   3. Adding a Primary Key to a Table

   4. Inserting, Deleting, and Reordering Fields

   5. Changing a Field's Data Type

   6. Using Field Descriptions

   7. Adding a Caption

   8. Changing the Field Size

   9. Formatting Number, Currency, and Date/Time Fields

   10. Formatting Number, Currency, and Date/Time Fields by Hand

   11. Formatting Text Fields

   12. Setting a Default Value

   13. Requiring Data Entry

   14. Validating Data

   15. Creating an Input Mask

   16. Creating a Lookup Field

   17. Creating a Value List

   18. Modifying a Lookup List

   19. Chapter Four Review

5. Chapter 5 Creating Relational Databases

   1. Understanding Table Relationships

   2. Creating Relationships Between Tables

   3. Enforcing Referential Integrity

   4. Testing Referential Integrity & Printing and Deleting Table Relationships

   5. Understanding Relationship Types

   6. Chapter Five Review

6. Chapter 6 Working with Queries

   1. A Quick Review

   2. Understanding the Different Types of Queries

   3. Creating a Multiple-Table Query

   4. Creating a Calculated Field

   5. Working with Expressions and the Expression Builder

   6. Using an IIf Function

   7. Summarizing Groups of Records

   8. Display Top or Bottom Values

   9. Parameter Queries

   10. Finding Duplicate Records

   11. Finding Unmatched Records

   12. Crosstab Queries

   13. Delete Queries

   14. Append Queries

   15. Make-Table Queries

   16. Update Queries

   17. Chapter Six Review

7. Chapter 7 Working with Forms

   1. Creating a Form with AutoForm

   2. Modifying a Form

   3. Adding and Deleting Fields

   4. Moving and Sizing Controls

   5. Changing the Tab Order

   6. Working with Control Properties

   7. Control Property Reference

   8. Working with Form Properties

   9. Form and Report Property Reference

   10. Working with Multiple Controls

   11. Adding, Cutting, Copying, and Pasting Controls

   12. Changing a Control's Data Source

   13. Creating a Calculated Control

   14. Changing a Control's Default Value

   15. Using the Control Wizard

   16. Creating a Subform

   17. Modifying and Working with Subforms

   18. Chapter Seven Review

8. Chapter 8 Working with Reports

   1. Creating a Report with AutoReport

   2. Modifying a Report

   3. Adding and Deleting Fields

   4. Moving and Sizing Controls

   5. Adjusting Page Margins and Orientation

   6. Adding Page Numbers and Dates

   7. Understanding Report Sections

   8. Grouping and Sorting Records

   9. Creating Calculated Controls

   10. Working with Section Properties

   11. Creating Charts with the Chart Wizard

   12. Chapter Eight Review

9. Chapter 9 Formatting Forms and Reports

   1. Formatting Fonts with the Formatting Toolbar

   2. Changing Text Alignment

   3. Using AutoFormat

   4. Changing Colors

   5. Applying Special Effects

   6. Using the Format Painter

   7. Adding Pictures and Lines

   8. Aligning Controls with One Another

   9. Changing a Control's Formatting Properties

   10. Chapter Nine Review

10. Chapter 10 Working with Macros

    1. Creating and Running a Macro

    2. Editing a Macro

    3. Working with Macro Groups

    4. Assigning a Macro to an Event

    5. Creating Conditional Expressions

    6. Assigning a Macro to a Keystroke Combination

    7. Macro Action Reference

    8. Chapter Ten Review

11. Chapter 11 Advanced Topics

    1. Importing Information

    2. Exporting Information

    3. Importing Objects from Another Access Database

    4. Linking Information from an External Source

    5. Analyzing Records with Microsoft Excel

    6. Exporting Records to Microsoft Word

    7. Mail Merging Records to Microsoft Word

    8. Using Hyperlink Fields

    9. Using OLE Object Fields

    10. Displaying Database Object Dependencies

    11. Chapter Eleven Review

1. Colophon

Our look is the result of reader comments, our own experimentation, and feedback from distribution channels. Distinctive covers complement our distinctive approach to technical topics, breathing personality and life into potentially dry subjects. Philip Dangler was the production editor and proofreader for Access 2003 Personal Trainer. Mary Brady, Marlowe Shaeffer, and Emily Quill provided quality control. Julie Hawks wrote the index.

The cover image of the comic book hero is an original illustration by Lou Brooks. The art of illustrator Lou Brooks has appeared on the covers of Time and Newsweek eight times, and his logo design for the game Monopoly is used throughout the world to this day. His work has also appeared in just about every major publication, and it has been animated for MTV, Nickelodeon, and HBO.

Emma Colby designed and produced the cover of this book with Adobe InDesign CS and Photoshop CS. The typefaces used on the cover are Base Twelve, designed by Zuzana Licko and issued by Emigre, Inc., and JY Comic Pro, issued by AGFA Monotype.

Melanie Wang designed the interior layout. Emma Colby designed the CD label. This book was converted by Andrew Savikas and Joe Wizda to FrameMaker 5.5.6 with a format conversion tool created by Erik Ray, Jason McIntosh, Neil Walls, and Mike Sierra that uses Perl and XML technologies. The typefaces are Minion, designed by Robert Slimbach and issued by Adobe Systems; Base Twelve and Base Nine; JY Comic Pro; and TheSansMono Condensed, designed by Luc(as) de Groot and issued by LucasFonts.

The technical illustrations that appear in the book were produced by Robert Romano, Jessamyn Read, and Lesley Borash, using Macromedia FreeHand MX andAdobe Photoshop CS.