Hello,
I have used MS Office products for years but never Access. I read Accessible Access 2000 by Mark Whitehorn and Bill Marklyn which was helpful to get a good idea of what Access can do. I am currently using the 2007 version.
My confusion (I realize there is a ton to learn but I have little patience with my learning curve!) is that I have a table I imported from my local county of all the registered voters. I want to build a database of only the people that are members of my party. Instead of having to retype all these names and addresses, I imported the entire spreadsheet which is a little over 52,000 records. That spreadsheet does not have phone number, email, notes, etc. that I would like to keep track of as well as dues paid, events attended, etc. The county updates these records every 6 months and I would like to be able to take their latest version and update somehow. I tried creating another table with just phone and email with a link between the voter affidavit number (PK) and a voterID number in the second table. It seems like it should be a one-to-one relationship? Maybe I am in way over my head. Any ideas? I am of the belief that it is best to try to get it right the first time vs. doing it over...
Thanks!
I have used MS Office products for years but never Access. I read Accessible Access 2000 by Mark Whitehorn and Bill Marklyn which was helpful to get a good idea of what Access can do. I am currently using the 2007 version.
My confusion (I realize there is a ton to learn but I have little patience with my learning curve!) is that I have a table I imported from my local county of all the registered voters. I want to build a database of only the people that are members of my party. Instead of having to retype all these names and addresses, I imported the entire spreadsheet which is a little over 52,000 records. That spreadsheet does not have phone number, email, notes, etc. that I would like to keep track of as well as dues paid, events attended, etc. The county updates these records every 6 months and I would like to be able to take their latest version and update somehow. I tried creating another table with just phone and email with a link between the voter affidavit number (PK) and a voterID number in the second table. It seems like it should be a one-to-one relationship? Maybe I am in way over my head. Any ideas? I am of the belief that it is best to try to get it right the first time vs. doing it over...
Thanks!
