Description
Book SynopsisA friendly, step-by-step guide to the Microsoft Office databaseapplication Access may be the least understood and most challengingapplication in the Microsoft Office suite. This guide is designedto help anyone who lacks experience in creating and managing adatabase learn to use Access 2010 quickly and easily.
Table of ContentsIntroduction 1
Part I: Basic Training 9
Chapter 1: Getting to Know Access 2010 11
Chapter 2: Finding Your Way Around Access 37
Chapter 3: Database Basics 59
Part II: Getting It All on the Table 79
Chapter 4: Keys, Relationships, and Indexes 81
Chapter 5: Remodeling Your Data 99
Chapter 6: What’s Happening Under the Table? 115
Part III: Data Mania and Management 139
Chapter 7: Creating Data Forms 141
Chapter 8: Importing and Exporting Data 155
Chapter 9: Editing Data Automatically 169
Chapter 10: Gather Locally, Share Globally 181
Part IV: Ask Your Data, and Ye Shall Receive Answers 201
Chapter 11: Fast Finding, Filtering, and Sorting Data 203
Chapter 12: I Was Just Asking . . . for Answers 219
Chapter 13: I’ll Take These AND Those OR Them 245
Chapter 14: Queries That Think Faster Than You 255
Chapter 15: Calculating with Your Data 267
Chapter 16: Flying into Action Queries 283
Part V: Plain and Fancy Reporting 295
Chapter 17: Quick and Not-So-Dirty Automatic Reporting 297
Chapter 18: Dazzling Report Design 319
Chapter 19: Headers and Footers and Groups, Oh My! 345
Chapter 20: Magical Mass Mailings 367
Part VI: More Power to You 375
Chapter 21: Making It All Better with the Analyzer Tools 377
Chapter 22: Hello! Creating an Interface to Welcome Database Users 389
Part VII: The Part of Tens 399
Chapter 23: Ten Common Problems 401
Chapter 24: Ten Uncommon Tips 413
Index 421
