Thank you for visiting us. We are currently updating our shopping cart and regret to advise that it will be unavailable until September 1, 2014. We apologise for any inconvenience and look forward to serving you again.

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