Creating Atomic Fields

Creating Atomic Fields

One rule of database design is to make your fields atomic. This article discusses what an atomic field is, and why it’s important. What is an atom? First, let’s talk about atoms. In physics, an atom is the smallest unit of ordinary matter. We used to think atoms could...
Data Relationships

Data Relationships

Q: Data Relationships, what does that mean? A: It means data, usually in a database, can be related to other data in the database. Q: Really? How can data in a database be related to other data in a database? Are you saying one piece of data can begat another piece of...
What is a table?

What is a table?

What is a table?A table is an object that holds things. For example, a kitchen table hold things like plates, cups, and other things we use to eat our food. What is a database table?A database table also holds things. A database table holds data. How is the data...
Understanding the VBA Language

Understanding the VBA Language

After recording a macro in Microsoft Excel or Microsoft Word, often there is a need to edit the macro. However, before being able to successfully edit a macro written in VBA (Visual Basic for Applications), one first needs to know how to read it. That is the subject...
Sharing Macros

Sharing Macros

Our mothers taught us that you should share. Why? Because she said it would make us good play mates, would help our friends, and it would help keep peace in the home. Now that we are all grown up, we find the same is true in our organizations and with our macros. You...