Access For Dummies (eBook)

Laurie Ann Ulrich is a professional author and trainer on all things technology. Along with recent editions of Access For Dummies, she's also written books on Excel, Photoshop, and Dreamweaver. Ken Cook is a professional database developer and author who has written on Access and Excel.

Introduction 1

Part 1: Basic Training 5

Chapter 1: Access Basic Training 7

Chapter 2: Navigating the Access Workspace 25

Chapter 3: Database Basics 43

Part 2: Getting It All on the Table 63

Chapter 4: Sounds Like a Plan 65

Chapter 5: Table Tune-Ups 77

Chapter 6: Remodeling Your Data 95

Chapter 7: Types, Masks, and Triggers 111

Part 3: Data Management Mania 135

Chapter 8: A Form for All Reasons 137

Chapter 9: Importing and Exporting Data 157

Chapter 10: Automatically Editing Data 171

Chapter 11: Access and the Web 183

Part 4: The Power of Questions 197

Chapter 12: Finding, Filtering, and Sorting Your Data -- Fast 199

Chapter 13: I Was Just Asking for Answers 215

Chapter 14: I Want These AND Those OR Them 241

Chapter 15: Number Crunching with the Total Row. 249

Chapter 16: Express Yourself with Formulas 263

Chapter 17: Take Charge with Action Queries 277

Part 5: Simple and Snazzy Reporting. 289

Chapter 18: Fast and Furious Automatic Reporting 291

Chapter 19: Professionally Designed Reports Made Easy 313

Chapter 20: Groups and Page Breaks, Headers and Footers 341

Chapter 21: Mailings to the Masses 363

Part 6: The Part of Tens 371

Chapter 22: Ten Common Problems 373

Chapter 23: Ten Uncommon Tips 385

Appendix A: Getting Help 393

Index 395