Expand the range of your Access proficiency with VBA programming, using this guide designed specifically for Access power users. Learn VBA fundamentals, then discover how to connect Access and VBA through ActiveX Data Objects (ADO), and how to extract, manipulate, and retrieve data using SQL queries. Benefit from expert advice on error handling, get the most out of forms, reports, and tables, and save time with VBA coding and debugging tips. From the basics to advanced techniques, this comprehensive treatment provides you with the information you need to produce the exact results you desire.

Call up forms and reports using VBA
Build dynamic Data Access Pages
Program and assign record data sources to forms and reports
Learn the fundamentals of SQL and how to use it in VBA
Understand the ADO object model and its components
Use modules, declare variables, build looping and decision structures, use procedures and functions, and build arrays
Generate recordsets based on dynamic criteria
Use Office menus and toolbars to invoke your code
Develop applications that multiple users can run at the same time