Access 2007 VBA programmer's reference "Programmer to programmer"--Cover. - Includes index

\* Providing complete and authoritative coverage of all aspects of VBA programming for Access applications, this book uses real-world code examples to demonstrate each programming topic\* Introductory chapters provide a brief overview of VBA and highlight what's new in Access 2007, the most popular database system in the world\* Shows experienced VBA developers and programmers how to create secure VBA code and examines how to use VBA with ADO, SQL, APIs, or other Office applications\* Demonstrates how to use the Access object model, the Windows registry, and ADE tools, and explains how to use VBA to create and enhance forms and reports\* The companion Web site includes updates to the book and links to useful resources Access 2007 VBA Programmer's Reference covers a wide spectrum of programming topics relevant to Access. Although it assumes the reader has some familiarity with VBA programming language, it begins with a brief introduction to VBA. And to help you leverage the tools that Access provides, a chapter highlights the new features in Microsoft Office Access 2007 -- including new wizards and GUI (graphical user interface) elements that previously required VBA code, as well as new VBA features. The book also discusses how to create and name variables, how to use Data Access Object (DAO) and ActiveX Data Object (ADO) to manipulate data both within Access and within other applications, proper error handling techniques, and advanced functions such as creating classes and using APIs. Key new objects such as using Macros and the Ribbon are explored, too, as are forms and reports, the two most powerful tools for working with and displaying data. Working with other applications is covered extensively both in a general nature and for working specifically with Microsoft Office applications, Windows SharePoint Services, and SQL Server. Of course, this book wouldn't be complete without discussing security issues and the Developer Extensions. --Publisher's description This text covers all features of VBA programming for Access database applications. It includes real-world examples to demonstrate each programming topic, including using the Access Object Model, VBA execution and error handling, creating database objects with VBA, writing secure VBA code and more Teresa Hennig ... [et Al.]. Programmer To Programmer--cover. Includes Index.