Training Template (XP-SP2)

[dandssom]

I'm trying to develop a training database for personnel in my office. I'm finding the more I think about how to do it, the more complicated it is getting. Does any one know of a template that I could just adapt?

Thanks

[HansV]

Don't get your hopes up high. Although it is easy to find demo database illustrating all kinds of tips and tricks in Access, templates for complete applications are much rarer. There are a few that come with Access, and Microsoft has some more templates on its Office website, but none of them is about employee training.

[Jezza]

Susan

I am suffering from the same problem. The more I think about it, the more I can see where problems may arise.

I have decided to keep it simple ( The KISS principal) and work on from there.

So far, I have gone for the simple version of having 5 tables:

tblTutors - List of Tutors
tblCourse - Course Description
tblBookings - Bookings Input
tblDate - Date of Courses (related to tblCourse)
tblConfirmed - Confirmed Bookings of Students

My original plan was to have prospective students being able to send there booking into tblbookings(I have this running as an asp page on the intranet). The Administrator could then view the back end database at the end of the day and with a little magic in VBA transfer the details in tblBookings to tblConfirmed where an email was to be sent. How complicated are you looking to go?

Good luck

Jerry

[SteveH]

Database Answers provides lots of data models which you could use as a starting point.

I would start with:

tblStudents
tblCourses
tblBookings
tblTutors


tblStudents to tblBookings is 1 to many
tblCourses to tblBookings is 1 to many
Tutors to Courses depends on the set-up there. It may be many to many in which case you will need an intermediate table say tblTeachCourse.

Date of Course is data about the Course so it lives in the Courses table.
Confirmed Booking of Student is about the booking so it lives in the Bookings table.

I've attached a handout I give my students on Normalisation which may help to clarify things.

HTH

[Jezza]

Hi Steve

Yep, exactly how I have got it, cheers.

Is your attachment, copyrighted? If not I may 'borrow' a few paragraphs to show my students.

Jerry

[SteveH]

You may borrow it but please leave the acknowledgement intact.

I did post an earlier version about 18 months ago <!post=here,185086>here<!/post> along with another document which might be of use.

Cheers

[Jezza]

Gosh, I must be getting a veteran on the Lounge <img src=/S/gramps.gif border=0 alt=gramps width=20 height=20> . I can actually remember this post as I spent quite a lot of time reading your document with interest. I thought I recognised it.

PS acknowledgement will be left intact <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

Jerry

[dandssom]

Thanks for all your suggestions - especially the document on normalisation of data! It has helped me understand relationships a bit better. I'm still a novice with access, so need all the help I can get.

Thank you!