Underdahl Brian. Access Forms & Reports For Dummies

Wiley Publishing, 2006. — 409 p. — ISBN13: 978-0-7645-9965-1; ISBN10: 0-7645-9965-8.Microsoft Access can be an incredibly useful application, but it can also be very frustrating if you don’t know how to make it do what you want it to do. In a perfect world, you’d have a guru around, 24/7 — someone who knows Access inside and out and is willing to guide you along the way, showing you handy little tricks and useful techniques that help you to get the results you need.
Well, I may not be there with you, but this book is the next best thing. I’ve gathered the really useful pieces of information that you need to create powerful queries, very easy-to-use forms, and reports that actually tell the story of what is going on inside your data. Along the way, I make sure to show you the special tricks and techniques that I use.Accessing Both Ends: Getting Data In and Info Out
Getting to Know Forms and Reports
Getting Started with Queries
Creating Simple Forms
Building Basic Reports
Creating Effective Queries
Creating Multi-Table Queries
Modifying Data with Queries
Expanding Queries with SQL
Dealing with Quarrelsome Queries
Building Really Useful Forms
Building Better Forms by Using Controls
Using Multiple Tables in Forms
Fixing Form Faults
Designing Great Reports
Adding Fancy Touches to Reports
Creating Reports that Summarize Data
When Reports Go Wrong
Way Cool Advanced Queries, Forms, and Reports
Tricks for Finding Data with Queries
Tricks for Updating with Queries
Killer Ways to Improve Forms
Expert Methods for Sharing Reports
Making Reports Look Better
Adding Efficiency with Great Tools
The Part of Tens
Ten Great Access Sites Online
Ten Things to Know About Queries (That Also Help You with Forms and Reports)