glorified address book

[shumate62]

OK- I need to go right back to start. I'm volunteering for a charity that has
a yearly event and they need help!, --seriously they have 400 names on scraps
of papers in manila folders--. I know the bare minimum about Access but know
it's got to be a heck of a lot better to struggle through Access than allow
them to handwrite 400 addresses for one more year. (seriously, like with a
pen? yes.)
I need a glorified address book.
I need a table with name, address etc.
But the key second part that stops this from just being a generic address
book is that I need to sort them by a second set of features such as Author,
speaker, Media, invitee, because some names will be just Author, or maybe be
Author and Speaker and I need to be able to create labels based on one or
more of these features. (guy works for the media and was a speaker so he has
two features).
My ***vision*** if you bear with me, is the "Address Book table" which
allows for the form to type in the address "stuff" and then click down to a
subform? to have a simple drop down box that I can then select one or several
features.
This seems blindingly simple, is this something a simple volunteer can do?

 

[Daniel Pineault]

Yes, this can be put together rapidly, even by a novice. If you wish to do
it yourself, post your questions here (give as much detail as you can) and we
will be glad to help out.

I, like many developers here, also do not mind helping out charity groups.
If you wish use the link below to access my business e-mail and contact me
through my website and I would be more than willing to help you get up and
running.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[shumate62]

well the details that I sketched out is that for one table I need:

first name, last name, spouse name, business name, address, city, state, zip
code, phone number, email address and notes.

for the 'category' table I need:
speaker, speaker's guest, honoree, honoree's guest, media, community board,
museum, library, panelists.

so i had originally just created one table and then made the 'categories'
just yes/no fields in the one table and through queries I was able to mostly
figure out how to filter names for labels, I don't know if it's the right
format to grow into for the next five years. I'd hate to waste time making a
bad database only to have another volunteer next year 'clean up my mess'

 

[John W. Vinson]

OK- I need to go right back to start. I'm volunteering for a charity that has
a yearly event and they need help!, --seriously they have 400 names on scraps
of papers in manila folders--. I know the bare minimum about Access but know
it's got to be a heck of a lot better to struggle through Access than allow
them to handwrite 400 addresses for one more year. (seriously, like with a
pen? yes.)
I need a glorified address book.
I need a table with name, address etc.
But the key second part that stops this from just being a generic address
book is that I need to sort them by a second set of features such as Author,
speaker, Media, invitee, because some names will be just Author, or maybe be
Author and Speaker and I need to be able to create labels based on one or
more of these features. (guy works for the media and was a speaker so he has
two features).
My ***vision*** if you bear with me, is the "Address Book table" which
allows for the form to type in the address "stuff" and then click down to a
subform? to have a simple drop down box that I can then select one or several
features.
This seems blindingly simple, is this something a simple volunteer can do?

I believe that my Church Membership database would meet your needs (it
actually does a bit more than that, but it will at least let you create a list
of any number of people, any number of "lists" (each person can belong to any
number of lists), generate mailing labels or emails, and other kinds of
reports. There's nothing "churchy" about the database, and it's free.

If you're interested in a copy, send me an email to jvinson <at> wysard of
info <dot> com; edit out the blanks and make the obvious punctuation changes.