Donation Tracking on Weekly Basis

Hello Experts,

I need to track donations in Church Organization on a weekly basis.  I also am sending quartely statements to let them know of where they are at in tithing.  I have made the easy table of Members which includes Fname,Lname,Date Joined, and MID (Member ID) as a unique identifer.  I am stumped of what my other entities are for creating correct tables that will be tied with Member.  I know that Many members will be making many donations, some will never make weekly donation but do so monthly (which in essense will be a weekly donation once).
I thought of making a table named Yearly_Donation and there being with in that table week 1, week 2....so forth for a total of 52, then having the MID and Year as a combined primary key within that table.  Is this the correct route to go?  I just would not think that a 2 table database would suffice for this type of record keeping.  If I went with the 52 week table would it be difficult when it came time to generate quartely reports?  What I would love to do is have something like Jan ,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec tables with week1,week2,week3,week4,week5 within each monthly table and have the year and MID unique within those monthly tables.  Would that be a complete mess?  Something I left out was that there are 2 seperate donations, one is General and the other would be Designated (to a specific fund).  Gahhhh....my head is spinning.Start Free Trial