Gday all,
I am hopelessly new to Access and I'm trying to organise a database for the management of the members in a small juniors club I am running. The database I want will be very simple but below is what I'm seeking for it to do:
- Ability to enter new junior member records and their details
- Same as above for the leaders
- Manage sessions and track attendance of the juniors and seniors for same
I have been able to accomplish the first two tasks but that about as far as my Access knowledge goes at this point. In regards to session management:
- I want a form that allows the user to enter details for a session (date and content) and have the form display all of my juniors where I can select whether they attended or not. Once saved it should make a record of who attended on that particular date
- I want to be able to repeat this process for each session as they are added - recording attendance for each junior
- The list of juniors on the session form would need to be 'update-able' (yes a new word!) as junior members are added and/or removed
- I would like to generate reports based on the attendance history of each junior, as well as the attendance of each session
I hope this makes any amount of sense to someone out here. It's hard for me to explain what I want but hopefully you can cue me and I'll be able to provide better information.
Thanks in advance!
Mick