• Print
  • Share
Access 2003 For Dummies (1118053257) cover image

Access 2003 For Dummies

ISBN: 978-1-118-05325-6
384 pages
February 2011
How to read this e-book on:
Adobe e-books are read using Adobe Digital Editions. Install Adobe Digital Editions on your PC in order to read or transfer your e-book.

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

  • Print
  • Share