It's good to see someone making a real effort. Quite often we see posts by those who believe that Access is just an extension to Excel (wrong).
I was building a draft data model while you were posting - it seems.
Take a look at the model and see if it makes sense to you.
What's missing?
Questions?