Access Forms and Reports For Dummies
Published on 7. October 2005
Book
Paperback/Softback
416 pages
978-0-7645-9965-1 (ISBN)
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
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
More details
Language
English
Place of publication
United States
Publishing group
John Wiley & Sons Inc
Dimensions
Height: 236 mm
Width: 191 mm
Thickness: 23 mm
Weight
603 gr
ISBN-13
978-0-7645-9965-1 (9780764599651)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Other editions
Additional editions
Brian Underdahl
Access Forms and Reports For Dummies
E-Book
09/2005
Wiley
€22.99
Available for download
Person
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.
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.
Content
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
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