Access 2003 For Dummies

When you hear the word database, do your eyes glaze over? Does the mention of fields and tables make your blood pressure skyrocket? Does the idea of entering and using hyperlinks make you hyperventilate? Whether you re running a business or a household . . . whether you need to be able to quickly access customer information, your recipe for chicken cacciatore, or the Little League team s records, Access 2003 holds the key. This friendly guide unlocks the secrets of using Access 2003 to store, manage, organize, reorganize, and use data! It gives you: The basics of the whole database concept Suggestions for solving problems with Access What you need to know to design, build, use, and change Access tables Info on the ten most common types of fields The scoop on using queries to unearth the answers hiding somewhere in your data Guidelines for using the Access report system to make short work of long, previously time-consuming, reports In the relaxed, comfortable For Dummies style, this book has easy-to-follow, step-by-step instructions and lots of screen shots. If you want to create and manage a database for a huge auction house, this guide will get you going . . . going . . . gone. If you want to create a database for your music collection, it gives you the score then shows you how to use formatting and add graphics to jazz it up. You ll get the low-down on extracting all kinds of information from databases and putting that information to practical use. You ll discover how to: Use Label Wizard to create mailing labels, file labels, shipping labels, or name tags Use Chart Wizard to create line charts, bar, cone, and column charts, pie and donut charts, area charts, and XY and bubble charts Use Auto Reports to create columnar or tabular reports and then fine-tune them Export reports to Microsoft Word and Excel Get your data Web-ready and put it on the Internet in either static or dynamic form Build forms with Form Wizard And speaking of high-tech fun, Access 2003 For Dummies even tells you how to install and use speech recognition software with Access 2003. So if the idea of working with databases has you talking to yourself, this is just the book you need.

When you hear the word "database," do your eyes glazeover? Does the mention of fields and tables make your bloodpressure skyrocket? Does the idea of entering and using hyperlinksmake you hyperventilate?Whether you're running a business or a household . . .whether you need to be able to quickly access customer informationyour recipe for chicken cacciatore, or the Little Leagueteam's records, Access 2003 holds the key. This friendlyguide unlocks the secrets of using Access 2003 to store, manageorganize, reorganize, and use data! It gives you:* The basics of the whole database concept* Suggestions for solving problems with Access* What you need to know to design, build, use, and change Accesstables* Info on the ten most common types of fields* The scoop on using queries to unearth the answers hidingsomewhere in your data* Guidelines for using the Access report system to make shortwork of long, previously time-consuming, reportsIn the relaxed, comfortable For Dummies style, this bookhas easy-to-follow, step-by-step instructions and lots of screenshots. If you want to create and manage a database for a hugeauction house, this guide will get you going . . . going . .. gone. If you want to create a database for your musiccollection, it gives you the score then shows you how to useformatting and add graphics to jazz it up. You'll get thelow-down on extracting all kinds of information from databases andputting that information to practical use. You'll discoverhow to:* Use Label Wizard to create mailing labels, file labelsshipping labels, or name tags* Use Chart Wizard to create line charts, bar, cone, and columncharts, pie and donut charts, area charts, and XY and bubblecharts* Use Auto Reports to create columnar or tabular reports and thenfine-tune them* Export reports to Microsoft Word and Excel* Get your data Web-ready and put it on the Internet in eitherstatic or dynamic form* Build forms with Form WizardAnd speaking of high-tech fun, Access 2003 For Dummieseven tells you how to install and use speech recognition softwarewith Access 2003. So if the idea of working with databases has youtalking to yourself, this is just the book you need.

Introduction 1Part I: Which Came First, the Data or the Base? 7Chapter 1: The 37-Minute Overview 9Chapter 2: Finding Your Way Around like a Native 23Chapter 3: Calling the Online St. Bernard and Other Forms of Help 35Part II: Truly Tempting Tables 41Chapter 4: Designing and Building a Home for Your Data 43Chapter 5: Relationships, Keys, and Indexes (and Why You Really Do Care) 67Chapter 6: New Data, Old Data, and Data in Need of Repair 77Chapter 7: Making Your Table Think with Formats, Masks, and Validations 87Chapter 8: Making Your Datasheets Dance 103Chapter 9: Table Remodeling Tips for the Do-It-Yourselfer 117Part III: Finding the Ultimate Answer to Almost Everything 127Chapter 10: Quick Searches: Find, Filter, and Sort 129Chapter 11: Pose a Simple Query, Get 10,000 Answers 143Chapter 12: Searching a Slew of Tables 157Chapter 13: Lions AND Tigers OR Bears? Oh My! 167Chapter 14: Teaching Queries to Think and Count 175Chapter 15: Calculating Your Way to Fame and Fortune 187Chapter 16: Automated Editing for Big Changes 199Part IV: Turning Your Table into a Book 209Chapter 17: AutoReport: Like the Model-T, It's Clunky but It Runs 211Chapter 18: Wizardly Help with Labels, Charts, and Multilevel Reports 223Chapter 19: It's Amazing What a Little Formatting Can Do 239Chapter 20: Headers and Footers for Groups, Pages, and Even (Egad) Entire Reports 257Part V: Wizards, Forms, and Other Mystical Stuff 273Chapter 21: Spinning Your Data onto the Web 275Chapter 22: Making Forms that Look Cool and Work Great 285Chapter 23: If Love Is Universal, Why Can't I Export to It? 299Chapter 24: The Analyzer: Your Data's Dr. Freud, Dr. Watson, and Dr. Jekyll 307Chapter 25: Talking to Your Computer 315Part VI: The Part of Tens 325Chapter 26: Ten Timesaving Keyboard Shortcuts 327Chapter 27: Ten Common Crises and How to Survive Them 331Chapter 28: Ten Tips from Database Nerds 337Index 343