Name: database.PNG Views: 44 Size: 13.0 KB ID: 45885" class="thumbnail" style="float:CONFIG" />
Hello, my first post to this forum. I am relatively new to Access, despite having taught digital technology for a few years and it being something we used in one of those years.
In the picture above (hopefully!) you can see the structure of the tables I have set up, probably quite simple.
I work as a school counsellor, and since I have some knowledge of databases, I thought this would be a better way to store data than our typical Excel spreadsheet I've seen used at other schools. One thing that system couldn't do was identify unique clients versus a lot of sessions (several of which might have been the same client).
My problem is that I'm not familiar enough with querying to know how to pull out the data or reports I want, even though I know all the data is there. For example, it would be nice to:
- Get all sessions broken down by year level of the students, in terms of numbers and percentages, and total
- Get same broken down by ethnicity
- Identify those clients who come frequently (more than 6 times, say)
- Get break downs of the data in terms of the reason they're coming to counselling
- Get the above over various periods of time, Term 1, Term 2, and in future, 2022 vs 2021
I know this is a broad question, but I was hoping someone could give me some examples of how to do those, and then I should be away and able to develop other queries based on those.
Thank you!!!