Hey all, pretty new to Access and brand new to these forums. I'm the worship leader at my church and I'm trying to create a database to keep track of the music scheduling. So the way I'm approaching it is, I'd have a table for the worship dates/times (called "Services") which would include the Date, Day (Sunday, Wednesday, etc.), the Time (mostly AM/PM), and all the songs used for that service, whether Congregational or Special, as well as a few other details. I would also have a table of all the Songs, with a few details related to them as far as the type of song, the key it's in, what special occasion it's for etc.
My goal is to be able to look up all the songs used within a date range, as well as be able to see all the dates a particular song was used. So my question is: how do I design my tables in order to create the appropriate relationships and queries to be able to accomplish all this? [bold for readability]
I've watched a few YouTube tutorials on Access in general and specifically relationships, but I'm not quite sure how to build it all.
I'm sorry if there are tutorials out there that address. Being so new to Access and databases in general, I'm not quite even sure how to search for this kind of thing specifically. I'd super appreciate any help.