Dummies.com
  • Print
  • Share
Access 2002 For Dummies (0764508180) cover image

Access 2002 For Dummies

ISBN: 978-0-7645-0818-9
Paperback
384 pages
June 2001
US $21.99 Add to Cart

This price is valid for United States. Change location to view local pricing and availability.

Introduction.

You Don't Need to Be a Nerd to Use This Book.

Sneaking a Peek at What's to Come.

Part I: Which Came First: The Data or the Base?

Part II: Truly Tempting Tables.

Part III: Finding the Ultimate Answer to Everything (Well, Not Everything).

Part IV: Turning Your Table into a Book.

Part V: Wizards, Forms, and Other Mystical Stuff.

Part VI: The Part of Tens.

What the Funny Text Means.

Finding Points of Interest.

Setting Sail on the Voyage.

Part I: Which Came First: The Data or the Base?

Chapter 1: The 37-Minute Overview.

In the Beginning, There Was Access 2002 (But It Wasn't Running).

Chapter 2: Finding Your Way around like a Native.

Making Sense of the Sights.

Chapter 3: Calling the Online Saint Bernard and Other Forms of Help.

Pressing F1 for Assistance.

Part II: Truly Tempting Tables.

Chapter 4: Designing and Building a Home for Your Data.

Database Terms to Know and Tolerate.

Chapter 5: Relationships, Keys, and Indexes (And Why You Really Do Care).

The Joy (And Necessity) of a Primary Key.

Chapter 6: New Data, Old Data, and Data in Need of Repair.

Dragging Your Table into the Digital Workshop.

Chapter 7: Making Your Table Think with Formats, Masks, and Validations.

Finding the Place to Make a Change.

Chapter 8: Making Your Datasheets Dance.

Wandering Here, There, and Everywhere.

Chapter 9: Table Remodeling Tips for the Do-It-Yourselfer.

This Chapter Can Be Hazardous to Your Table's Design.

Part III: Finding the Ultimate Answer to Everything (Well, Not Everything).

Chapter 10: Quick Searches: Find, Filter, and Sort.

Finding Stuff in Your Tables.

Chapter 11: Pose a Simple Query, Get 10,000 Answers.

Database Interrogation for Fun and Profit.

Chapter 12: Searching a Slew of Tables.

Some General Thoughts about Multiple-Table Queries.

Chapter 13: The Ands and Ors of Dr. Boole.

Comparing AND to OR.

Chapter 14: Teaching Queries to Think and Count.

Totaling Everything in Sight.

Chapter 15: Calculating Your Way to Fame and Fortune.

A Simple Calculation.

Chapter 16: Automated Editing for Big Changes.

First, This Word from Our Paranoid Sponsor.

Part IV: Turning Your Table into a Book.

Chapter 17: AutoReport: Like the Model-T, It's Clunky but It Runs.

AutoReport Basics for High-Speed Information.

Chapter 18: Wizardly Help with Labels, Charts, and Multilevel Reports.

Creating Labels.

Chapter 19: It's Amazing What a Little Formatting Can Do.

Taking Your Report to the Design View Tune-Up Shop.

Chapter 20: Headers and Footers for Groups, Pages, and Even (Egad) Whole Reports.

Everything in Its Place.

Part V: Wizards, Forms, and Other Mystical Stuff

Chapter 21: Spinning Your Data into (And onto) the Web.

Access 2002 and the Internet: A Match Made in Redmond.

Chapter 22: Making Forms That Look Cool and Work Great.

Tax Forms and Data Forms Are Very Different Animals.

Chapter 23: If Love Is Universal, Why Can't I Export to It?

Importing Only the Best Information for Your Databases.

Chapter 24: The Analyzer: Your Data's Dr. Freud, Dr. Watson, and Dr. Jekyll.

It Slices, It Dices, It Builds Relational Databases!

Chapter 25: Talking To Your Computer.

What Is Speech Recognition (And What Can I Do with It)?

Part VI: The Part of Tens.

Chapter 26: Ten Timesaving Keyboard Shortcuts.

Chapter 27: Ten Common Crises and How to Survive Them.

Index.
  • Print
  • Share