Access 2003 Database


I spent all day yesterday completing an Assignment for my course using Access 2003, what a pain it is to use! I've used most of the other common elements of Microsoft Office on a fairly regular basis, but until I started this module I'd had no reason to try Access.

The Help files are awful, they tell you next to nothing about how to do stuff its all "Function X has failed to work because Gizmo Y is not Z, please make Y have Z before trying to use X" (ok that may be a bit of an exaggeration but you know what I mean). Generating Reports was a pain, there doesn't seem to be a way of saving the Report in the format its generated in, every time you open what appears to be a saved Report it regenerates the contents on the fly wiping anything you'd tried to save.

Trying to make anything but the simplest of Reports is a nightmare, the formatting (lines etc) are awful working out whether the data you're going to show is Left Aligned, Centered or Right Aligned isn't obvious. Text Boxes and Labels which are LINKED aren't aligned properly! It reminded me of all of the bad things about early versions of Windows and other systems like the Amiga, where simple things were hard to do, for god's sake how hard is it to draw a horizontal line?

Anyway rant over, today I've got another asignment to do, this ones in C++ and I'm using Visual C++.net 2003 version which is an example of how to do something reasonably right (it's a damn site more intuitive to use than Access).

Time to go, as I need to get cracking, its due in on Tuesday so it might be worth actually starting it.

Cheers.