Hennig T., Cooper R., Griffith G., Stein A. Access 2007 VBA Programmer’s Reference

Wiley Publishing, Inc., 2007. - 1110 p.Introduction to Microsoft Access 2007
Access, VBA, and Macros
New Features in Access 2007
Using the VBA Editor
VBA Basics
Using DAO to Access Data
Using ADO to Access Data
Executing VBA
VBA Error Handling
Using VBA to Enhance Forms
Enhancing Reports with VBA
Customizing the Ribbon
Creating Classes in VBA
Extending VBA with APIs
SQL and VBA
Working with Office Applications
Working with SharePoint
Database Security
Understanding Client-Server Development with VBA
Working with the Win32 Registry
Using the ADE Tools
Protecting Yourself with Access 2007 Security