* Completely revised, this book includes coverage of basic concepts and general VBA topics for nonprogrammers
* Some of the basic topics covered include modules, procedures, and objects; while more advanced topics are SQL record sets and other programming activities that are unique to Access programming
* Offers practical, ready-to-use solutions to various Access procedures so readers can just drop information into their databases and use it immediately
* Addresses using the Visual Basic Editor; creating a simple VBA program; using VBA with multiple databases; and integrating with other Office applications
* The companion Web site contains all the code from the book plus additional ready-to-use code snippets

Completely revised, this book includes coverage of basic concepts and general VBA topics for nonprogrammers. Some of the basic topics covered include modules, procedures, and objects; while more advanced topics are SQL record sets and other programming activities that are unique to Access programming. It offers practical, ready-to-use solutions to various Access procedures so readers can just drop information into their databases and use it immediately. It also addresses using the Visual Basic Editor; creating a simple VBA program; using VBA with multiple databases; and integrating with other Office applications. The companion Web site contains all the code from the book plus additional ready-to-use code snippets.

• Introduction.

  Part I: Introducing VBA Programming.

  Chapter 1: Where VBA Fits In.

  Chapter 2: Your VBA Toolkit.

  Chapter 3: Jumpstart: Creating a Simple VBA Program.

  Part II: VBA Tools and Techniques.

  Chapter 4: Understanding Your VBA Building Blocks.

  Chapter 5: Controlling Access through VBA.

  Chapter 6: Programming Access Forms.

  Part III: VBA, Recordsets, and SQL.

  Chapter 7: The Scoop on SQL and Recordsets.

  Chapter 8: Putting Recordsets to Work.

  Part IV: Applying VBA in the Real World.

  Chapter 9: Creating Your Own Dialog Boxes.

  Chapter 10: Customizing Combo Boxes and List Boxes.

  Chapter 11: Creating Your Own Functions.

  Chapter 12: Testing and Debugging Your Code.

  Part V: Reaching Out with VBA.

  Chapter 13: Using VBA with Multiple Databases.

  Chapter 14: Integrating with Other Office Applications.

  Part VI: The Part of Tens.

  Chapter 15: Ten Commandments of Writing VBA.

  Chapter 16: Top Ten Nerdy VBA Tricks.

  Index.