My now ex wife works in a university. They got a student records package system put in. It took quite a bit of interface design and with a BA in Maths and a BSc in CompSci she pitched in. She even did some coding for them to ensure stuff worked properly. Why it pays to have a computer savvy person around for these things.
I used to be a biomedical researcher. I have built all manner of databases in my time. So when it came to my last science job where they were getting a desktop robot to aliquot samples on plates for analysis and sensibly wanted to barcode it I built them a relational FileMaker DB which read and printed barcode labels. The techs were taking in bags of blood and processing them down to DNA and RNA in tubes.
I used the robot myself as it was more accurate at gridding than anything else. So it gridded my real time RT-PCR plates for me. It had a nice macro type interface making routine building easy even for non specialists.