dbms | Geekgirl's

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

Blog, Databases, Office Apps

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...

Databases from scratch III: The Design Process

Databases, Office Apps

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 II: Simple Database Design

Databases, Office Apps

Have you ever noticed advertisements in the job classifieds for ‘database architects’ or ‘database administrators’? It makes database design sound pretty intimidating, doesn’t it? If they’re so difficult to use that they require...

Databases from scratch I: Introduction

Databases, Office Apps

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...