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.

Synopsis

The 2007 release of Microsoft Office Access' comes with many changes to the user interface and the database engine. Novice users, power users, and developers, all have been given a myriad of new and improved tools and resources for their database needs. This book is the only by example programming guide to the best-selling Microsoft Office Access'. Unlike other books currently on the market, it's written specifically to address the needs of Access power users who are ready to make the jump into programming.