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.