Table of Contents

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.

About the Author

Julitta Korol studied 10 world languages before switching her language passion to computers. Since 1993, she has delivered custom-tailored, hands-on training and automated a host of companies by developing advanced database and spreadsheet applications. She has written 16 computer books.