Access 2010 Programmer's Reference

by Hennig, Teresa; Cooper, Rob; Griffith, Geoffrey L.; Dennison, Jerry

• ISBN13: 9780470591666
• ISBN10: 0470591668
• Format: Paperback
• Copyright: 2010-08-09
• Publisher: Wrox

Summary

A comprehensive guide to programming for Access 2010 and 2007Millions of people use the Access database applications, and hundreds of thousands of developers work with Access daily. Access 2010 brings better integration with SQL Server and enhanced XML support; this Wrox guide shows developers how to take advantage of these and other improvements.With in-depth coverage of VBA, macros, and other programming methods for building Access applications, this book also provides real-world code examples to demonstrate each topic. Access is the leading database that is used worldwide While VBA remains the favored method for Access programming, more options are available for Access 2010, and this book covers them all Covers the Access Object model, using VBA with ADO, VBA execution and error handling, creating database objects, creating and enhancing forms and reports, using the Windows Registry, and much more Explains how to use VBA with SQL, APIs, and other Office applications, and how to create secure VBA code Companion Web site provides updates and links to useful resourcesAccess 2010 Programmer's Referenceis a comprehensive guide to the best-of-breed techniques for programming Access applications.

Author Biography

Teresa Hennig is a Microsoft Access MVP, and is President of the Seattle Access Group and the Pacific Northwest Access Developer Group. Her company, Data Dynamics NW, has been creating Access solutions since 1997.

Rob Cooper is a senior test lead at Microsoft. During the Access 2010 release, he led the team that worked on exciting new features such as the Macro Designer, Navigation Control, and Web Browser Control.

Geoffrey Griffith has more than 13 years experience with Access. He began his Access life working in Access 2.0 and eventually worked on the Microsoft Access Team for the Access 2007 release.

Jerry Dennison is a Microsoft Access MVP and has been developing custom and commercial Access applications since 1991. He is the owner of TradeIt! Software Support Services, an Access-based barter management solution.

Table of Contents

Introduction

Introduction to Microsoft Access 2010

New Features

Upgrading and Converting to Access 2010

Macros in Access 2010

Using the VBA Editor

VBA Basics

Using VBA in Access

Creating Classes in VBA

Extending VBA with APIs

Working with the Windows Registry

Using DAO to Access Data

Using ADO to Access Data

Using SQL with VBA

Using VBA to Enhance Forms

Enhancing Reports with VBA

Customizing the Ribbon

Customizing the Office Backstage

Working with Office 2010

Working with SharePoint

Working with .NET

Building Client-Server Applications with Access

The Access 2010 Templates

Access Runtime Deployment

Database Security

Access 2010 Security Features

The Access Object Model

DAO Object Method and Property Descriptions

ADO Object Model Reference

64-Bit Access

References for Projects

Reserved Words and Special Characters

Naming Conventions

The Access Source Code Control

Tips and Tricks

Index

Table of Contents provided by Publisher. All Rights Reserved.