Access 2007 Programming by Example with VBA, XML, and ASP

Description

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).

    * Work with the new features for tables, forms, reports, macros, and templates that are available in the Access 2007 user interface.

CONTENTS:

Introduction

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

INDEX