Access Forms and Reports For Dummies
10%
off

Access Forms and Reports For Dummies

3 (7 ratings by Goodreads)
By (author) 

Free delivery worldwide

Available. Dispatched from the UK in 3 business days
When will my order arrive?

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
show more

Product details

  • Paperback | 408 pages
  • 192 x 234 x 21mm | 788g
  • Hungry Minds Inc,U.S.
  • Hoboken, NJ, United States
  • English
  • 0764599658
  • 9780764599651
  • 1,881,895

Back cover copy

Create queries that make forms and reports useful

Develop forms to access the data you need and make reports thatmake sense!

If you thought you had to use a spreadsheet program to producereports and forms, guess what! Access can turn out great-lookingforms and reports that actually show what's going on with your data-- if you know how to ask it nicely. This hands-on guide helpsyou do just that, and it works with all versions of Access.

Discover how to

Ask Access the right questionsWork with sets of dataCreate simple forms with a wizardUse queries to create new tablesTroubleshoot queriesAdd visual features to reports
show more

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
show more

About Brian Underdahl

Brian Underdahl is the well-known, best selling author of over 70 computer books on a broad range of subjects. He has appeared on a number of TV shows, including the
Computer Chronicles, and several
TechTV programs, and is the subject of an hour-long interview on the syndicated
Computer Outlook radio program. One of his titles was recently recommended to viewers by Scott Gurvey, Bureau Chief, on the
Nightly Business Report on PBS, and his books have won awards including an Award of Merit from the Northern California Technical Communications Competition and the Referenceware Excellence Award for best title in the Graphic Design and Multimedia category.

Brian has been involved in personal computers from their beginning and has a background in electrical engineering. His last real job was as a Senior Programmer/Analyst for a large company, where he worked hard to bring the power and freedom of PCs to the desktops.

Brian figures that it s the author who should do the work so that readers can get their money s worth. That s why his books are different he takes the time to explain what s going on so that readers can understand the subjects easily.
show more

Rating details

7 ratings
3 out of 5 stars
5 0% (0)
4 14% (1)
3 71% (5)
2 14% (1)
1 0% (0)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X