Includes index.

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

This title helps you reduce stress with timesaving database shortcuts, and 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; and customize your database navigation.This title helps you reduce stress with timesaving database shortcuts, and 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; and customize your database navigation.