Databasics VII: Parameter Queries

Note: I’m working on updating this series of articles. This article is really showing its age. All the examples are forĀ  Microsoft Access 2000/2003, and things have changed a lot since then. While the concepts are still the same and you can learn a lot from...

Databasics VI: Exploring query types

Note: I’m working on updating this series of articles. This article is really showing its age. All the examples are forĀ  Microsoft Access 2000/2003, and things have changed a lot since then. While the concepts are still the same and you can learn a lot from...

Which database series should I read?

In the beginning there was a single series of database tutorials on this site. Now there are two. Which one should you read? If you’re looking for a nice, slow approach to learning databases, choose Databasics. It will help you learn the lingo, start with simple...

Databases from scratch III: The Design Process

This third article in the series delves into the database heartland by exploring relational database design. One of the best ways to understand the importance of good database design is to start with an all-in-one, flat-file table design and then toss in some sample...

Databases from scratch I: Introduction

When I was eighteen, I had a holiday job in an obscure back office of the New South Wales Stamp Duties Office. It doesn’t take an overactive imagination to realise that a temporary position in this bureaucratic outpost was not the most exhilarating of...