
Access 2007 VBA Programmer's Reference
by Hennig, Teresa; Cooper, Rob; Griffith, Geoffrey L.; Stein, ArmenRent Book
New Book
We're Sorry
Sold Out
Used Book
We're Sorry
Sold Out
eBook
We're Sorry
Not Available
How Marketplace Works:
- This item is offered by an independent seller and not shipped from our warehouse
- Item details like edition and cover design may differ from our description; see seller's comments before ordering.
- Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
- Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
- Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.
Summary
Author Biography
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.
Table of Contents
Introduction | |
Introduction to Microsoft Access | |
Access, VBA, and Macros | |
New Features in Access 2007 | |
Using the VBA Editor | |
VBA Basics | |
Using DAO to Access Data | |
Using ADO to Access Data | |
Executing VBA | |
VBA Error Handling | |
Using VBA to Enhance Forms | |
Enhancing Reports with VBA | |
Customizing the Ribbon | |
Creating Classes in VBA | |
Extending VBA with APIs | |
SQL and VBA | |
Working with Office Applications | |
Working with SharePoint | |
Database Security | |
Understanding Client/Server Development with VBA | |
Working with the Win32 Registry | |
Using the ADE Tools | |
Protecting Yourself with Access 2007 Security | |
Upgrading to Access 2007 | |
References for Projects | |
Calling Managed Code | |
DAO Object Method and Property Descriptions | |
ADO Object Model Reference | |
ADO Object Argument Information | |
The Access Object Model | |
Windows API Reference Information | |
Windows Registry Information | |
Access Wizards, Builders, and Managers | |
Reserved Words and Special Characters | |
Naming Conventions | |
Tips and Tricks | |
Index | |
Bibliography | |
Table of Contents provided by Publisher. All Rights Reserved. |
An electronic version of this book is available through VitalSource.
This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.
By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.
Digital License
You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.
More details can be found here.
A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.
Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.
Please view the compatibility matrix prior to purchase.