Starting up Membership Access Database

[abasto]

I have worked on Access about 10 years ago and now I have forgotten many things. I have designed forms and queries with no problem but I am going through an issue with even starting tables. I have ideas on what I can put on the table but the problem is to make it clean and organized as possible.
Here is what I am trying to accomplish in this database.
I am trying to make a membership Database for Donation and Charity.

MembersTable
This would include members names, address, phone number and their personal information

ProfileTable:
Here is where I can have relationship linked with members table on each data to link with who recommended them for charity/donation and when they joined



DonationTable:
Here would be the names of members, their donation amount and their weekly donation (or atleast monthly donation) and I don't know which would be easier, to do weekly donations or monthly donation


Therefore, I would need some assistance and guidance on this if anyone and all help and advice are highly appreciated and thank you for reading this post.

[ranman256]

the donations tbl would use the key from tMembers

tDonation Table:
DonateID (autonum)
MemberID (long)
DateGiven
Amt
DonateType ($,chek,mo,paypal)

a field on the tMember table would show their donation schedule (weekly,montly,etc)

[kd2017]

Can more than one member be from the same household/address? IE husband be a member and wife another, or roommates or something? If so you might break the address out to a separate table, link them to a member with a foreign key in the member table.
I'm assuming yes for now.

Can a member have multiple profiles? Or can the profile information in this table be stored in the member table and still not be repeated?
I'm assuming no for now.

Can you describe the how donations are made? Are they always made at recurring intervals? Or can someone make one off donations? Can a single member have multiple recurring donations at different amounts set up?
I'm assuming members can choose how and when they'd like to donate.

Is the database intended to also track what is actually donated? From the description it sort of sounds to me like it is only tracking what they intend to donate.
I'm assuming were tracking actual donations made.

Based on my assumptions this is a table structure I'm imagining:


the [donations] table is where actual donations amounts are logged after they've been donated. The [recurring_donations] table is just to tell you when and how they like to donate.

[orange]

You may find some info at this link helpful in designing your database.
Good luck.