Skip to main content


Access 2007 For Dummies

Laurie A. Ulrich, Ken Cook, John Kaufeld

ISBN: 978-1-118-05088-0 February 2011 432 Pages


Reduce stress with timesaving database shortcuts

Explore database basics and build tables and reports that corral your data

Access has undergone an extreme makeover! Whether you've used one of the older versions or this is your first exposure to Access, here's where you'll find the essentials you need to make this database system work for you. Cruise around the new interface, team up Access with other Office applications, use wizards to automate your work, and much more.

Discover how to

  • Create a new Access database
  • Import and export data
  • Build forms for efficient data entry
  • Search tables for specific data
  • Construct custom reports
  • Customize your database navigation

Introduction 1

Part I: Basic Training 7

Chapter 1: Getting to Know Access 2007 9

Chapter 2: Finding Your Way Around Access 29

Chapter 3: Database Basics 51

Part II: Getting It All on the Table 69

Chapter 4: Keys, Relationships, and Indexes 71

Chapter 5: Remodeling Your Data 87

Chapter 6: What’s Happening Under the Table? 103

Part III: Data Mania and Management 127

Chapter 7: Creating Data Forms 129

Chapter 8: Importing and Exporting Data 143

Chapter 9: Automatically Editing Data 155

Chapter 10: Gather Locally, Share Globally 167

Part IV: Ask Your Data, and Ye Shall Receive Answers 181

Chapter 11: Fast Finding, Filtering, and Sorting Data 183

Chapter 12: I Was Just Asking . . . For Answers 199

Chapter 13: I’ll Take These AND Those OR Them 227

Chapter 14: Queries That Think Faster Than You 237

Chapter 15: Calculating with Your Data 251

Part V: Plain and Fancy Reporting 265

Chapter 16: Quick and Not-So-Dirty Automatic Reporting 267

Chapter 17: Dazzling Report Design 289

Chapter 18: Headers and Footers and Groups, Oh My! 315

Chapter 19: Magical Mass Mailings 335

Part VI: More Power to You 341

Chapter 20: Making It All Better with the Analyzer Tools 343

Chapter 21: Hello! Creating an Interface to Welcome Data Users 353

Part VII: The Part of Tens 365

Chapter 22: Ten Common Problems 367

Chapter 23: Ten Uncommon Tips 377

Appendix: Getting Help 383

Index 391

Download the sample database files from the book: