Activity Database --> Need some guidance

[blakf02]

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

Sara
I have MSN for those willing to help

 

[tina]

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

 

[Josh Nankivel via AccessMonster.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.

 

[tina]

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