Access 2007 For Dummies

  • 5h 25m
  • John Kaufeld, Ken Cook, Laurie Ulrich Fuller
  • John Wiley & Sons (US)
  • 2007

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

About the Authors

Laurie Ulrich Fuller has been writing about and teaching people to use Microsoft Office since the 1980’s. Her teaching career goes back to the time before Microsoft Windows. Since those early days of Office and Windows, Laurie has personally trained more than 10,000 people to make better, more creative use of their computers, has written and co-written more than 25 nationally-published books on computers and software — including several titles on Microsoft Office. In the last few years, she’s also created two video training courses — one on Word 2003, and the other on the entire Office 2003 suite. She runs her own company, Limehat & Company, offering training, educational materials, and web development services.

Ken Cook has built and managed a successful computer consulting business since 1990 serving clients in New Jersey, New York, Pennsylvania, and California. He began as a trainer - training numerous users (too many to count!) on a variety of software packages — specializing in Microsoft Office. Currently, he “dabbles in training” but his main focus is creating expert Microsoft Office solutions and Microsoft Access database solutions for Fortune 500 and small business clients.

In this Book

  • Getting to Know Access 2007
  • Finding Your Way Around Access
  • Database Basics
  • Keys, Relationships, and Indexes
  • Remodeling Your Data
  • What’s Happening Under the Table?
  • Creating Data Forms
  • Importing and Exporting Data
  • Automatically Editing Data
  • Gather Locally, Share Globally
  • Fast Finding, Filtering, and Sorting Data
  • I Was Just Asking … For Answers
  • I’ll Take These AND Those OR Them
  • Queries That Think Faster Than You
  • Calculating with Your Data
  • Quick and Not-So-Dirty Automatic Reporting
  • Dazzling Report Design
  • Headers and Footers and Groups, Oh My!
  • Magical Mass Mailings
  • Making It All Better with the Analyzer Tools
  • Hello! Creating an Interface to Welcome Data Users
  • Ten Common Problems
  • Ten Uncommon Tips
SHOW MORE
FREE ACCESS