Activity Database Programming

[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 be
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
to
select their desired preferences. Each activity has a limited numbe
of
students who can take part in the activity. How do I save th
preferences
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 all

Sarah
I have MSN for those willing to help. :idea: :

 

[tina]

you posted an identical message in microsoft.pulic.access.tablesdbdesign at
9:40 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