normalforms.us logo
This site will eventually be a repository for some videos that I will be doing in regards to my work in Microsoft Access. It may take a bit of time to get around to this as I have plenty going on and the priority for this is not high on my list of things needing to be done. Nevertheless, once I get this rolling, it should come together quickly.

A Little Background

I have been writing Microsoft Access databases since 2.0 which was way back in the 1980s. Wasn't much of a program back then. Didn't, however, get ultra serious until Access 97 came out. At that point I needed to develop a few very important databases for our business and spent a large part of my time learning the ins and outs of this fine database program.

What I Intend to Do

At present, I am thinking about starting a new database for a fictitious web retail business working through the many utilities that will be required for a serious database, followed by the tables necessary to run a small online business. Many of the forms, code, etc., have already been written so it shouldn't be too difficult for me to put this out there for everyone to learn from. That is, if there really is anything anyone can learn from me ;^)

I have a great microphone here and Camtasia, so you all know I am serious about doing this! In any event, I hope to be able to get on this soon.

What My First Video Will Be

I have this very nice postal code table with one hundred thousand records. Each postal code within this table has the city and state listed as well. This is used to grab the state and city when a postal code is entered as a part of a client's information. I will demonstate splitting off the cities from this table, creating a new table with just cities. The reason for this is that many postal codes in the states have more than one city or town available for a single postal code. The way this table is now set up, only one city will appear for each postal code. Not good enough. We can fairly easily create a one-to-many relationship between the postal code table and a city table and allow the use of more than one city for each postal code. Lots of interesting things can be demonstrated by doing this process as a video.



Until content can be added here, might I suggest another good place to spend some time.

http://www.classicshorts.com

or, you might want to look at my hexidecimal conversion table for colors. I use this when I have the RGB numbers and need to convert these number to hex.

Hexidecimal Tables


This page, and all contents, are © normalforms.us, Bangor, Maine, U.S.A.
All Rights Reserved.