Microsoft Access 2010 VBA Programming Inside Out 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 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