Want to design a simple database form interface that users can help manage information

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.
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS LiasonCommented:
Doing this as a tablet based app will be a big step away from the Access world, so this is a HUGE question...

What are you looking for specifically?

First and foremost, the design if the tables, relationships and keys must be iron-clad.
What hardware do you have currently available?
Is there an existing database which would receive the data?
How many animals are you dealing with?
You might want to contact these folks, and see whether their animal shelter software is close to what you need:

The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Oddly enough , I am working with them somewhat, based on another question.
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Author Commented:
Boag: What are you looking for specifically?
A way to manage all the different aspects of a shelter.
Assigning tasks cleaning feeding , Schedules of volunteers, Schedules of tasks shots vacines
Keeping track of animals who has what need or what ailment etc.

I have a series of forms I would like to see go into the tablet to see if it would make things work more efficiently. Instead of paper to database just database to database. Print and report on results.
Things like cost analysis of pet. We take in things that need a more efficient look and closer analysis since so much depends on the cost of what can be done for the animals vs what resources we have. I can build a DB Forms and reports in Access SQL server or Crystal Reports.

Jerryb30  Hardware.....no tablets 3 pcs a server networked. Software would be Access or SQL Server Excel are our tools unless using stuff from Google or open source is available.
J.R. SitmanIT DirectorCommented:
Contact me and I'll send you a Paw Trax Demo.


J.R. Sitman
IT Director
Jeffrey CoachmanMIS LiasonCommented:
Then see the other experts posts.

See if something does not already exist that will do this.

This will be a huge undertaking, ...much more than can be covered in a Q&A format like this...


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Author Commented:
I see you are correct this would be a huge undertaking.
Thanks for the input.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.