Create queries that make forms and reports useful
Develop forms to access the data you need and make reports that make sense!
If you thought you had to use a spreadsheet program to produce reports and forms, guess what! Access can turn out great-looking forms and reports that actually show what's going on with your data -- if you know how to ask it nicely. This hands-on guide helps you do just that, and it works with all versions of Access.
Discover how to
* Ask Access the right questions
* Work with sets of data
* Create simple forms with a wizard
* Use queries to create new tables
* Troubleshoot queries
* Add visual features to reports
Table of Contents:
Introduction 1
Part I: Accessing Both Ends: Getting Data In and Info Out 7
Chapter 1: Getting to Know Forms and Reports 9
Chapter 2: Getting Started with Queries 25
Chapter 3: Creating Simple Forms 45
Chapter 4: Building Basic Reports 67
Part II: Creating Effective Queries 93
Chapter 5: Creating Multi-Table Queries 95
Chapter 6: Modifying Data with Queries 113
Chapter 7: Expanding Queries with SQL 133
Chapter 8: Dealing with Quarrelsome Queries 151
Part III: Building Really Useful Forms 169
Chapter 9: Building Better Forms by Using Controls 171
Chapter 10: Using Multiple Tables in Forms 191
Chapter 11: Fixing Form Faults 205
Part IV: Designing Great Reports 219
Chapter 12: Adding Fancy Touches to Reports 221
Chapter 13: Creating Reports that Summarize Data 241
Chapter 14: When Reports Go Wrong 257
Part V: Way Cool Advanced Queries, Forms, and Reports 267
Chapter 15: Tricks for Finding Data with Queries 269
Chapter 16: Tricks for Updating with Queries 283
Chapter 17: Killer Ways to Improve Forms 295
Chapter 18: Expert Methods for Sharing Reports 315
Chapter 19: Making Reports Look Better 331
Chapter 20: Adding Efficiency with Great Tools 345
Part VI: The Part of Tens 363
Chapter 21: Ten Great Access Sites Online 365
Chapter 22: Ten Things to Know About Queries (That Also Help You with Forms and Reports) 371
Index 375
