M
Melinda
I am trying to make a form/database for weekend volunteers. I need to be able
to input their Ham Radio Call Sign, Last Name, First Name, Phone number and
E-mail address. None of this info would change except maybe their phone
number.
When they show up the first time, all of this info would be entered and
stored in a table called volunteers. Every time they show up after that, only
their call sign (which is different for each person) would be used to
log/sign them in. On another line, in another table, would be a date field
which could be automatically filled in with the day's date - or, if need be,
the date could be entered manually, along with time in, time out and
area/zone worked. Then, a third table called Activity which would used if
anything happens during the "shift" that needs to be reported or discussed
later.
I can't figure out how to set up the tables so that the info from the date,
time in, time out, area/zone and activity are all associated with a
particular person. I also am not sure about how to set up the report pages,
but I figure one thing at a time for my poor brain to wrap itself around.![Smile :) :)](/styles/default/custom/smilies/smile.gif)
Any and all help would be greatly appreciated - especially the "dummies"
version.
Thanks in advance,
Melinda
ps - I've read all the tutorials and did the "training" for Access 2003 here
on Microsoft, but this is the first time I've ever tried to make anything
with Access and just can't seem to make my brain comprehend how to do it
correctly. Again, thanks. Mickey
to input their Ham Radio Call Sign, Last Name, First Name, Phone number and
E-mail address. None of this info would change except maybe their phone
number.
When they show up the first time, all of this info would be entered and
stored in a table called volunteers. Every time they show up after that, only
their call sign (which is different for each person) would be used to
log/sign them in. On another line, in another table, would be a date field
which could be automatically filled in with the day's date - or, if need be,
the date could be entered manually, along with time in, time out and
area/zone worked. Then, a third table called Activity which would used if
anything happens during the "shift" that needs to be reported or discussed
later.
I can't figure out how to set up the tables so that the info from the date,
time in, time out, area/zone and activity are all associated with a
particular person. I also am not sure about how to set up the report pages,
but I figure one thing at a time for my poor brain to wrap itself around.
![Smile :) :)](/styles/default/custom/smilies/smile.gif)
Any and all help would be greatly appreciated - especially the "dummies"
version.
Thanks in advance,
Melinda
ps - I've read all the tutorials and did the "training" for Access 2003 here
on Microsoft, but this is the first time I've ever tried to make anything
with Access and just can't seem to make my brain comprehend how to do it
correctly. Again, thanks. Mickey