InfoTech: Database

Various tips on using Microsoft Access.

*Note: These contents are assembled from several web sites, some of whom are now defunct. Although I have the documents in my records, I've provided the current links to available items. Copies of material from defunct sites, as well as my works, are provided below. Copyright belongs to the authors and/or publishers of the material according to the information contained in the documents. An internet search of the titles or of content from the material should be made for referencing purposes. The owner of this web site only claims authorship where indicated within the material.

10+ tips for working efficiently in Access’ Query Design window — To create an Access query, you use the Query Design window...Working efficiently in this environment can help you maintain accuracy and database integrity.

Access 2003 in Pictures by Tony Fowlie

A simple solution for tracking changes to Access data — when multiple users are changing data, a lot can go wrong. You might want to keep an audit trail of data input changes. In other words, you might want to know who's changing data and when.

Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills — This sample chapter explains the basics of Microsoft Access' pivot tables and pivot charts. (Download Free - registration required)

How do I... Fill Word form fields with Access data? — When you need to bring your Access data into a Word form, a little VBA can expedite the task. Susan Harkins walks through an example to demonstrate the process.

How do I... Print a single Microsoft Access record in Form View? — An automated single record print

How do I... Query for multiple values in Access on the fly? — Within the context of this article and its solution, the term multiple values refers to multiple unique values in the same field.