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

Databasics V: Getting information out

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

Databasics I: Records & queries & keys, oh my!

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

A database dictionary

database: A collection of related information stored in a structured format. Database is often used interchangeably with the term table (Lotus Approach, for instance, uses the term database instead of table). Technically, they’re different: A table is a single...