I need an Access data base that help me keep track of volunteers/cars and phones
At the moment all the information is stored in an excel spread sheet. Take a look at the attachment and you'll see what i mean. I've also included an example of a contract that i get sent which supplies me with the info to enter into the spreadsheet and the volunteer all the info needed to carry out their task.
I need a program/Database the can help me keep track of volunteer + tasks.
The current process works like this: A worker wants a task to be carried out by a volunteer so they type out a [url removed, login to view] and E-mail it to me.
I then allocate a the task to volunteer and print out a copy of the task for the volunteer.
I then add the task + volunteer info into an excel spread sheet for reporting purposes.
I'd like it to happen like this..
Workers access a database/program via the intra net and enter task details. (ie. time/ date, job will take, who to pick up , age of people ,etc etc)
The program/Database alerts me to the fact that a worker has entered a task and show details.
I need to be able to look back and see what volunteer did which task and how long it took + print out reports
pleases note:Before I choose a programmer I want to be clear you understand what I need.
Please take a look at the example contract /task form that i uploaded.
It's what a worker submits to me. I then try to find a volunteer to do the task. If i do find a voluteer i than add their name to the contract and print it out. (ineed to be able to ad alogo at the top and contact details at the bottom to print out.
Sometimes the details of the task need to be changed by the worker after the contract has been submited...And I need to know.
Sometimes I need to change something on a contract and the worker needs to know.
Sometimes a volunteer agrees to do the task then rings in sick and the worker needs to know.
Sometimes the worker cancels the contract and I need to know.
Sometimes I can't find a volunteer to do the contract and the worker needs to know.
At the end of the month I need to know how many hours each volunteer worked.
How many contracts didn't get completed due to lack of volunteers and how many hrs those tasks would taken to do.
I need to be able to see what contracts have been carried out by what volunteers and on what day of the week.
I need to be able to enter volunteer availability (days of week and time of day) and have this match to future contracts.