Skip to main content

Access Forms and Reports For Dummies

Access Forms and Reports For Dummies

Brian Underdahl

ISBN: 978-0-764-59965-1

Sep 2005

408 pages

In Stock

$34.99

Description

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

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