Hello,

I am very new to access and yet I have been asked to "develop" a small
program with it that has several functionalities.
I 'm going to describe the situation here, maybe someone can launch me by
telling what to do, in which order and how ? Thanks in advance.

I 'm working in a school environment where students get "detention" if they
do something wrong. There are 3 different penalties, depending on the
severity of their actions.
I need to write a program now, which keeps track of these penalties per
student.
Eg. if a student does something wrong, I need somekind of userfriendly
"tool" in which the teacher can create the record for that student,
including the penalty he/she gets, the date, hours of the penalty and
whether it has been executed or not. Because many of these scheduled
penalties get postponed for different reasons.
If that happens (postpone), I need to keep track of that as well and
reschule it, again with the possibility to 1) set the executed parameter to
"true" or 2) reschedule it.

Of course I need to be able to generate reports such as: total overview of
all penalties for all students, penalties schedled a certain month, whether
or not a signed letter from the parents (being notified what is happening in
school) has been received etc... (a number of other things as well, but I
will already be glad if I get this rolling already).

Can anybody help me getting started with this ? Or perhaps has a similar
program developed of which you can send me the source as well ? Or knows of
a freeware that had similar functionalities ???

Any help is greatly appreciated.

Rgds,
Leen.

Hi:
The first thing to do is design the tables.
You will need at least 4.
A student table. This would need at least the students name and and
ID number if he has one.
A teacher table. The same idea as the student table
A penalty type table which at the moment has 3 entries - The 3 clases
of penalty.
And finaly the Penalty Table.
This record has the student id, Teacher id, date of infraction, type
of penalty, date of penalty, penalty completed (yes/mo field defaults
to no).

The main form wwould have 2 drop down boxes - One for student and pone
for teacher.
The subform whoul be based on a query that would list the outstanding
penaltyies for the student.
In the subform you could mark a penalty done or change the date.
There would be a button to add a penalty which would have a drop down
box with penalty type and fields for date of infraction and date due.

This is the basic outline.

Think about it give it atry. There is lots of stuff on the net as to
how to create forms and subforms.

Good luck
Ira Solomon



On Tue, 25 Oct 2005 20:47:10 +0200, "Leen Wouters"
<leenwouters (AT) skynet (DOT) be> wrote: