Access Data Analysis Cookbook: Managing Tables, Fields, Indexes, and Queries

Overview

One uses tables to store data, indexes to organize and order data, and queries to work with data. In a perfect world, when a database goes into production, the development effort is finished. Alas, this is not a typical scenario. New requirements come along. Table structures have to be changed. New indexes are needed. New queries are called for to match the new schema. This paper addresses how to manage these things programmatically. If one has done much work with Access, one knows how tedious it can be to manually create tables.