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