Access Forms & Reports For Dummies

✍ Scribed by Brian Underdahl

• Publisher: For Dummies
• Year: 2005
• Tongue: English
• Leaves: 409
• Edition: 1
• Category: Library

✦ Synopsis

Create queries that make forms and reports usefulDevelop 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

Contents at a Glance......Page 6
Table of Contents......Page 8
Introduction......Page 18
Part I: Accessing Both Ends: Getting Data In
and Info Out......Page 24
Getting to Know Forms and Reports......Page 26
Getting Started with Queries......Page 42
Creating Simple Forms......Page 62
Building Basic Reports......Page 84
Part II: Creating Effective Queries......Page 110
Creating Multi-Table Queries......Page 112
Modifying Data with Queries......Page 130
Expanding Queries with SQL......Page 150
Dealing with Quarrelsome Queries......Page 168
Part III: Building Really Useful Forms......Page 186
Building Better Forms by Using Controls......Page 188
Using Multiple Tables in Forms......Page 208
Fixing Form Faults......Page 222
Part IV: Designing Great Reports......Page 236
Adding Fancy Touches to Reports......Page 238
Creating Reports that Summarize Data......Page 258
When Reports Go Wrong . . .......Page 274
Part V: Way Cool Advanced Queries,
Forms, and Reports......Page 284
Tricks for Finding Data with Queries......Page 286
Tricks for Updating with Queries......Page 300
Killer Ways to Improve Forms......Page 312
Expert Methods for Sharing Reports......Page 332
Making Reports Look Better......Page 348
Adding Efficiency with Great Tools......Page 362
Part VI......Page 380
Ten Great Access Sites Online......Page 382
Ten Things to Know About Queries (That Also Help You with Forms and Reports)......Page 388
Index......Page 392