{"product_id":"access-2007-vba-programming-for-dummies-isbn-9780470046531","title":"Access 2007 VBA Programming For Dummies","description":"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. \u003ci\u003eAccess 2007 VBA Programming For Dummie\u003c\/i\u003es 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:  \u003cul type=\"disc\"\u003e \u003cli\u003eBasic programming skills and concepts\u003c\/li\u003e \u003cli\u003eExplanations of modules, procedures, objects, and arguments\u003c\/li\u003e \u003cli\u003eAccess-unique programming activities, including SQL and recordsets\u003c\/li\u003e \u003cli\u003eHow to use the Visual Basic editor\u003c\/li\u003e \u003cli\u003eCreating dialog boxes, lists, drop-down menus, and functions\u003c\/li\u003e \u003cli\u003eIntegrating with other Office applications\u003c\/li\u003e \u003cli\u003eReady-to-use VBA code examples to type in or copy and paste from the Web\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eCompletely revised to reflect all changes found in Microsoft Access 2007, \u003ci\u003eAccess 2007 VBA Programming For Dummies\u003c\/i\u003e gives you access to Access like you’ve never had it before.\u003c\/p\u003e \u003cp\u003eIntroduction 1\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart I: Introducing VBA Programming 7\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: Where VBA Fits In 9\u003c\/p\u003e \u003cp\u003eChapter 2: Your VBA Toolkit 21\u003c\/p\u003e \u003cp\u003eChapter 3: Jumpstart: Creating a Simple VBA Program 35\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart II: VBA Tools and Techniques 49\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 4: Understanding Your VBA Building Blocks 51\u003c\/p\u003e \u003cp\u003eChapter 5: Controlling Access through VBA 71\u003c\/p\u003e \u003cp\u003eChapter 6: Programming Access Forms 87\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart III: VBA, Recordsets, and SQL 115\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 7: The Scoop on SQL and Recordsets 117\u003c\/p\u003e \u003cp\u003eChapter 8: Putting Recordsets to Work 147\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart IV: Applying VBA in the Real World 173\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 9: Creating Your Own Dialog Boxes 175\u003c\/p\u003e \u003cp\u003eChapter 10: Customizing Combo Boxes and List Boxes 201\u003c\/p\u003e \u003cp\u003eChapter 11: Creating Your Own Functions 239\u003c\/p\u003e \u003cp\u003eChapter 12: Testing and Debugging Your Code 265\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart V: Reaching Out with VBA 293\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 13: Using VBA with Multiple Databases 295\u003c\/p\u003e \u003cp\u003eChapter 14: Integrating with Other Office Applications 315\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart VI: The Part of Tens 349\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 15: Ten Commandments of Writing VBA 351\u003c\/p\u003e \u003cp\u003eChapter 16: Top Ten Nerdy VBA Tricks 357\u003c\/p\u003e \u003cp\u003eIndex 367\u003c\/p\u003e  \u003cb\u003eJoe Stockman\u003c\/b\u003e is an independent consultant, software designer, and author who has been using Microsoft Access since its initial release. He’s also developed courseware and taught classes in Access and VBA. Joe developed his first application in Access, and then migrated into Visual Basic and VB.NET, where he specializes in creating applications for the Windows Mobile platform. He worked for several software companies before forming his consulting business in 2002, where he deals with all types of clients including healthcare, financial, government, manufacturing, and small business. His ability to turn his customers’ wishes into working applications keeps them satisfied. Joe’s also writing the fundamentals column for the \u003ci\u003eAdvisor Guide to Microsoft Access\u003c\/i\u003e magazine.  \u003cp\u003e\u003cb\u003eAlan Simpson\u003c\/b\u003e is the author of over 100 computer books on databases, Windows, Web site design and development, programming, and networking. His books are published throughout the world in over a dozen languages and have millions of copies. Alan has also taught introductory and advanced computer programming courses at San Diego State University and the UCSD Extension. He has served as a consultant on high-technology, educationoriented projects for the United States Navy and Air Force. Despite that, Alan has no fancy job title because he has never had a real job.\u003c\/p\u003e  \u003cb\u003eCustomize combo and list boxes\u003c\/b\u003e  \u003cp\u003e\u003cb\u003eGo beyond forms and reports and build custom database solutions\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eNeed to know how VBA works in Access 2007? This plain-English guide introduces you to the fundamentals of VBA programming, helping you get the most out of your Access apps and giving you practical code examples for immediate use in your databases. You'll see how to control Access through VBA and apply powerful real-world VBA solutions.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eDiscover how to\u003c\/b\u003e\u003c\/p\u003e \u003cul\u003e \u003cli\u003eCreate simple VBA programs\u003c\/li\u003e \u003cli\u003eProgram Access forms\u003c\/li\u003e \u003cli\u003eManage Access tables with SQL and recordsets\u003c\/li\u003e \u003cli\u003eTest and debug your code\u003c\/li\u003e \u003cli\u003eUse VBA with multiple databases\u003c\/li\u003e \u003cli\u003eIntegrate with other Office apps\u003c\/li\u003e \u003c\/ul\u003e","brand":"For Dummies","offers":[{"title":"Default Title","offer_id":47988652703973,"sku":"NP9780470046531","price":29.99,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9780470046531.jpg?v=1761781127","url":"https:\/\/k12savings.com\/products\/access-2007-vba-programming-for-dummies-isbn-9780470046531","provider":"K12savings","version":"1.0","type":"link"}