Access is horrible tool to teach relational database theory with.
It's also an awful tool to teach SQL with.
The 'reverse' would be command line Osql would be a horrible power user tool for an MBA....
And of course, completely and totally irrelevant.
Unfortunately, or fortunately depending on how you look at it, there are a lot of devs doing database design and sql (well sort of). A horrifying percentage of them quite obviously don't get either, I should know I get paid to tidy up after them.
I don't expect a dev to know 6NF (I don't), I don't expect them to be able to tune a partitioned databasde over a raid (I can't), or set up a cluster (woudln't no where to start)
I do expect them to know up to 3NF, and that you don't do select * from Table, suck everything on to a clients and then iterate through with next to find the one called Bill and set his surname to Gates.
I suppose I might be expecting too much, I mean a lot of them can't program either....
Discussion on:
Message 33 of 97
Posted by Tony Hopkinson
12th Oct 2010

































