The book shows you how you can build database solutions with Data Access Objects (DAO) and ActiveXData Objects (ADO); define database objects and manage database security with SQL; enhance and alter the way users interact with database applications with Ribbon customizations and event programming in forms and reports. You also learn how to program Microsoft Access databases for Internet access with Active Server Pages (Classic ASP), HTML, and XML.
Contains over thirty chapters loaded with illustrated Hands-On exercises and projects that guide you through the VBA programming language. Each example tells you exactly where to enter code and how to test it and then run it. Includes a companion disc with source code, supplemental files ,and colour screen captures (also available from the publisher for download) Explains how to store data for further manipulation in variables, arrays, and collections while teaching you to write both simple and complex VBA programming routines and functions. Teaches you how to programmatically create and access database tables and fields. Shows you how to insert, update, and delete data via programming code using various data access techniques. Gets you proficient creating and running simple and parameterized queries against your Access databases. Gets you comfortable using external data sources with Access (Excel, Word, flat files, XML, and SQL Server). Teaches you how to take control of your forms and reports by writing programming code known as event procedures. Shows you how to use various types of macros and templates. Takes your programming skills to the Web by introducing you to dynamic XML and Classic ASP pages. ONTHE DISC! (Files are also available by emailing proof of purchase to the publisher at email@example.com) All source code and supplemental files for the Hands-On exercises and custom projects All images from the text (including 4-colour screenshots)