I need to add information of clients who have visited the office, which department, who they were referred by, who they were referred to etc. I have linked a screenshot of what I have currently made in Excel. Most of the columns have drop down menus so that it is easy to choose options. I basically need help with pulling information out. I want my database to do the following:
-Total number of clients that the office has seen as a whole
-Total number of individual students each department in the office has seen
-The ability to distinguish between clients who have attended an event and those who have met one on one with a staff person
-Total number of appointments at any given time in the office as a whole or individual departments
-Total number of appointments for each individual staff member
-Total number of clients referred to a particular department and the % that actually met with that department
-Data about a particular client (I have a meeting with John...oh look he has already met with someone else about this)
-Demographics (how many first - year clients have visited the office)
-Numbers that had meetings for a specific reason.
Is there any particular database application I should use that will allow me to do all this (like Access, though I have never used it!) ? Or can I do this in excel? Help!