I am a relative newbie to creating Access databases - mostly for my own use. I don't often use VBA.
Please help! I am designing a church database.I plan to have a family table, a person table and an events table.I want to be able to report on all of the events for our church by year or by month - birthdays, anniversariesand church events - sorted by month and day. I plan to have a birthday field in the person table and add records to the events table based on the person key. I know I could also add a church record to the person table and add church events also using the person key, although that seems a little contrived.
Question 1: I don't want to store the year for birthdays and anniversaries: they will occur on the same date every year.Question 2: Where should the anniversary field go? If I put it in the family table, how do I get it into the events table, since the events table will be based on person key, not family key? If I put it in the person table, it is tied to an individual instead of a family.My church event dates will change depending on the year, so I will need to be able to select those by year.What is the best way to design my tables - especially the date fields or queries for those? Do I need separate table for church events? If so, how would I merge them.
I'm wide open for any suggestions - more tables, a make-table. Thank you so much for any help you can give me.