Microsoft Access was great for this. You could built a quick app in couple of hours and deploy in local network with a shared database.