Access 2007

[Dan]

I have imported four exel spred sheets into my database as tables. People
sign up on my website for;
Stop Foreclosure, Cash Offer, Advise, Free Information. I want to have all
names that I can find/update without having to go to seperate tables/forms,
but I want to be able to send them an Emal according to the group the signed
up on my website.

 

[Jeff Boyce]

Dan

Although it is easy to import Excel data into Access, it usually isn't a
good idea ... without extra thought and work.

Access is a relational database, not a big spreadsheet. You won't get easy
use of Access' relationally-oriented features/functions if you feed it
'sheet data (as you've learned!).

You'll need to spend some time coming up to speed on "normalization" and
"relational database" design.

For instance, if you have a single table with people on it, you could add a
single field for "group" and do what you described... OOPS, NOT! If you
have a person who signs up for more than one group (you didn't tell us what
business model/constraints you are imposing), you'll need to have THREE
tables (suggestions only, you know your business better than we do):

tblPerson
PersonID
LastName
FirstName
... (other person-specific info)

tblGroup
GroupID
GroupName (one row each for your "Stop...", "Cash...", ....)
GroupDescription (?)
...

trelSignUp
SignUpID
PersonID
GroupID
SignUpDate
...

You'll have one row in trelSignUp for each valid Person/Group combination.

Good luck!

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/