Training database. Looking for hints.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hendrik - 09 Mar 2005 20:10 GMT

I have created an Access DataBase concerning Staff Training. It's aim
is to know whether staff has undertook the minimum courses that they
are asked to do in year 1 of employment, year 2, etc ...

Templates (=training profiles) have been created on Excel with the
training expectations.

I have three tables in Access : STAFF [ID, Surname, Name, Department,
TrainingProfile] - TOOK [AutoNum, ID, Code, Title, Date] - COURSE
[Code, Title, Duration].

I now wish to produce a report in relation with my templates, with on
the left the minimum expected, and on the right the courses
effectively attended by the employees.

My problem is that I don't know how to link the information of the
tables to my reports.

Could someone suggest me some hints ?

Reply to this Message

pietlinden@hotmail.com - 10 Mar 2005 03:37 GMT

If your only problem is linking, then just base your report on a query.
You *might* want an outer join between requirements and what the
person has actually taken... and then throw it all into a summary
section (by employee, maybe) so you can get totals. Depends on how
much detail you want. But I would start by building a query that
returns all the fields you want. Then filter in Open event of the
report. Just a lot more flexible that way.

Reply to this Message

Hendrik - 11 Mar 2005 20:57 GMT

Thanks. I see that I am still miles away from the objective. I will
re-start again.

Hendrik

Reply to this Message