Results 1 to 8 of 8
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Fishburn, Durham, England
    Posts
    125
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Training Template (XP-SP2)

    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

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Training Template (XP-SP2)

    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.

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Training Template (XP-SP2)

    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
    Jerry

  4. #4
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Training Template (XP-SP2)

    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
    Attached Files Attached Files
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

  5. #5
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Training Template (XP-SP2)

    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
    Jerry

  6. #6
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Training Template (XP-SP2)

    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
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

  7. #7
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Training Template (XP-SP2)

    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
    Jerry

  8. #8
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Fishburn, Durham, England
    Posts
    125
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Training Template (XP-SP2)

    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!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •