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...
Search in google:
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 tagsUse 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.
Introduction1Pt. 1Which Came First, the Data or the Base?7Ch. 1The 37-Minute Overview9Ch. 2Finding Your Way Around like a Native23Ch. 3Calling the Online St. Bernard and Other Forms of Help35Pt. IITruly Tempting Tables41Ch. 4Designing and Building a Home for Your Data43Ch. 5Relationships, Keys, and Indexes (and Why You Really Do Care)67Ch. 6New Data, Old Data, and Data in Need of Repair77Ch. 7Making Your Table Think with Formats, Masks, and Validations87Ch. 8Making Your Datasheets Dance103Ch. 9Table Remodeling Tips for the Do-It-Yourselfer117Pt. IIIFinding the Ultimate Answer to Almost Everything127Ch. 10Quick Searches: Find, Filter, and Sort129Ch. 11Pose a Simple Query, Get 10,000 Answers143Ch. 12Searching a Slew of Tables157Ch. 13Lions AND Tigers OR Bears? Oh My!167Ch. 14Teaching Queries to Think and Count175Ch. 15Calculating Your Way to Fame and Fortune187Ch. 16Automated Editing for Big Changes199Pt. IVTurning Your Table into a Book209Ch. 17AutoReport: Like the Model-T, It's Clunky but It Runs211Ch. 18Wizardly Help with Labels, Charts, and Multilevel Reports223Ch. 19It's Amazing What a Little Formatting Can Do239Ch. 20Headers and Footers for Groups, Pages, and Even (Egad) Entire Reports257Pt. VWizards, Forms, and Other Mystical Stuff273Ch. 21Spinning Your Data onto the Web275Ch. 22Making Forms that Look Cool and Work Great285Ch. 23If Love Is Universal, Why Can't I Export to It?299Ch. 24The Analyzer: Your Data's Dr. Freud, Dr. Watson, and Dr. Jekyll307Ch. 25Talking to Your Computer315Pt. VIThe Part of Tens325Ch. 26Ten Timesaving Keyboard Shortcuts327Ch. 27Ten Common Crises and How to Survive Them331Ch. 28Ten Tips from Databases Nerds337Index343
