Education Database Design

[Bruce Wayne]

I am trying to set up a database to track which employees have attended
which training sessions. I have a table for employees, and another table
listing each training session. My problem now is how do I link the two? I
tried creating a query that links the 2 tables, but it just listed every
employee as having attended every training session. Is there a simple way to
link the two tables, so that I can get a list of who attended which session?

Thanks!

 

[Rick B]

You need a third table. You have to add a record including the employee
number and the class number (and I'd also include the date and maybe a
score).

 

[Guest]

hi Bruce Wayne,

Tables are linked by defining "relationships" between tables. Once the
relationship is defined and matching date is available you can use the
queries to get the linked data. Defining relationships enables you to refer
quickly from one table to another table's data.

Given your system, it would be possible for each employee to have attended
multiple training sessions and each training session would have been
participated by multiple employees.

This creates a many-to-many relationship and is resolved by creating a
junction table.

Following is a link to the microsoft site where you can learn more about
table relationships and linking records from joined tables.

http://office.microsoft.com/training/Training.aspx?AssetID=RP061827081033

Regards,

 

[Steve Schapel]

To add to Rick's comment, maybe this article will be interesting...
http://accesstips.datamanagementsolutions.biz/many.htm