Microsoft Access 2010 VBA Programming Inside Out

07/30/2011 · No Responses

You’re beyond the basics, so dive right in and customize, automate, and extend Access—using Visual Basic® 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®
Dynamically update Microsoft Excel® spreadsheets from the database
Migrate your Access database directly to the cloud using SQL Azure™

Table of Contents
Part I: VBA Environment and Language
Chapter 1. Using the VBA Editor and Debugging Code
Chapter 2. Understanding the VBA Language Structure
Chapter 3. Understanding the VBA Language Features

Part II: Access Object Model and Data Access Objects (DAO)
Chapter 4. Applying the Access Object Model
Chapter 5. Understanding the Data Access Object Model

Part III: Working with Forms and Reports
Chapter 6. Using Forms and Events
Chapter 7. Using Form Controls and Events
Chapter 8. Creating Reports and Events

Part IV: Advanced Programming with VBA Classes
Chapter 9. Adding Functionality with Classes
Chapter 10. Using Classes and Events
Chapter 11. Using Classes and Forms

Part V: External Data and Office Integration
Chapter 12. Linking Access Tables
Chapter 13. Integrating Microsoft Office

Part VI: SQL Server and SQL Azure
Chapter 14. Using SQL Server
Chapter 15. Upsizing Access to SQL Server
Chapter 16. Using SQL Azure

Part VII: Application Design
Chapter 17. Building Applications
Chapter 18. Using ADO and ADOX