AccessTM 2007 VBA Programmer's Reference
by Teresa Hennig; Rob Cooper ( ; ); Geoffrey L. Griffith; Armen SteinFormat: eBook
Pub. Date: 2007-07-01
Publisher(s): Wrox
Availability: This title is currently not available.
Other versions by this Author
-
This Item Qualifies for Free Shipping!*
*Excludes marketplace orders.
List Price: $41.99
Rent Book
Select for Price
New Book
We're Sorry
Sold Out
Used Book
We're Sorry
Sold Out
eBook
We're Sorry
Not Available
Summary
This resource provides the tools you need to leverage Access 2007's built-in functionality and VBA in order to build more dynamic applications. The author team explores all aspects of VBA programming for Access, describes the latest innovations, and explains how to take advantage of key new objects, enhanced macros, and the Office Ribbon. Plus, you'll find several commonly used techniques and sample code to help you get started, as well as expert tips to make your code easier to maintain.
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.