If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Setting up a database for training
I need a database for 6 different types of training that must be taken by all
members of a purchase card program. Some training must be taken annually, some bi-annually, some 1-time only. I want to show which members have taken what training, and when they are due to take it again. I am at a loss as to how to design the tables to reflect all the dates, etc. (I realize I will probably have to use queries to show when training is due again) I would like have this all in one table, but it seems pretty difficult. Would I be better off designing a table for each type of training, then connecting them with a query? Can anyone help? Thanks. |
#2
|
|||
|
|||
All in one table is completely inadequate.
To get you started, you will need at least these tables: Trainee: one record for each person Training: one record for each type of training Course: one record for each time a training course is offerred. Enrolment: one record for each person enrolled in a course. If you want to track who attended each lecture for the course, and whether they completed the assessments and graduated from the course, you will need more tables. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Jan Buckley" wrote in message ... I need a database for 6 different types of training that must be taken by all members of a purchase card program. Some training must be taken annually, some bi-annually, some 1-time only. I want to show which members have taken what training, and when they are due to take it again. I am at a loss as to how to design the tables to reflect all the dates, etc. (I realize I will probably have to use queries to show when training is due again) I would like have this all in one table, but it seems pretty difficult. Would I be better off designing a table for each type of training, then connecting them with a query? Can anyone help? Thanks. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Setting up Database Colors | faulkc05 | Setting Up & Running Reports | 3 | January 26th, 2005 06:56 PM |
Access Error Message when opening database | eah | General Discussion | 3 | January 26th, 2005 10:04 AM |
Office 2003 installation problem, log file attached.... | Ryan | Setup, Installing & Configuration | 0 | January 20th, 2005 06:57 PM |
Setting up a database to record data as at a particular time | David Beamish | New Users | 3 | October 1st, 2004 09:44 PM |
Database periodically needs rebuild and locks users out | spectrum | General Discussion | 2 | July 13th, 2004 06:24 PM |