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 Active X 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 Share Point Services, and SQL Server. Of
course, this book wouldn’t be complete without discussing
security issues and the Developer Extensions.
Inhaltsverzeichnis
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 Share Point.
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.
Über den Autor
Teresa Hennig is president of both the Pacific
Northwest Access Developer Group and the Seattle Access Group, and
is host for INETA’s monthly webcasts. She was the
coordinating author for Access 2003 VBA Programmer’s reference, and
continues to publish two monthly Access newsletters. In recognition
of her expertise and dedication to the Access community, Teresa was
awarded Microsoft Access MVP.
Rob Cooper is a test lead on the Access team at
Microsoft. During the Access 2007 release, he led the
security efforts across the test team and worked on several new
features including disabled mode, database encryption, Office Trust
Center, and sorting, grouping and totals. Rob also led efforts
around the Access object model and continues to provide direction
around programmability and security in Access.
A long-time fan of Access, Rob is a frequent speaker at the Seattle
Access Group and PNWADG meetings and has written for the Microsoft
Knowledge Base and Access Advisor.
Geoffrey Griffith is an avid Access user who contributed
to the Access 2007 product as a Software Design Engineer in Test
for the Microsoft Office Access team. He enjoys participating in
software community events by attending and speaking for local users
groups and helping all those who would seek it.
Armen Stein is a Microsoft Access MVP and the president
of J Street Technology, Inc., a team of database application
developers in Redmond, Washington. Armen is President
Emeritus of the Pacific Northwest Access Developers Group, and has
also spoken at Seattle Access and Portland Access Users Group
meetings. He has taught database classes at Bellevue Community
College, and also developed and taught one-day training classes on
Access and Access/SQL Server development.
Ebooks vom selben Autor / Herausgeber
16.570 Ebooks in dieser Kategorie
