Activity Database --> Need some guidance

Hello, to anyone who is willing to help, I am in desperate need of a
little guidance with an issue I am facing.
I was hoping that I could be
pointed in the right direction for help on a Microsoft Access
Database.
The challenge is to create a list of Activities where a user signs in
to
select their desired preferences. Each activity has a limited number
of
students who can take part in the activity. How do I save the
preferences
for each student and then sort of out the ones which are over the
maximum number of students.
Once a student has submitted their preferences, the database is
scanned and if there are still some vacancies in this activity the
student is notified and their name is removed from a student list, if
it is unsuccessful they are then asked to select from a list of
available activities. at the end of selection process there will
exista list on which will lie the students who have yet to submit a
preference.
It is a major task and I need some major help!!
thanks to all

Sarah
I have MSN for those willing to help.

you posted an identical message in microsoft.pulic.access.modulesdaovba at
9:41 AM this day. *please don't multi-post.* it wastes everybody's time, and
server resources. if you feel you really need to post to more than one
group, then crosspost - that is, put both newsgroup addresses in the address
line of one post, separated by a colon.

nobody can tell you how to build an entire database in a newsgroup post. if
you want specific help, you need to ask a specific question. if you're not
sure where to begin in building your db, the answer is: begin by defining,
relating, and creating all your tables. when that's done, move on to
queries, forms, and reports. hint: the first step is by far the most
important step. do it right, and the rest of the db is much, much, much
easier to build.

suggest you see the list of links at
http://www.ltcomputerdesigns.com/JCReferences.html
starting with the "Database Design 101" and "Starting Out" links.

hth

"blakf02" wrote in message
...
Hello, to anyone who is willing to help, I am in desperate need of a
little guidance with an issue I am facing.
I was hoping that I could be
pointed in the right direction for help on a Microsoft Access
Database.
The challenge is to create a list of Activities where a user signs in
to
select their desired preferences. Each activity has a limited number
of
students who can take part in the activity. How do I save the
preferences
for each student and then sort of out the ones which are over the
maximum number of students.
Once a student has submitted their preferences, the database is
scanned and if there are still some vacancies in this activity the
student is notified and their name is removed from a student list, if
it is unsuccessful they are then asked to select from a list of
available activities. at the end of selection process there will
exista list on which will lie the students who have yet to submit a
preference.
It is a major task and I need some major help!!
thanks to all

Sarah
I have MSN for those willing to help.

Some of your message is a bit truncated and I can't understand all of it.
But it sounds like you want the following:

tblActivities - strActivity, intMaxStudents
tblStudentsActivities - strLName, strFName, strActivity
tblStudents - whatever student info you need

When they select an activity, base the rowsource for a combo box off of a
query where you do a count for each activity in the tblStudentsActivities
table and compare that to intMaxStudents. So the query only shows
activities from tblActivities where intMaxStudents Count
(tblStudentsActivities.strLName)....you get the idea. That way, after the
max number is reached for an activity it won't be an option to choose
anymore (make sure the limit to list property is set to yes)

You should be able to just do an unmatched query between tblStudents and
tblStudentsActivities to report who didn't make any selections yet.

--
Message posted via http://www.accessmonster.com

good suggestions, Josh.
one note: under data normalization rules the student's first and last name
fields would go in tblStudents, because those data elements describe a
student. tblStudents should have a primary key field, which would be used as
a foreign key in tblStudentActivities, to link each record to a specific
student record.

hth


"Josh Nankivel via AccessMonster.com" wrote in
message news:1129aff587824b86b7095b75e60d2a6d@AccessMonste r.com...
Some of your message is a bit truncated and I can't understand all of it.
But it sounds like you want the following:

tblActivities - strActivity, intMaxStudents
tblStudentsActivities - strLName, strFName, strActivity
tblStudents - whatever student info you need

When they select an activity, base the rowsource for a combo box off of a
query where you do a count for each activity in the tblStudentsActivities
table and compare that to intMaxStudents. So the query only shows
activities from tblActivities where intMaxStudents Count
(tblStudentsActivities.strLName)....you get the idea. That way, after the
max number is reached for an activity it won't be an option to choose
anymore (make sure the limit to list property is set to yes)

You should be able to just do an unmatched query between tblStudents and
tblStudentsActivities to report who didn't make any selections yet.

--
Message posted via http://www.accessmonster.com