Skip to main content

Posts

Showing posts from May, 2009

Forming a New Reality

This post is part of an ongoing seriesDesign for ExceptionsSpreading the Sheets and Letting Relations InForming a New RealityThere's more to come... we're starting simple and working up... this will slowly become more complex to include SQL Server, ASP.Net web apps and ArcGIS.

Download the MS Access 2007 Project used in this post.

Now that we have our relationships all set up creating usable edit forms in MS Access 2007 is ludicrously easy.

Creating an Edit Form in MS Access in Four Satisfying Steps:
Open Beer, Open Access ProjectHighlight the table for which you want to create a form (let's start with Cities)Click the Create Tab, Select FormPress Save, Sip Beer

I'm not kidding. It is that easy. Here's my form (sips beer)


Repeat four steps for ZipCodes:


Wow! We are amazing. What else is there to do? (sips beer)

And that's the problem here, we're just sitting around sipping beer. This isn't real data. Well, it is real data, but it's a tiny little subs…

Spreading the Sheets and Letting Relations In

This post is part of an ongoing seriesDesign for ExceptionsSpreading the Sheets and Letting Relations InForming a New RealityThere's more to come... we're starting simple and working up... this will slowly become more complex to include SQL Server, ASP.Net web apps and ArcGIS.

In my last post I went off on relational database design patterns. Now let's try implementing these patterns in MS Access.
Download the MS Access 2007 Project used in this post.

In the old days we made spreadsheets. And they got ugly really quick. Let's work with our city-zipcode analogy from last time.

We started with what is basically a spreadsheet in MS Access:

We outgrew this quickly when we added Meridian:

I didn't mention this in my last post, but I see this all too often. Basic database design cue, if you're numbering your columns your design is wrong.

Why? Boise has 29 zipcodes. New York has 161. Washington, DC has 278. Do you really want 278 columns for storing zipcodes?

So you t…