Been There, Done That, Sent it to Production

I admit I ripped off the last part of that title. I heard it at the Access 14 Developers' Kitchen in Redmond a couple of weeks ago. One of the presenters had the all-too familiar experience of having a bug pop up in the middle of his demo. It turned out to be one of those trivial things that we all do from time to time and it was quickly fixed. While he was tweaking his code, several audience members called out variations of the familiar "Been There, Done That". Then after an appropriate pause, Doug Yudovich added his version, "Been There, Done That, Sent It to Production." In a moment of universal recognition, everyone in the room sighed and nodded in agreement.

Normalization for Normal People, Part I--The "Language" of the Database, cont'd. AGAIN

Last time, I ended my post with an ambiguous reference to my birth date. I did that to make a couple of points. Well, actually I wanted to reinforce a point I'd made in an earlier blog as well as to introduce one new point.

The reinforced point is that ambiguity in natural languages, like English, is desirable

Normalization for Normal People--Introduction

As an administrator and regular contributor at http://www.utteraccess.com/, I see, and sometimes answer, a lot of questions asking for help in designing forms, or creating queries or writing functions to enter and display, retrieve or update data. Eight times out of ten, the real, underlying, problem turns out to be inappropriate table design.