Access 2007 VBA Programmer's Reference
Published on 10. July 2007
1100 pages
978-0-470-14799-3 (ISBN)
Description
Access 2007 VBA Programmer's Reference covers a widespectrum of programming topics relevant to Access. Although itassumes the reader has some familiarity with VBA programminglanguage, it begins with a brief introduction to VBA. And to helpyou leverage the tools that Access provides, a chapter highlightsthe new features in Microsoft Office Access 2007 -- includingnew wizards and GUI (graphical user interface) elements thatpreviously required VBA code, as well as new VBA features.
The book also discusses how to create and name variables, how touse Data Access Object (DAO) and ActiveX Data Object (ADO) tomanipulate data both within Access and within other applications,proper error handling techniques, and advanced functions such ascreating classes and using APIs. Key new objects such as usingMacros 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 ageneral nature and for working specifically with Microsoft Officeapplications, Windows SharePoint Services, and SQL Server. Ofcourse, this book wouldn't be complete without discussingsecurity issues and the Developer Extensions.
More details
Other editions
Additional editions
Teresa Hennig | Rob Cooper | Geoffrey L. Griffith
Access 2007 VBA Programmer's Reference
Book
05/2007
Wrox Press
€37.90
Article exhausted; check different version
Persons
Teresa Hennig is president of both the PacificNorthwest Access Developer Group and the Seattle Access Group, andis host for INETA's monthly webcasts. She was thecoordinating author for Access 2003 VBA Programmer's reference, andcontinues to publish two monthly Access newsletters. In recognitionof her expertise and dedication to the Access community, Teresa wasawarded Microsoft Access MVP.
Rob Cooper is a test lead on the Access team atMicrosoft. During the Access 2007 release, he led thesecurity efforts across the test team and worked on several newfeatures including disabled mode, database encryption, Office TrustCenter, and sorting, grouping and totals. Rob also led effortsaround the Access object model and continues to provide directionaround programmability and security in Access.
A long-time fan of Access, Rob is a frequent speaker at the SeattleAccess Group and PNWADG meetings and has written for the MicrosoftKnowledge Base and Access Advisor.
Geoffrey Griffith is an avid Access user who contributedto the Access 2007 product as a Software Design Engineer in Testfor the Microsoft Office Access team. He enjoys participating insoftware community events by attending and speaking for local usersgroups and helping all those who would seek it.
Armen Stein is a Microsoft Access MVP and the presidentof J Street Technology, Inc., a team of database applicationdevelopers in Redmond, Washington. Armen is PresidentEmeritus of the Pacific Northwest Access Developers Group, and hasalso spoken at Seattle Access and Portland Access Users Groupmeetings. He has taught database classes at Bellevue CommunityCollege, and also developed and taught one-day training classes onAccess and Access/SQL Server development.
Content
Introduction.
1. Introduction to Microsoft Access.
2. Access, VBA, and Macros.
3. New Features in Access 2007.
4. Using the VBA Editor.
5. VBA Basics.
6. Using DAO to Access Data.
7. Using ADO to Access Data.
8. Executing VBA.
9. VBA Error Handling.
10. Using VBA to Enhance Forms.
11. Enhancing Reports with VBA.
12. Customizing the Ribbon.
13. Creating Classes in VBA.
14. Extending VBA with APIs.
15. SQL and VBA.
16. Working with Office Applications.
17. Working with SharePoint.
18. Database Security.
19. Understanding Client/Server Development with VBA.
20. Working with the Win32 Registry.
21. Using the ADE Tools.
22. Protecting Yourself with Access 2007 Security.
Appendix A. Upgrading to Access 2007.
Appendix B. References for Projects.
Appendix C. Calling Managed Code.
Appendix D. DAO Object Method and Property Descriptions.
Appendix E. ADO Object Model Reference.
Appendix F. ADO Object Argument Information.
Appendix G. The Access Object Model.
Appendix H. Windows API Reference Information.
Appendix I. Windows Registry Information.
Appendix J. Access Wizards, Builders, and Managers.
Appendix K. Reserved Words and Special Characters.
Appendix L. Naming Conventions.
Appendix M. Tips and Tricks.
Index.
Bibliography.
