M
Max
Hi, again all you VERY helpful MVP's! I have another question, but first
some background.
As you may know, I work for a non-profit youth organization. We have our
students records in an Access database that was here when I came on the job a
while back. I don't know much about relational databases and the bosses have
bought me the Absolute Beginner's Guide to Access (which helped me not be so
fearful of Access) and sent me on one training seminar. My only other
computer background is in word-processing, as a secretary (and that was quite
a few years ago). So most of my information comes from what I can find on
the internet combined with my little book, tsk. So I appreciate all that I
have and will learn from this newsgroup and it's resources.
Now the question. We are getting new members from our website. However,
there is a chance that some of the kids who reply to our website are already
in our database (there are at least two that I definitely know of). My boss
wants us to have the most up-to-date database of qualifying youth in our
city, by starting a new database of just web-site respondents. IMO, I should
just create a new field, name it something like "webhit", and add the new
kids to the d/b, and give some data for that field for the kids who replied
to the website but are already in our system (like maybe the website hit's
transaction number, or simply a yes/no option) to be able to tell which
records are a result of the website's form.
What is the best way to do this (and the simplest)? I do NOT know anything
about programming, other than how to use the design wizards in Access.
TIA.
some background.
As you may know, I work for a non-profit youth organization. We have our
students records in an Access database that was here when I came on the job a
while back. I don't know much about relational databases and the bosses have
bought me the Absolute Beginner's Guide to Access (which helped me not be so
fearful of Access) and sent me on one training seminar. My only other
computer background is in word-processing, as a secretary (and that was quite
a few years ago). So most of my information comes from what I can find on
the internet combined with my little book, tsk. So I appreciate all that I
have and will learn from this newsgroup and it's resources.
Now the question. We are getting new members from our website. However,
there is a chance that some of the kids who reply to our website are already
in our database (there are at least two that I definitely know of). My boss
wants us to have the most up-to-date database of qualifying youth in our
city, by starting a new database of just web-site respondents. IMO, I should
just create a new field, name it something like "webhit", and add the new
kids to the d/b, and give some data for that field for the kids who replied
to the website but are already in our system (like maybe the website hit's
transaction number, or simply a yes/no option) to be able to tell which
records are a result of the website's form.
What is the best way to do this (and the simplest)? I do NOT know anything
about programming, other than how to use the design wizards in Access.
TIA.