Creating Database Answered
To be honest, I don't know if my inquiry fits within this forum, but I really had no idea where to post what I need.
I am currently interning at a non-profit nature center which relies heavily on volunteers. As art of my internship, my supervisor would like several databases created. I don't know what program would work best for my needs and I was hoping somebody could give me a few ideas for what I need to create.
Here is what she would like:
1. A volunteer database that is searchable by the training and expertise each volunteer has received. Let's say for instance, that we are having an insect program and only those who have been trained for the program can volunteer. I need to be able to search a keyword or from a drop down menu individuals who have received this training. A spreadsheet would suffice, but some individuals have so many training sessions that it would get a bit long. We also have over a hundred volunteers.
2. A teacher database that shows the grades and classes each teacher in our system teaches. We have school groups come out, and if their is a fourth grade program, there is no reason to contact every other grade teacher.
3. This is the really challenging one. We have rental programs, and all users must complete rental information which includes name, contact information, type of rental, and emergency contact. I would like to go paperless with this and if somebody rents more than once they have to fill in the information every time. I would like to be able to search their name and have all of their information come up, then input their rental type and time, which would give me a list of how many rentals we have had per day/week/year and how much money we have made.
As I said, I could just make a spreadsheet for the first two but I would like something a bit more sophisticated. If I was not clear about anything, please let me know.