Brian Underdahl is the well-known, bestselling 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. Darlene Underdahl spent many years as a Quality Assurance expert. She is applying that “attention to detail” in the writing she does today. In addition to technical writing, she has written a memoir of her early years and is gathering notes for future projects. She works and lives with her husband, the bestselling author Brian Underdahl, in the mountains above Reno, Nevada.

• Introduction 1Part I: Accessing Both Ends: Getting Data In and Info Out 7Chapter 1: Getting to Know Forms and Reports 9Chapter 2: Getting Started with Queries 23Chapter 3: Creating Simple Forms 43Chapter 4: Building Basic Reports 65Part II: Creating Effective Queries 91Chapter 5: Creating Multi-Table Queries 93Chapter 6: Modifying Data with Queries 111Chapter 7: Expanding Queries with SQL 131Chapter 8: Dealing with Quarrelsome Queries 151Part III: Building Really Useful Forms 171Chapter 9: Building Better Forms by Using Controls 173Chapter 10: Using Multiple Tables in Forms 193Chapter 11: Fixing Form Faults 207Part IV: Designing Great Reports 221Chapter 12: Adding Fancy Touches to Reports 223Chapter 13: Creating Reports That Summarize Data 245Chapter 14: When Reports Go Wrong 263Part V: Way Cool Advanced Queries, Forms, and Reports 273Chapter 15: Tricks for Finding Data with Queries 275Chapter 16: Tricks for Updating with Queries 291Chapter 17: Killer Ways to Improve Forms 305Chapter 18: Expert Methods for Sharing Reports 327Chapter 19: Making Reports Look Better 339Chapter 20: Adding Efficiency with Great Tools 353Part VI: The Part of Tens 365Chapter 21: Ten Great Access Sites Online 367Chapter 22: Ten Things to Know about Queries (That Also Help You with Forms and Reports) 373Index 377

Brian Underdahl is the well-known, bestselling 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. Darlene Underdahl spent many years as a Quality Assurance expert. She is applying that “attention to detail” in the writing she does today. In addition to technical writing, she has written a memoir of her early years and is gathering notes for future projects. She works and lives with her husband, the bestselling author Brian Underdahl, in the mountains above Reno, Nevada.

• Introduction 1Part I: Accessing Both Ends: Getting Data In and Info Out 7Chapter 1: Getting to Know Forms and Reports 9Chapter 2: Getting Started with Queries 23Chapter 3: Creating Simple Forms 43Chapter 4: Building Basic Reports 65Part II: Creating Effective Queries 91Chapter 5: Creating Multi-Table Queries 93Chapter 6: Modifying Data with Queries 111Chapter 7: Expanding Queries with SQL 131Chapter 8: Dealing with Quarrelsome Queries 151Part III: Building Really Useful Forms 171Chapter 9: Building Better Forms by Using Controls 173Chapter 10: Using Multiple Tables in Forms 193Chapter 11: Fixing Form Faults 207Part IV: Designing Great Reports 221Chapter 12: Adding Fancy Touches to Reports 223Chapter 13: Creating Reports That Summarize Data 245Chapter 14: When Reports Go Wrong 263Part V: Way Cool Advanced Queries, Forms, and Reports 273Chapter 15: Tricks for Finding Data with Queries 275Chapter 16: Tricks for Updating with Queries 291Chapter 17: Killer Ways to Improve Forms 305Chapter 18: Expert Methods for Sharing Reports 327Chapter 19: Making Reports Look Better 339Chapter 20: Adding Efficiency with Great Tools 353Part VI: The Part of Tens 365Chapter 21: Ten Great Access Sites Online 367Chapter 22: Ten Things to Know about Queries (That Also Help You with Forms and Reports) 373Index 377

Brian Underdahl is the well-known, bestselling 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. Darlene Underdahl spent many years as a Quality Assurance expert. She is applying that “attention to detail” in the writing she does today. In addition to technical writing, she has written a memoir of her early years and is gathering notes for future projects. She works and lives with her husband, the bestselling author Brian Underdahl, in the mountains above Reno, Nevada.

• Introduction 1Part I: Accessing Both Ends: Getting Data In and Info Out 7Chapter 1: Getting to Know Forms and Reports 9Chapter 2: Getting Started with Queries 23Chapter 3: Creating Simple Forms 43Chapter 4: Building Basic Reports 65Part II: Creating Effective Queries 91Chapter 5: Creating Multi-Table Queries 93Chapter 6: Modifying Data with Queries 111Chapter 7: Expanding Queries with SQL 131Chapter 8: Dealing with Quarrelsome Queries 151Part III: Building Really Useful Forms 171Chapter 9: Building Better Forms by Using Controls 173Chapter 10: Using Multiple Tables in Forms 193Chapter 11: Fixing Form Faults 207Part IV: Designing Great Reports 221Chapter 12: Adding Fancy Touches to Reports 223Chapter 13: Creating Reports That Summarize Data 245Chapter 14: When Reports Go Wrong 263Part V: Way Cool Advanced Queries, Forms, and Reports 273Chapter 15: Tricks for Finding Data with Queries 275Chapter 16: Tricks for Updating with Queries 291Chapter 17: Killer Ways to Improve Forms 305Chapter 18: Expert Methods for Sharing Reports 327Chapter 19: Making Reports Look Better 339Chapter 20: Adding Efficiency with Great Tools 353Part VI: The Part of Tens 365Chapter 21: Ten Great Access Sites Online 367Chapter 22: Ten Things to Know about Queries (That Also Help You with Forms and Reports) 373Index 377