Results 1 to 4 of 4
  1. #1
    jmansfield is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2014
    Posts
    1

    How to Create a Training Database

    I am not very familiar with Access, but my (small) safety company is wanting to create a kind of students database. Listing the students information along with a specific ID for each person, but then able to click on their names and have it give a report or list all of the different classes they've taken along with the date.



    What is the easiest and most straightforward way to create this kind of database? I know there is a Student template, but there's a lot of information there that I don't need (grades, medical information attendance etc. )

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    The first thing is to consider all the data that you want to be able to track.

    Things like first name, last name, class, attendance (for instance if the class is a series of 10 and the student has to be present at at least 8 of the 10 to 'pass' the class), expiration of any certifications if applicable, inactivating teachers or students, etc.

    Once you have a grip on the scope of your data tracking needs then think about how to break that apart most efficiently.

    For instance you may have one table for all your base information about people that includes a PK (primary key) the person's first, last name and all contact information, in that table you may want an indicator to show whether that person is certified to teach any of your classes as well..

    Then you'd want a table of all the classes you offer

    then you'd likely want a junction table which would show your instructor (FK, foreign key, to your person table) and the classes they are certified to teach (FK to your classes table)

    Then you'd also likely want some method to track starting dates of classes and which class is offered by which instructor, then a sub table to attach students to those classes (2 tables, 1 for the basic class information 1 for the students attending it)

    The complexity of your data design depends entirely on how much data you are trying to track.

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I'm going to suggest that you work through this tutorial. It will help you with your database design.

    And once you have done that, here are 2 additional links that may be helpful to you.

    --RogersLibrary ClassInfo Database
    --Barry Williams free data models related to students (has side links also)

    Good luck

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Not the first thread on topic. Forum search on 'training database' returns 248 threads. Of course, not all really apply.

    Here is one for a start:

    https://www.accessforums.net/forum-s...day-41193.html
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Training/Create Database
    By Kristi.owen091010 in forum Access
    Replies: 3
    Last Post: 10-29-2013, 11:16 AM
  2. Training Database - Need more help from JZWP11
    By Harley Guy in forum Access
    Replies: 1
    Last Post: 03-13-2013, 08:42 AM
  3. Training Database
    By BISCUITPUMPER in forum Access
    Replies: 11
    Last Post: 08-20-2011, 10:15 AM
  4. Create your own training quizzes
    By pkstormy in forum Access
    Replies: 0
    Last Post: 04-24-2011, 10:24 AM
  5. Full App - Create Your Own Training Quizzes
    By pkstormy in forum Sample Databases
    Replies: 0
    Last Post: 04-24-2011, 10:19 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums