Access 2007 VBA Programmer's Reference
Read an excerpt:
Chapter 1: Introduction to Microsoft Access 2007
Excerpt provided courtesy of John Wiley & Sons Inc. Copyright © John Wiley & Sons Inc. Written permission from the publisher is required for any use of this material.
|
Be the First to Write a Review and tell the world about this title!People who purchase this book frequently purchase: - Microsoft Office Access 2007 Inside Out; John Viescas, et al, $31.95, 36% Off!
- Microsoft Windows PowerShell Step By Step; Ed Wilson, $24.95, 38% Off!
- Microsoft Office Access 2007 Bible; Michael R. Groh, et al, $31.50, 37% Off!
- Microsoft Office Excel 2007 Visual Basic for Applications Step by Step; Reed Jacobson, $18.95, 37% Off!
Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
• 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
Table of Contents
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.
About the Authors
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.
|
