Develop custom Access VBA macros

Perfect for power users, Microsoft Access 2010 VBA Macro Programming reveals how to maximize the features and functionality of Access 2010. You’ll get in-depth details on Access VBA programming and application development followed by 20 real-world projects--complete with source code--that show you how to set up specific subroutines and functions. This practical resource then explains how to include the subroutines in the Access menu system and transform a set of interrelated VBA macros into an Access add-in package. Create your own Access 2010 VBA macros right away with help from this hands-on guide.

Learn how to:

• Create and enhance forms and reports
• Design custom dialog boxes and buttons
• Develop custom menus for the Ribbon
• Use SQL queries with VBA
• Create table macros
• Use Office object models to interact with other Microsoft applications
• Create and manipulate charts and graphs
• Work with external databases
• Add functionality to your programs with API calls
• Animate objects in Access
• Enhance database security
• Create audit trails
• Handle large text files
• Transfer data via FTP