Thanks for replying, I will look into Database Design Principles.
An excel spreadsheet could be enough in the mean time but a database would be better, the charity have all of their information stored in filling cabinets atm and want everything organized on the computer, it will not be just information about the volunteers.
The charity has quite a few voluntary administrators so there will probably be a few different people entering information, they would like to be able to access information quickly so that if somebody questions the charity they will be able to easily answer instead of searching through piles of information.
For example if someone asks...
How many new members do you have?
Who visited the charity this week?
What volunteers are in on a Wednesday?
They can find the information at the click of a button.
The only experience I have with PHP and MySQL came from creating a website in university with a user log in, so not much.