Software like this must assume a reasonable level of competence on the part of the user. There is a limit to how simple it can be and still remain useful.
Also, if it is made
too simple, it is likely that the user will become frustrated with its lack of features once it is mastered.
It is therefore difficult to arrange a "one size fits all" system on the one hand, and one that "expands" as the user becomes familiar with it (and digs digger into it) on the other; so many design compromises must be made.
A balance needs to be struck between the "data entry clerk" at one end, and the "advanced user" at the other. This is where features can be presented (or not) according to "level of access".
Those at the higher levels of access should be able to configure the system and set up things to their own liking, as far as is possible without undue levels of (coding) complication.
A "bespoke" system (one designed and constructed specifically to suit local needs) is the best option if you want absolute perfection! But that takes a lot of time (and money) to implement and develop.
There are a few commercially available systems tailored to biomed work. All have their own sets of features, good and bad points. Everyone has their favourites. But all cost lots of money.
Unfortunately (and despite what the sales people may have you believe), some lack a few of the features that you may have wished for, but you may not discover this until it's too late! Some may not include parts stock control, for example.
You really need to sit down and ask yourself exactly what it is you're trying (hoping) to do. Make a list, and take it from there.
Otherwise, it may be best to stick with generic applications that are commonly available (such as Excel, for example). Or, if you're really keen, have a go yourself (using Access, or whatever). That way you can incorporate whatever features you desire! And also add new features if (and when) need be. After all, the "best" has to be the one that does all that you want it to do.
These days it can be safely assumed that all biomed techs are "computer literate" to various degrees, but (as with any system) you have to put in a bit of effort in order to get the most out of it. Like referring to the Help file, for example. Despite what some folk may like to believe, most things that are worthwhile are not actually "quick and easy" (or "point and click"); but time spent learning offers up its rewards.
Lastly, remember that whichever system you adopt, there will always be a fair amount of work involved in getting your data entered into the (new) database in the first place. The amount of effort required will depend as well on the quality of your existing data, and what format it is in (if already on computer).
