The most important thing to get right is the Database.
Access will be a good choice for you as it will make your life a lot easier when it comes to generating forms.
However access does not follow standard SQL protocol, for the most part it is true but little annoyances like *% are different.
Is privacy and access control of concern? I have never tried GRANT and REVOKE in access and am unsure of wether this exists. If this is of concern mySQL is probably the go and is FOSS so will be easy to implement.
I would have a personel table where all personel are recorded with a pk with only name address birthdate etc. and other tables for staff members with fk relating to pk of personel and same for students. in each of those poplulate them with the relevent information and a NextOfKin or contact attribute as a relationto personel pk. And another table for parents associates etc.
Another table with tutoring details
table about charges queries to this table should be of GROUB BY partenNo (fk) or something so that families can easily see tehre total amount owing not pulling information 2 3 or 4 times.
I am currently writing accounting software myslef at the moment but this is nothing like what i am doing so i can't even send you relevent DDL or VIEW DML
Fedora Core 10 AMD platform
University student B.IT.