Access 2003 For Dummies

Access 2003 For Dummies

by John Kaufeld


$21.79 $21.99 Save 1% Current price is $21.79, Original price is $21.99. You Save 1%.
View All Available Formats & Editions
Use Standard Shipping. For guaranteed delivery by December 24, use Express or Expedited Shipping.

Product Details

ISBN-13: 9780764538810
Publisher: Wiley
Publication date: 09/29/2003
Series: For Dummies Series
Pages: 384
Product dimensions: 7.40(w) x 9.25(h) x 0.80(d)

About the Author

John Kaufeld has written all previous editions of Access For Dummies as well as several other books. John also operates, an online shipping assistant.

Read an Excerpt

Click to read or download

Table of Contents

Introduction 1

Part I: Which Came First, the Data or the Base? 7

Chapter 1: The 37-Minute Overview 9

Chapter 2: Finding Your Way Around like a Native 23

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

Part II: Truly Tempting Tables 41

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

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

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

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

Chapter 8: Making Your Datasheets Dance 103

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

Part III: Finding the Ultimate Answer to Almost Everything 127

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

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

Chapter 12: Searching a Slew of Tables 157

Chapter 13: Lions AND Tigers OR Bears? Oh My! 167

Chapter 14: Teaching Queries to Think and Count 175

Chapter 15: Calculating Your Way to Fame and Fortune 187

Chapter 16: Automated Editing for Big Changes 199

Part IV: Turning Your Table into a Book 209

Chapter 17: AutoReport: Like the Model-T, It’s Clunky but It Runs 211

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

Chapter 19: It’s Amazing What a Little Formatting Can Do 239

Chapter 20: Headers and Footers for Groups, Pages, and Even (Egad) Entire Reports 257

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

Chapter 21: Spinning Your Data onto the Web 275

Chapter 22: Making Forms that Look Cool and Work Great 285

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

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

Chapter 25: Talking to Your Computer 315

Part VI: The Part of Tens 325

Chapter 26: Ten Timesaving Keyboard Shortcuts 327

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

Chapter 28: Ten Tips from Database Nerds 337

Index 343

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews