Extreme Novice In Need Of Advice

Hi,

I work in the quality control business and recently purchased a system which on first inspection seemed like the way forward, however I have since discovered that imputting the data is very slow.

I wondered if Access could be programmed to create a better database.

When a sample is tested, I would like the numberical values to change colour depending on whether it is inside or outside the specifications. (Is this possible?)

The main problem I can see is that samples of different substances will be analysed and each substance has different specifications. (Is it possible to set this up?)

I hope this question makes sense to you all

Any advice would be greatly appreciated

Thanks

Jimmy