Access forms & reports for dummies

 Content: Cover About the Author Authors Acknowledgments Contents at a Glance Table of Contents Introduction About This Book Conventions Used in This Book What You Dont Have to Read Icons Used in This Book Foolish Assumptions How This Book Is Organized Part I: Accessing Both Ends: Getting Data In and Info Out Chapter 1: Getting to Know Forms and Reports Finding a Fascination with Forms Recognizing Why Reports Rock Seeing Why Both Forms and Reports Have a Place Understanding the Value of Queries Queries, Forms, and Reports Basics You Must Endure Access Add-Ons and Extra Cool Tools Chapter 2: Getting Started with Queries Understanding the Types of Queries Creating Queries by Using a Wizard Creating Queries in Design View Modifying Queries for Better Results Chapter 3: Creating Simple Forms Creating Forms with the Help of a Wizard Building Forms the Hard Way: Using Design View Modifying Forms Youve Created Chapter 4: Building Basic Reports Getting to Know the Types of Access Reports Creating Reports by Using a Wizard Designing Reports from Scratch Modifying Report Layouts Adding Data from External Linked Tables Part II: Creating Effective Queries Chapter 5: Creating Multi-Table Queries Understanding Multi-Table Queries Adding Multiple Tables to Queries Linking to External Databases in Your Queries Understanding Relationships in Queries Chapter 6: Modifying Data with Queries Understanding What You Can Modify with a Query Being Called to Action: Data-Modifying Queries Creating New Tables with Queries Updating Data by Using Queries Deleting Data with Queries Adding New Data with Queries Chapter 7: Expanding Queries with SQL Getting the Scoop on SQL Understanding How SQL Can Help Viewing the SQL Youve Already Created and Didnt Know About Getting Your Feet Wet with Simple SQL Statements Making Useful SQL Statements A Nod to VBA Programmers Chapter 8: Dealing with Quarrelsome Queries Troubleshooting Queries That Dont Quite Work Troubleshooting Sassy SQL Avoiding Improper Relationships Junking Joins That Dont Join Steering Around Empty Query Results Preventing Data Destruction Part III: Building Really Useful Forms Chapter 9: Building Better Forms by Using Controls Getting to Know the Controls Common Controls You Can Use Adding Controls to Your Forms Incorporating ActiveX Controls Modifying the Characteristics of Controls Chapter 10: Using Multiple Tables in Forms Understanding Forms and Subforms Adding Fields from Multiple Tables to Your Forms Choosing the Best Subform View Adding Multiple Subforms Navigating Records in Multi-Table Forms Chapter 11: Fixing Form Faults Preventing Invalid Data with Input Masks Limiting a User to Specific Values with Validation Rules Preventing Users from Changing Records Looking Out for Poorly Formatted Data Part IV: Designing Great Reports Chapter 12: Adding Fancy Touches to Reports Adding Descriptive Titles to Your Reports Getting Dynamic with Your Titles Coming up with Page Title Ideas Adding Dates and Page Numbers Making Records Easier to Read with Alternating Bands of Color Making Records Stand Out Chapter 13: Creating Reports that Summarize Data Discovering How to Group Records Adding Subtotals and Totals Using Some Advanced Summarizing Methods Chapter 14: When Reports Go Wrong ... Troubleshooting Reports Avoiding Bad Report Layouts Eliminating Unnecessary Labels for Tighter Reports Part V: Way Cool Advanced Queries, Forms, and Reports Chapter 15: Tricks for Finding Data with Queries Finding Just the Data You Need Creating Queries That Ask What to Find Excluding Data You Dont Want Chapter 16: Tricks for Updating with Queries Creating New Fields with a Query Adding Default Values by Using a Query Performing Calculations Updating Records by Using Data from Another Table Chapter 17: Killer Ways to Improve Forms Prequalifying the Data.