Phase 1 complete
For the past two months or so I've been working on my first ever MS Access database. It's not especially complex - for someone who's created databases before it would probably be very easy - it simply keeps a record of all our current jobs, and produces multiple reports detailing the status of the jobs in different ways for different staff.
For me it was a huge challenge. There's been countless times when I've come up against a brick wall, unable to come up with the code that would make it do what I wanted it to do. In those situations I found the best thing to do was to think intensively about the different possibilities ...then let go and sleep on it. I can recall several occasions whereby when I went back into the work the following day the answer was there, hanging in the air, waiting for me - PING! and it worked!
The past couple of weeks have been a little frustrating at times as other work has started to pile up, and I've been unable to put any time aside for making final tweaks to the database to get it from a sort-of-working state to a fully functional bugless thing worthy of putting real data into. Thus the overtime. It's my own choosing - I could not do any overtime and continue along the gradual progression route, but it's reached the stage now where I really want to make the switch.
For one thing, as of this week I'm responsible for managing certain aspects of jobs in progress. Thus, there's a bit of self-imposed pressure to get this up and running asap so I don't have to use the existing analogue recording techniques (paper and whiteboard). The switch has also necessitated the reorganising and renaming of a complex web of files too, something I started last week but was only able to finish tonight after a few hours on the job. ooooh you should see my hierarchical archives now, boy are they sexy!
So yes, tonight I feel good. Following a fair bit of testing I started using the database - and it works perfectly! I'll continue to extend it over the next few months in order that it can help simplify tasks for more people in the office. The hope is that within a few months or so everyone is benefiting from it, being able to immediately obtain whatever data they need to get on with their jobs.
And now it's time for bed.