Access for dummies

[JessicafromLV]

Ive never created a database before in access, most of my informatio
was either kept in excel or contacts in outlook. Im sure Access i
pretty easy once you understand the basics and what you are trying t
accomplish. There are several tutorials out there but nothing fo
DUMMIES like myself.

Let me tell you what my goal is and hopefully someone can shine som
light. We have several kids in our church, we currently have to writ
there names on a piece of paper and give the parents a number so tha
they can pick up there kids. So my goal is to create a database (of som
sort) with the childs name, parents name, a specifice comp generate
number and a phone number, date of birth. once the database is complet
then when the child arrives to the youth group parent can sign them i
by entering there given number or by name and it will pull the name up
mark them as checked in and print 2 labels ...one for the child th
other for the parent to hand in when picking the child up. At the end o
the service the teacher can check the student out based on the label th
parent turned in. So can anyone give me some ideas? this is trul
something that i would like to get done. My only concern would be i
they were a new student at that point how will i get them in the system

 

[Rob Schneider]

Ive never created a database before in access, most of my information
was either kept in excel or contacts in outlook. Im sure Access is
pretty easy once you understand the basics and what you are trying to
accomplish. There are several tutorials out there but nothing for
DUMMIES like myself.

Let me tell you what my goal is and hopefully someone can shine some
light. We have several kids in our church, we currently have to write
there names on a piece of paper and give the parents a number so that
they can pick up there kids. So my goal is to create a database (of some
sort) with the childs name, parents name, a specifice comp generated
number and a phone number, date of birth. once the database is complete
then when the child arrives to the youth group parent can sign them in
by entering there given number or by name and it will pull the name up,
mark them as checked in and print 2 labels ...one for the child the
other for the parent to hand in when picking the child up. At the end of
the service the teacher can check the student out based on the label the
parent turned in. So can anyone give me some ideas? this is truly
something that i would like to get done. My only concern would be if
they were a new student at that point how will i get them in the system.

I applaude your use of Access for data instead of relying on psuedo
databases. However, first thing you need to do is repost this in the
Microsft Access newsgroup. This one is about Microsoft Project. Perhaps
the second step would be to make an announcement in the church
newsletter that you are looking for assistance to make a database (in
Access). Surely a member has that skill?

 

[Crook]

Jessica,

There is software available that will perform this exact function for you.
Our church uses some, although I don't know the name. The package our
church uses even prints bar code cards for parents to scan themselves to
generate the required labels for their children and themselves.

I'll bet you already knew that, and generated your requirements based on it
(grin!). Anyhow, a google query turned up lots of software, some of it
moderately priced or free.

HTH,
Crook