Training Report

[Amer]

I have a training database with four tables:

1. Trainees
2. Training Programs
3. Tests
4. Attendance

I need to create a report that summarizes both attendance rate and test
results for trainees.

The report should look something like:

TraineeID TrainingID NoOfAbsentDays NoOfPresentDays
NoOfTrainingDays AverageAttendanceRate TestID TestResult


Of course, all the above headings should be in one line.

I need to learn how to create such a report taking into account that for the
attendance table, it has the following structure:

- TraineeID
- TrainingID
- Date
- Status (combo box listing: Present; Absent)

Thanks for the help.

 

[Fred]

Hell Amer,

Despite you having made a good start at describing your tables / structure,
you really haven't done that enought for someone to give you a solid answer.
Probably wouldn't need 100% of the following, but:

define the nature of the entity/record in each of your tables, and th
relationship between them.

For example, does a record in the attendence table constitute an instance of
attendence in a class? In a training program etc. Or is it some type of
sumary created for each.

And, when you say "summarize" in the report, do you mean list all of the
individual data in one place, or do you mean to combine the data into totals
etc.

In fact, 98% of the job is table design to store your data and support your
object5ive. The last 2% is the report design. So answering your question
might involve the 2% or might involve the 98%.


If I had to throw a few thoughts based on guesses etc. they would be:

Something like this would usually use groupings in a report rather than as
you describe which is basically an ungrouped tabular report, i.e. just
columns with headings.

 

[Amer]

Sorry for not making myself clear.

I will go through more details for the database now:

1. Trainees table: includes basic details about trainees (IDs, names,
jobs,...)
2. Training Programs table: for the details about training programs in terms
of type, targeted audience, isntructors, topic, ...
3. Tests table: for tests to be made under each one of the Training
Programs. This means there is a relation between this table and the Training
Programs table (ProgramdID field in both tables).
4. Attendance table: for entering attendance status data on daily basis for
each trainee. So there are two relations here: one between Attendance and
Trainee tables; and one netween Attendance and Training Program table (that
is AttendanceID, TraineeID and ProgramID).

As I indicated earlier, when entering the attendance status data I do the
following:
- Choose the ProgramID
- Choose the TraineeID
- Enter the session date
- Choose the status from combo box showing: Absent, Present.

Now, when entering these data I will get a long list showing something like
this:

ProgramID TraineeID Date Status
ELT 4167 3/26/09 Present
ELT 3125 3/26/09 Absent
ALT 4167 2/13/09 Present
....

The report I am looking for should count the number of "Present" days and
also count the number of "Absent" days for each trainee in a specific
training program and claculate the average attendance rate based on the total
number of sessions.

By the word "summary" I meant having a report like:

-TraineeID: 4167
ProgramID: ELT Absent Days: 0 Present Days: 1 Attendance Rate:
100%
ProgramID: ALT Absent Days: 0 Present Days: 1 Attendance Rate:
100%

-TraineeID: 3125
ProgramID: ELT Absent Days: 1 Present Days: 0 Attendance Rate: 0%

....

I hope these information would be good enough to you.

Thanks for whatever help you give to me.