Mastodon

Databasics VII: Parameter Queries

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

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

Databasics V: Getting information out

Blog

The whole point of using a database is to turn data into information. Data are facts which have no inherent meaning; information is data put into context to convey meaning. Think of a customer database containing information such as customer names, addresses and phone...

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