I know there is a lot out there about this topic, but that is part of the problem. It's overwhelming and either too simple or complex.
I run a local chapter of a national non profit. I am attempting to create a volunteer and donor prospecting database. I currently have one in excel, but I can see the advantage of using Access. What I envision crossing over from excel is that I would have one "master" spreadsheet that holds the name of every prospect in the database. I would then have sub tables for address and contact information, financial contribution history, and lists detailing community involvement such as a table of the local Rotary or Kiwanis club membership. The point being that you build a volunteer profile for each person on the master list. They wont be involved with every sub table organization, etc. but the sub tables all work to build a case for those on the master list.
Here is where I get lost. In excel I had one master spreadsheet with additional spreadsheets feeding it information through formulas. The main one had names, phone numbers, etc, but also had additional columns that were populated from additional spreadsheets using a look up function. This way I could have a separate spreadsheet for each community organization, financial campaign contribution, service club, etc. I found it made it easier to alter and read the information. I want to do the same basic thing in Access.
How do I set up my database so I can upload an excel file that has name, organization, job title, etc. and have it feed into my primary table? If I have 6,000 names on my list (which I do) I don't want to have to manually type in fk for each row in a sub table every time I upload a new list. Plus, how will I know they are not already on the primary table?
I hope this makes sense. If not just ask and I will try to clarify. Thanks for any and all help in advance.