Microsoft Access 2010 VBA Programming Inside Out

by Andrew Couch

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 codeUse the Access Object Model to work with data in forms and reportsManipulate data using SQL, queries, and recordsets with Data Access Objects (DAO)Create classes for handling form and control eventsConnect your Access database to different sources of dataEffectively plan how to upsize an existing Access database to Microsoft SQL Server®Dynamically update Microsoft Excel® spreadsheets from the databaseMigrate your Access database directly to the cloud using SQL Azure™

1141 pages, Kindle Edition

First published July 1, 2011

Reviews

[David Fournier · Rating 3 out of 5]

While this book was very informative I feel it spent a little to much time on programming for SQL and connecting to external databases, and not enough time on how to better program the forms, reports, and controls within Access 2010. If the author wanted to teach SQL, he could have spent more time on how to create more powerful or complex queries within Access.