Running a parameter query

Interactive, on-the-fly parameter queries add a huge amount of flexibility and power to run-of-the-mill static queries. Learn how to create your own using Microsoft Access.

Continue Reading

A select query

Learn how to start building more complex database queries, such as comparative and action queries, using Microsoft Access.

Continue Reading


Not sure which series of database tutorials on Geekgirl’s Plain English Computing is right for you, Databasics or Databases from Scratch? Here’s a quick description of their contents.

Continue Reading

Eliminating recurring fields

This third article in the Databases from Scratch series delves into the database heartland by exploring relational database design.

Continue Reading

A flawed table design

The second in a series of articles on choosing, designing and using a database program. This one covers simple table design.

Continue Reading

A simple relational database

The first in a series of articles on choosing, designing and using a database program.

Continue Reading

Figure 1. Which error message would you rather be confronted with?  Access's in-built one (top) or the custom-made one (bottom)? The lesson is, don't rely on inbuilt error messages – create your own so your users are informed rather than bemused.

In the previous tutorial I discussed some guidelines for creating data entry screens that are easy to use. In this tutorial, we’ll put those guidelines into action by refining the membership database we introduced in part two of this series. I’ll step through the process in Microsoft Access 2000 and Microsoft Access 2010. If you’re […]

Continue Reading

Databasics III: Data entry design

Published on 03/05/2010 by in Databases

On this data entry form, help is provided both on the form itself and in the form of pop-up tooltips. Microsoft Access makes it particularly easy to add this sort of help to data entry screens.

It’s staggering how many shareware and commercial database applications have appalling data entry screens. Many developers seem to think that well-oiled inner workings are all that’s needed to sell an application, when any user knows that, when you get down to it, the interface is the app. When you’re designing a database application, you’re taking […]

Continue Reading


This tutorial guides you through building a simple, single-file database. In a single-file database, also known as a flat-file database, you put all your information into a single table. This is the simplest form of database to create, but it has some serious limitations and disadvantages. The most important of these limitations are that single-table […]

Continue Reading

A multi-file database for managing fundraising campaigns for a non-profit organisation. It consists of eight tables (listed in the top of the pane on the left)

What’s a database? If you think of word processors as… well… processors of words, and spreadsheets as number processors, then you can think of databases as processors of unstructured information, aka “data”. Feed a database data in any sort of guise – as numbers, text, dates, images, web links – and it will digest all […]

Continue Reading

A database dictionary

Published on 02/28/2010 by in Databases


Can’t tell your first normal form from your third? Untangle basic database jargon with this easy-to-understand dictionary of terms.

Continue Reading


I’ve put the Kindle and the Sony Reader aside for a day to finish writing my latest comparative review of database software for Australian PC User magazine. I’ve been writing such reviews since the early 1980s, when dBASE was top dog in the database stakes. It was a seriously buggy program, but in the very […]

Continue Reading