Access 2007 For Dummies

Reduce stress with timesaving database shortcuts Explore database basics and build tables and reports that corral your data Access has undergone an extreme makeover! Whether you've used one of the older versions or this is your first exposure to Access, here's where you'll find the essentials you need to make this database system work for you. Cruise around the new interface, team up Access with other Office applications, use wizards to automate your work, and much more. Discover how to Create a new Access database Import and export data Build forms for efficient data entry Search tables for specific data Construct custom reports Customize your database navigation

Reduce stress with timesaving database shortcutsExplore database basics and build tables and reports thatcorral your dataAccess has undergone an extreme makeover! Whether you've usedone of the older versions or this is your first exposure to Accesshere's where you'll find the essentials you need to make thisdatabase system work for you. Cruise around the new interface, teamup Access with other Office applications, use wizards to automateyour work, and much more.Discover how to* Create a new Access database* Import and export data* Build forms for efficient data entry* Search tables for specific data* Construct custom reports* Customize your database navigation

Introduction 1Part I: Basic Training 7Chapter 1: Getting to Know Access 2007 9Chapter 2: Finding Your Way Around Access 29Chapter 3: Database Basics 51Part II: Getting It All on the Table 69Chapter 4: Keys, Relationships, and Indexes 71Chapter 5: Remodeling Your Data 87Chapter 6: What's Happening Under the Table? 103Part III: Data Mania and Management 127Chapter 7: Creating Data Forms 129Chapter 8: Importing and Exporting Data 143Chapter 9: Automatically Editing Data 155Chapter 10: Gather Locally, Share Globally 167Part IV: Ask Your Data, and Ye Shall Receive Answers 181Chapter 11: Fast Finding, Filtering, and Sorting Data 183Chapter 12: I Was Just Asking . . . For Answers 199Chapter 13: I'll Take These AND Those OR Them 227Chapter 14: Queries That Think Faster Than You 237Chapter 15: Calculating with Your Data 251Part V: Plain and Fancy Reporting 265Chapter 16: Quick and Not-So-Dirty Automatic Reporting 267Chapter 17: Dazzling Report Design 289Chapter 18: Headers and Footers and Groups, Oh My! 315Chapter 19: Magical Mass Mailings 335Part VI: More Power to You 341Chapter 20: Making It All Better with the Analyzer Tools 343Chapter 21: Hello! Creating an Interface to Welcome Data Users 353Part VII: The Part of Tens 365Chapter 22: Ten Common Problems 367Chapter 23: Ten Uncommon Tips 377Appendix: Getting Help 383Index 391