Trying to help simplify a system for an Animal Shelter in my home town. I have been volunteering at a local animal shelter and wanted to help the kittys and pups a bit with a more efficient system vs paper and a horrible way of collecting information and trying to look at costs, trends etc. I thought I would put my skills to use in another way and build a form filled interface either through MS Access and a Tablet that users can walk around and put codes service information feeding medicines vacination schedules etc into an interface that could then spit out a report either through Access, a php web interface or some tool used in the Google FREE tools. I do not know which would be more efficient.
Here is what we need.
1. A simple way to collect data one time vs paper to computer. I was hoping for a tablet to interface the application.
2. A way to report on the data for analysis Cost evaluation vacines and euthanization schedules adoption pickup schedules
3. A way to print out the forms that are filled and stored as users walk through the shelter. It seems like it would be easier for them to interface some form fill collection tool with a tablet than a piece of paper which is later reintered again into a computer.
4. Designing a report is not a problem what tools would be best to use are.
I have looked at Tablets. I know databases like Access. I have worked with Crystal Reports most of my career. I understand MySQL and PHP a good bit. I have heard of the Google Tools out there. I jus do not know which would be the best stuff to use. Your thoughts opinions appreciated.
Your work hear for a really great cause. There are a lot of suffering animals out there.