Expert Access 2007 Programming -- About the Authors -- Credits -- Acknowledgments -- Contents -- Introduction -- Building Off-the-Shelf Applications -- A Little Background -- What This Book Covers -- How This Book Is Structured -- What You Need to Use This Book -- Conventions -- Source Code -- Errata -- p2p.wrox.com -- Part I: Programming Access Applications -- Chapter 1: Overview of Programming for Access -- Writing Code for Access -- Windows API Programming -- Working with Managed Code -- Referencing Other Applications -- Summary -- Chapter 2: Extending Applications Using the Windows API -- Windows API Overview -- Retrieving System Information -- Windows Shell Functions -- Controlling Processes and Threads -- Windows Vista Task Dialogs -- Miscellaneous API Functions -- Summary -- Chapter 3: Programming Class Modules -- Overview of Class Modules -- Subclassing -- Interfaces -- Collections -- Events -- Design Considerations -- Summary -- Chapter 4: Debugging, Error Handling, and Coding Practices -- Debugging -- Error Handling -- Coding Practices -- Summary -- Part II: Data Manipulation -- Chapter 5: Parsing Data -- File Input/Output -- Splitting Strings -- Creating HTML -- Summary -- Chapter 6: Using SQL to Retrieve Data and Manipulate Objects -- Where SQL Can Be Used in Access -- The Various Types of SQL Queries -- Add Data from More Than One Table Using Table Joins -- Prompt Users for Data with Parameters -- Add Data from Other Databases Using the IN Clause -- Selection Predicates -- Aggregating Data -- Action Queries -- Crosstab Queries -- UNION Queries -- Subqueries -- Data Definition Queries -- SQL Pass-Through Queries -- ANSI Mode -- Summary -- Chapter 7: Managing Data -- Finding Data -- Categorization and Sorting -- Backup and Restore -- Using Checksum Functions -- Access 2007 Specifics -- Summary.

Part III: Interacting with the Application -- Chapter 8: Using Code to Add Advanced Functionality to Forms -- Working with Form Events -- Working with Controls -- Common Forms for Your Applications -- Custom Form Navigation -- Summary -- Chapter 9: Using Code to Add Advanced Functionality to Reports -- Interactive Reports Using Access 2007 -- Report Scenarios -- Creating a Report Manager -- Summary -- Chapter 10: Using Automation to Add Functionality -- Automation Basics -- Automating Windows -- Automating Office Applications -- Automating Internet Explorer -- Chapter 11: Creating Dynamic Ribbon Customizations -- Overview of Ribbon Customizations in Access -- Loading Ribbons -- Programming the Ribbon -- Organizing Ribbon Items -- Ribbon Controls -- New Types of Controls -- Images -- Moving Functionality into the Ribbon -- Other Ribbon Modifications -- Summary -- Part IV: Finalizing the Application -- Chapter 12: Configuration and Extensibility -- Localization -- Application Options -- Creating Form Themes -- Summary -- Chapter 13: Personalization and Security -- What Is Security? -- What Is Personalization? -- Overview of Security in Access 2007 -- Access 2007 Navigation Pane -- Password-Protecting Objects -- Windows Integration -- Simulating Record Level Security -- Database Encryption with DAO and ADO -- Best Practices -- Summary -- Chapter 14: Deployment -- Creating an Automated Build -- Handling Application Dependencies -- Licensing Your Applications -- Miscellaneous Deployment Scenarios -- Summary -- Chapter 15: Help and Documentation -- Documentation via Built-in Properties -- Providing Help to Users -- External Approaches -- Summary -- Appendix A: Programming Tips and Tricks -- Dynamically Running Code -- Object Helper Functions -- Date Data Type Tricks -- Miscellaneous Tips -- Tools for the Immediate Window -- Appendix B: Query Performance.

The Query Optimizer -- Designing Tables for Performance -- Designing Queries for Performance -- Other Performance Considerations -- Microsoft Access Performance Analyzer -- Appendix C: Pattern Reference -- Introducing Patterns -- Patterns Used in This Book -- Index.