Link to home
Start Free TrialLog in
Avatar of RUA Volunteer2?
RUA Volunteer2?Flag for United States of America

asked on

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.
SOLUTION
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Oddly enough , I am working with them somewhat, based on another question.
Avatar of RUA Volunteer2?

ASKER

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.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I see you are correct this would be a huge undertaking.
Thanks for the input.