| |
| |
| Introduction | |
| |
| |
| About This Book | |
| |
| |
| Conventions Used in This Book | |
| |
| |
| What You Don't Have to Read | |
| |
| |
| Icons Used in This Book | |
| |
| |
| Foolish Assumptions | |
| |
| |
| How This Book Is Organized | |
| |
| |
| |
| Accessing Both Ends: Getting Data In and Info Out | |
| |
| |
| |
| 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 | |
| |
| |
| |
| 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 | |
| |
| |
| |
| Creating Simple Forms | |
| |
| |
| Creating Forms with the Help of a Wizard | |
| |
| |
| Building Forms the Hard Way: Using Design View | |
| |
| |
| Modifying Forms You've Created | |
| |
| |
| |
| 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 | |
| |
| |
| |
| Creating Effective Queries | |
| |
| |
| |
| Creating Multi-Table Queries | |
| |
| |
| Understanding Multi-Table Queries | |
| |
| |
| Adding Multiple Tables to Queries | |
| |
| |
| Linking to External Databases in Your Queries | |
| |
| |
| Understanding Relationships in Queries | |
| |
| |
| |
| 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 | |
| |
| |
| |
| Expanding Queries with SQL | |
| |
| |
| Getting the Scoop on SQL | |
| |
| |
| Understanding How SQL Can Help | |
| |
| |
| Viewing the SQL You've Already Created and Didn't Know About | |
| |
| |
| Getting Your Feet Wet with Simple SQL Statements | |
| |
| |
| Making Useful SQL Statements | |
| |
| |
| A Nod to VBA Programmers | |
| |
| |
| |
| Dealing with Quarrelsome Queries | |
| |
| |
| Troubleshooting Queries That Don't Quite Work | |
| |
| |
| Troubleshooting Sassy SQL | |
| |
| |
| Avoiding Improper Relationships | |
| |
| |
| Junking Joins That Don't Join | |
| |
| |
| Steering Around Empty Query Results | |
| |
| |
| Preventing Data Destruction | |
| |
| |
| |
| Building Really Useful Forms | |
| |
| |
| |
| 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 | |
| |
| |
| |
| 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 | |
| |
| |
| |
| 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 | |
| |
| |
| |
| Designing Great Reports | |
| |
| |
| |
| 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 | |
| |
| |
| |
| Creating Reports that Summarize Data | |
| |
| |
| Discovering How to Group Records | |
| |
| |
| Adding Subtotals and Totals | |
| |
| |
| Using Some Advanced Summarizing Methods | |
| |
| |
| |
| When Reports Go Wrong | |
| |
| |
| Troubleshooting Reports | |
| |
| |
| Avoiding Bad Report Layouts | |
| |
| |
| Eliminating Unnecessary Labels for Tighter Reports | |
| |
| |
| |
| Way Cool Advanced Queries, Forms, and Reports | |
| |
| |
| |
| Tricks for Finding Data with Queries | |
| |
| |
| Finding Just the Data You Need | |
| |
| |
| Creating Queries That Ask What to Find | |
| |
| |
| Excluding Data You Don't Want | |
| |
| |
| |
| 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 | |
| |
| |
| |
| Killer Ways to Improve Forms | |
| |
| |
| Prequalifying the Data Entered | |
| |
| |
| Crafting Forms That Are Easier to Use | |
| |
| |
| |
| Expert Methods for Sharing Reports | |
| |
| |
| Sharing Report Data with Microsoft Excel | |
| |
| |
| Sending Reports to Microsoft Word | |
| |
| |
| Using OLE Objects in Reports | |
| |
| |
| |
| Making Reports Look Better | |
| |
| |
| Enhancing the Appearance of Important Information | |
| |
| |
| Printing on Standard Labels | |
| |
| |
| Keeping Related Data Together | |
| |
| |
| Adding Your Logo to Reports | |
| |
| |
| |
| Adding Efficiency with Great Tools | |
| |
| |
| Using Cool Tools to Document Everything | |
| |
| |
| Souping Up Your Database | |
| |
| |
| Using Software to Share Stuff | |
| |
| |
| |
| The Part of Tens | |
| |
| |
| |
| Ten Great Access Sites Online | |
| |
| |
| Access Database Tips | |
| |
| |
| Access Monster | |
| |
| |
| Easy Access Database Directory | |
| |
| |
| Jamie's Software | |
| |
| |
| Lebans.com | |
| |
| |
| Microsoft Access Database Solutions | |
| |
| |
| Microsoft Office Online Access | |
| |
| |
| MSDN - Microsoft Developer Network | |
| |
| |
| Roger's Access Library | |
| |
| |
| The Access Web | |
| |
| |
| |
| Ten Things to Know About Queries (That Also Help You with Forms and Reports) | |
| |
| |
| Queries Act Like Tables | |
| |
| |
| Select Queries Are Always Safe | |
| |
| |
| All Queries Are SQL Queries | |
| |
| |
| Action Queries Can Harm Your Data | |
| |
| |
| You Need Joins to Use Multiple Tables in Queries | |
| |
| |
| Queries Select All Records Unless You Specify Criteria | |
| |
| |
| Datasheet View Shows Results without Running the Query | |
| |
| |
| Make-Table Queries Always Begin with an Empty Table | |
| |
| |
| Queries Need a Record Source | |
| |
| |
| Delete Queries Are Forever | |
| |
| |
| Index | |