<h4>Take your database skills to the next level&#8212;develop powerful, custom Access 2010 applications using Visual Basic for Applications</h4><p><i>Microsoft Access 2010 VBA Macro Programming</i> guides you through the structure of VBA, showing you how to use it specifically in Access. The book explains, step by step, how to write VBA code&#8212;from the basics to dealing with errors and debugging code. This practical guide includes examples that illustrate how to use VBA in Access to do specific tasks. You&#8217;ll learn real-world skills by example. <p><i>Microsoft Access 2010 VBA Macro Programming</i> features:</b><ul><li>Easy-to-understand instructions that explain how to accomplish programming tasks right away<li>20 practical sample applications <li>Details on adding custom menus and Access add-ins</ul><p><b>All-inclusive coverage:</b><br>The Basics; Variables, Arrays, Constants and Data Types; Modules, Functions and Subroutines; Programming Basics: Decisions and Looping; Strings and Functions and Message Boxes; Operators; Debugging; Errors and the Error Function; Forms and Reports; Common Dialog Control; Working with the Ribbon; SQL Queries; Data Macros/Triggers; The Access and DAO Object Models; The Access and DAO Object Models - Main Objects; The DoCmd Object; Using Access to Interact with Other Office Programs; Charts and Graphs; Working with External Databases; API Calls; Class Modules; Animation; Get the Login ID; Secure Your Database; Creating Audit Trails on Tables; Create and Edit Queries in VBA; Search and Replace in Queries; Compact the Current Database using VBA; Monitoring Table Statistics; Handling Large Text Files; Create and Change Table Structures; Create and Objects Inventory; Manipulate Charts; Drill Down on Charts; Create an Excel Spreadsheet for output of Data; Using FTP in VBA; Use of Data Macros/Triggers; Use of Ribbon; Make Controls on Forms Interactive; Set Up Levels of User Security