In addition to being a popular desktop database management system, MS-Access is a versatile development tool. Beyond what is immediately available out of the box to store and retrieve data you can programme Access so as to provide you with greater control over database applications.

Objects & Names
Me? Programming?
A Name for Everything
Using Objects, Properties, and Methods
Setting Properties
The DoCmd Object

Your First Programme
What's a Programme?
Defining Procedures
Displaying a Message
Getting User Input
Interacting with Database Objects
Enumerating Collections
Evaluating If Conditions
Using DoCmd in a Procedure

The SQL Story
Why SQL?
Using the SQL View
FAQs about SQL
Defining a Data Set with SQL
SQL Comparison Operators
Calculated Columns
SQL Aggregate Functions
Using Parameters in Queries
Domain Aggregate Functions
Working with Automatically Generated SQL Statements
Making Smart Forms
Smart Calculations
Storing Calculated Values
Isolating Business Rules
Using Select Case
Using Local Variables
Using Lookup Tables with VBA
Time Stamping Entries
Entering Percentages
Changing the Form's Appearance
Working with Lists
Selection versus Entry
Self Referencing Lists
Changing for New Records Only
Displaying Related Lists
Smart defaults
Random Lists
Data & Forms
Logical Record Navigation
Selecting from Other Lists
Linking two list controls
Smart Navigation
Subforms
Null Values in Calculations
Making Your Own Dialog Boxes
Interactive Boxes
Forms as Dialog Boxes
Multiple Selections in One Dialog Box

Using Functions to Fill Lists
User Defined RowSourceType Functions
Multicolumn Lists

Printing, Reports and Output
Calculating Report Headings
Summary Tables on Reports
Multiple Selections
Fast Form Letters
The Replace Function
E mail, HTML, and Other Output
Controls & ActiveX
What's in a Name?
Working with ActiveX
Working with Object Fields
Using Word 2000 as an ActiveX Component

Controls & Objects
Synchronising Forms
ActiveX Controls
Using the Calendar to Select Records
Error Handling