Microsoft Access 2010 VBA Programming Inside Out

Description

You're beyond the basics, so dive right in and customize, automate, and extend Access-using Visual Basic(R) for Applications (VBA). This supremely organized reference is packed with hundreds of time-saving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Discover how the experts use VBA to exploit the power of Access-and challenge yourself to new levels of mastery!

* Enhance your application with VBA built-in functions and SQL code
* Use the Access Object Model to work with data in forms and reports
* Manipulate data using SQL, queries, and recordsets with Data Access Objects (DAO)
* Create classes for handling form and control events
* Connect your Access database to different sources of data
* Effectively plan how to upsize an existing Access database to Microsoft SQL Server(R)
* Dynamically update Microsoft Excel(R) spreadsheets from the database
* Migrate your Access database directly to the cloud using SQL Azure™

CONTENTS:

; Introduction; Who This Book Is For; Assumptions About You; How This Book Is Organized; Features and Conventions Used in This Book; Text Conventions; Design Conventions; About the Companion Content; Access Versions; Acknowledgments; Support and Feedback; Errata & Support; We Want to Hear from You; Stay in Touch; How to Access Your Online Edition Hosted by Safari; How to Download the Online Edition to Your Computer; VBA Environment and Language; Chapter 1: Using the VBA Editor and Debugging Code; 1.1 Debugging Code on a Form; 1.2 Creating Modules and Procedures; 1.3 Debugging Code in a Module; 1.4 Breakpointing Code; 1.5 Using the Object Browser and Help System; 1.6 Summary; Chapter 2: Understanding the VBA Language Structure; 2.1 VBA Language Settings; 2.2 Working with Constants and Variables; 2.3 Functions and Procedures; 2.4 Control Statements and Program Flow; 2.5 Summary; Chapter 3: Understanding the VBA Language Features; 3.1 Using Built-In Functions; 3.2 Domain Functions; 3.3 SQL and Embedded Quotes; 3.4 Objects and Collections; 3.5 Creating Maintainable Code; 3.6 VBA and Macros; 3.7 Error Handling; 3.8 Summary; Access Object Model and Data Access Objects (DAO); Chapter 4: Applying the Access Object Model; 4.1 The Application Object Methods and Properties; 4.2 The CurrentProject and CurrentData Objects; 4.3 The DoCmd Object; 4.4 Manipulating the Forms and Reports Collections; 4.5 Using the Screen Object; 4.6 Enhancing the User Interface; 4.7 Summary; Chapter 5: Understanding the Data Access Object Model; 5.1 The DAO Model; 5.2 Working with Databases; 5.3 Manipulating Data with Recordsets; 5.4 Working with Queries in Code; 5.5 Investigating and Documenting Objects; 5.6 Sample Applications; 5.7 Summary; Working with Forms and Reports; Chapter 6: Using Forms and Events; 6.1 Displaying Records; 6.2 Filtering by Using Controls; 6.3 Interacting with Records on a Form; 6.4 Editing and Undo on a Record; 6.5 Summary; Chapter 7: Using Form Controls and Events; 7.1 Control Events; 7.2 Combo Boxes; 7.3 List Boxes; 7.4 The TreeView Control; 7.5 The Tab Control; 7.6 Summary; Chapter 8: Creating Reports and Events; 8.1 Report Event Sequences; 8.2 Report Layout Control; 8.3 Summary; Advanced Programming with VBA Classes; Chapter 9: Adding Functionality with Classes; 9.1 Improving the Dynamic Tab Control; 9.2 Creating a Hierarchy of Classes; 9.3 Summary; Chapter 10: Using Classes and Events; 10.1 WithEvents Processing; 10.2 Abstract and Implementation Classes; 10.3 Friend Methods; 10.4 Summary; Chapter 11: Using Classes and Forms; 11.1 Opening Multiple Instances of a Form; 11.2 Classes and Binding Forms; 11.3 ActiveX Controls and Events; 11.4 Summary; External Data and Office Integration; Chapter 12: Linking Access Tables; 12.1 Linking Access to Access; 12.2 Linking to Excel and Text Files; 12.3 Linking to SQL Server; 12.4 Linking to SQL Azure; 12.5 Linking to SharePoint Lists; 12.6 Linking Access Web Databases; 12.7 Summary; Chapter 13: Integrating Microsoft Office; 13.1 Working with Objects and Object Models; 13.2 Connecting Access to Word; 13.3 Connecting Access to Excel; 13.4 Connecting Access to Outlook; 13.5 Summary; SQL Server and SQL Azure; Chapter 14: Using SQL Server; 14.1 Introducing SQL Server; 14.2 Getting Started with the SQL Server Management Studio; 14.3 Creating Tables and Relationships; 14.4 Working with Views; 14.5 Working with Stored Procedures; 14.6 Introducing T-SQL; 14.7 Working with Triggers; 14.8 Working with Transactions; 14.9 User-Defined Functions; 14.10 Getting Started with SQL Server Security; 14.11 Summary; Chapter 15: Upsizing Access to SQL Server; 15.1 Planning for Upsizing; 15.2 The Upsizing Wizard and the SQL Server Migration Assistant; 15.3 Developing with Access and SQL Server; 15.4 Summary; Chapter 16: Using SQL Azure; 16.1 Introducing SQL Azure; 16.2 Migrating SQL Databases; 16.3 The Data Sync Feature; 16.4 Planning and Managing Security; 16.5 Building Multi-Tenanted Applications; 16.6 SQL Server Migration Assistant and Access to Azure; 16.7 Summary; Application Design; Chapter 17: Building Applications; 17.1 Developing Applications; 17.2 Completing an Application; 17.3 Deploying Applications; 17.4 Summary; Chapter 18: Using ADO and ADOX; 18.1 ActiveX Data Objects; 18.2 Working with SQL Server; 18.3 ADOX; 18.4 Summary; About the Author;