Solo Technology What do you need done today?

21Feb/10

Custom Process Management DB

Started a project to build a custom MS Access database for one of the machineLOGIC clients. They need a simple way to track tasks related to processing employees when they start or when they leave. Access was deemed the best way to build them something quickly and inexpensively.

The database design is just a handful of "core" tables in 3NF and half a dozen lists tables used in the Access forms for combo boxes and such. There are main application forms along with lookup date management forms where they can mark items active/inactive and control the display order. While Access isn't always the best choice, for an app like this with just a couple of users it is a great fit.

As I write this (early May) we're just about done wrapping up the reports part of the project which is always the most iterative or interactive (imho).