Access 2007 Programming by Example with VBA, XML, and ASP shows non-programmers how Access databases can be created, managed, and customized with Visual Basic for Applications (VBA) - a powerful programming language built into Access. Hundreds of hands-on examples and projects throughout the book show users how to take charge of their Access databases with programming. Learn how to Write and debug your programming code with the Visual Basic Editor; access and manipulate databases with Data Access Objects (DAO) and ActiveX Data Objects (ADO); use the Data Definition Language (DDL) to enforce data integrity and manage database security; modify the behavior of forms, reports, and controls by writing event procedures; publish dynamic Access data to the web using Active Server Pages (ASP) and Extensible Markup Language (XML); and work with the new features for tables, forms, reports, macros, and templates that are available in the Access 2007 user interface.

Table of Contents

Part I: Introduction to Access 2007 VBA Programming; Part II: Access VBA Programming with DAO and ADO; Part III: Programming with the Jet Data Definition Language; Part IV: Event Programming in Forms and Reports; Part V: Taking Your VBA Programming Skills to the Web; Part VI: Working with New Features in Access 2007.