A group at my work are looking for software to help with job management in the workplace. The work environment is a laboratory and flows roughly as follows:
items come in
items may require one or more examinations (jobs)
items may be divided (such as samples taken)
some examinations may occur concurrently, some cannot
examinations require specific workers (workers are specialised)
The software would be required to track items, assist with allocating resources to the items (people and/or equipment), and scheduling. Information security is also a concern; workers performing examination A should not be able to see the results of examination B.
Suggestions include using Microsoft Sharepoint or customizing an Access Database, but I'm not familiar with the former and I think the later might be a daunting amount of work. I'm stepping out of my field quite a bit here, so any help or advice would be appreciated. There may be obvious answers I'm missing, but my Google prowess has failed me; I either get flooded or nothing.
Edit I have been guided towards some ERP products. Some of these seem to fit the bill (and far exceed it), but it seems like cracking a wallnut with a panzer tank. I'm thinking maybe a more modular or customisable ERP solution could help. Any advice?