Access 2002 for Dummies

( 1 )

Overview

The truth is, the database is the computer world's best-kept secret that everyone really knows about. Everyone knows about them because everyone uses them – from the little database you use to keep track of addresses and phone numbers on your computer to huge databases that banks use to house the financial information of millions of people. However, nobody talks about databases because they're so darned complicated to set up and use; quite frankly, nobody but the geeks...

See more details below
Other sellers (Paperback)
  • All (39) from $1.99   
  • New (3) from $12.91   
  • Used (36) from $1.99   
Sending request ...

Overview

The truth is, the database is the computer world's best-kept secret that everyone really knows about. Everyone knows about them because everyone uses them – from the little database you use to keep track of addresses and phone numbers on your computer to huge databases that banks use to house the financial information of millions of people. However, nobody talks about databases because they're so darned complicated to set up and use; quite frankly, nobody but the geeks who design and build them really know how they work!

How does this apply to you? Well, being a normal human being (translation: not a computer geek), you probably have work to do. In fact, you may have lots of work piled up precariously around your office. Someone, possibly your boss (or, if you work at home, your Significant Other), suggested that a database may help you get more organized, eliminate the piles, and generally make the safety inspector happy. Good advice, except for the fact that you, like most other people, don't know thing-one about setting up a database. And you have this program called Access 2002 on your computer that's supposed to do all that for you.

But how do you get started with Access 2002 and have it set up the kind of database you need? Well, you've come to the right place.

Written in plain, understandable English (try to find that in your typical software manual), Access 2002 For Dummies shows you how to make sense of that whole complicated database thing without boring you silly or turning you into a world-class computer geek. Here are just a few of the topics you'll find covered in Access 2002 For Dummies:

  • Touring the basic functions of Access 2002
  • Designing and building a database – without tearing out what's left of your hair
  • Building data relationships, keys, and indexes
  • Making your data presentable
  • Searching: Find, filter, and sort
  • Posing queries and creating calculations
  • Running reports and creating charts
  • Feeding your data to a Web site
  • Top Ten lists on timesaving techniques, surviving database crises, and tips from those computer geeks to make your database life easier

So no matter what you want to use your database for – whether it's to store inventory information, to feed information dynamically to a Web site, or simply to track your business contacts (so you can get rid of that drawer full of business cards) – you can find all the information you need in Access 2002 For Dummies.

Read More Show Less

Product Details

  • ISBN-13: 9780764508189
  • Publisher: Wiley
  • Publication date: 6/1/2001
  • Series: For Dummies Series
  • Edition number: 1
  • Pages: 384
  • Product dimensions: 7.40 (w) x 9.26 (h) x 0.90 (d)

Meet the Author

John Kaufeld got hooked on computers a long time ago. Somewhere along the way, he discovered that he really enjoyed helping people resolve computer problems (a trait that his Computer Science pals generally considered a character flaw, but that everyone else seemed to appreciate). John finally achieved his B.S. degree in Management Information Systems from Ball State University, and he became the first PC Support Technician for what was then Westinghouse outside Cincinnati, Ohio.
Since that time, he's logged nearly a decade of experience working with normal people who, for one reason or another, were stuck with a friendly" personal computer that turned on them. He's also trained more than 1,000 people in many different PC and Macintosh applications. The vast majority of them not only survived the experience, but thrived on it. Today, John is president of Access Systems, a computer consulting firm. He still does trouble-shooting, conducts technical and interpersonal skills seminars for up-and-coming computer gurus, and writes in his free moments.
John's other IDG titles include FoxPro 2.6 For Windows For Dummies, Paradox 5 For Windows For Dummies, Games Online For Dummies, and the best-selling America Online For Dummies, 5th Edition. John lives with his wife, two children, and a tolerable American Eskimo dog in Indianapolis, Indiana.

Read More Show Less

Table of Contents

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.

Read More Show Less

Customer Reviews

Average Rating 5
( 1 )
Rating Distribution

5 Star

(1)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 Customer Reviews
  • Anonymous

    Posted October 5, 2001

    Superb - Get It!

    This book is a rework of a disappointing Access 2000 for Dummies -- all the good stuff has been enhanced and all the weak stuff fixed. The book provides a solid introduction to database concepts in general, Access 2002 in particular and some bonus materials on the Office XP stuff. Quibble: the pivot table stuff is a little weak.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)