Stockman Joseph C., Simpson Alan. Microsoft Office Access 2007 VBA Programming For Dummies

Wiley Publishing, 2007. — 411 p. — (For Dummies). — ISBN: 0470046538, 978-0470046531.If you’ve been using Access for a while, you’re probably aware of its power and potential and itching to take advantage of both. Access 2007 VBA Programming For Dummies takes you beyond forms and reports and shows you how to use VBA to create killer Access databases and applications. This gentle introduction to VBA programming covers everything you need to get started, including:­Basic programming skills and conceptsExplanations of modules, procedures, objects, and argumentsAccess-­unique programming activities, including SQL and recordsetsHow to use the Visual Basic editorCreating dialog boxes, lists, drop-­down menus, and functionsIntegrating with other Office applicationsReady-­to-­use VBA code examples to type in or copy and paste from the WebCompletely revised to reflect all changes found in Microsoft Access 2007, Access 2007 VBA Programming For Dummies gives you access to Access like you’ve never had it before.Introducing VBA Programming
Where VBA Fits In
Your VBA Toolkit
Jumpstart: Creating a Simple VBA Program
VBA Tools and Techniques
Understanding Your VBA Building Blocks
Controlling Access through VBA
Programming Access Forms
VBA, Recordsets, and SQL
The Scoop on SQL and Recordsets
Putting Recordsets to Work
Applying VBA in the Real World
Creating Your Own Dialog Boxes
Customizing Combo Boxes and List Boxes
Creating Your Own Functions
Testing and Debugging Your Code
Reaching Out with VBA
Using VBA with Multiple Databases
ntegrating with Other Office Applications
The Part of Tens
Ten Commandments of Writing VBA
Top Ten Nerdy VBA TricksКак использовать язык программирования Visual Basic for Applications (VBA) для усиления баз данных в Microsoft Access.