Wrox Press, 2007. – 574 p.
If you want to take your Access databases to a more robust level of functionality, this comprehensive guide provides the tools and techniques you'll need in order to build more sophisticated solutions.
Introduction to Access 2007 VBA
The Basics of Writing and Testing VBA Code
Programming Applications Using Objects
Creating Your Own Objects
Interacting with Data Using ADO and SQL
Building Interactive Forms
Importing, Linking, and Exporting Using External Data Sources
Using Access with Web Services and SharePoint Lists
Creating Reports and Web-Enabled Output
Building SQL Server Applications with Access Projects
Advanced Access Programming
Finishing the Application
Case Study 1-Project Tracker Application
Case Study 2-Customer Service Application