This book is designed to take Microsoft Access users to the next step in programming. Its five parts cover an intro-duction to VBA programming, manipulating databases with ADO, using DDL, event programming, and using ASP and XML. With more than 300 hands-on examples and 11 custom projects, users can quickly build the toolset required for developing their own database solutions.

The latest release of the Microsoft Office family of applications comes with many bells and whistles. Access continues to be the world's most popular database. With the increasing volume of information, knowing how to design and program databases is becoming more and more important. With most users having mastered the use of Access databases, this book is designed to take them to the next step -- programming. "Access 2003 Programming by Example with VBA, ASP and XML" takes non-programmers through detailed steps of creating Access databases from scratch and then to retrieve and manage their data using various programming languages and techniques. With this book at hand, users can quickly build the toolset required for developing their own database solutions. This book proves that programming Access databases and controlling it with various types of programming code can be as easy as working with the built-in user interface. The book offers more hands-on and custom projects than any other book ever published on Access programming. It consists of six parts that cover an introduction to VBA programming, using ActiveX Data Objects (ADO), Data Definition Language (DDL), event programming, Active Server Pages (ASP), and Extensible Markup Language (XML). The downloadable companion files include all the book's projects as well as a PDF file that covers creating and manipulating databases using Data Access Objects (DAO), an older data access technology that Access still uses.

• Procedures and Modules
• The Visual Basic Editor (VBE)
• Variables, Data Types and Constants
• Passing Arguments to Procedures and Functions
• Decision Making with VBA
• Repeating Actions in VBA
• Working with Arrays
• Custom Collections and Class Modules
• Debugging VBA Procedures and Handling Errors
• Accessing Data Using ADO
• Creating and Accessing Tables and Fields with ADO
• Setting Up Indexes and table Relationships with ADO
• ADO Techniques for Finding and Reading Records
• Working with Records
• Creating and Running Queries with ADO
• Using Advanced ADO Features
• Database Replication
• Creating, Modifying and Deleting Tables and Fields
• Enforcing Data Integrity and Relationships Between Tables
• Defining Indexes and primary Keys
• Database Security
• Viewed and Stored Procedures
• Using Form Events
• Using Report Events
• Events Recognised by Controls
• Access and Active Server Pages
• XML Features in Access 2003
• Index.