Results 1 to 2 of 2
  1. #1
    spqr is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    15

    Student warning system

    Hi,



    I want to design a system whereby I have stored in the database records of my students. I want to be able to find a student easily and then assign a warning against his/her name based on behaviour and also put a date/time stamp against that. The warning system can go up in one session.

    So for example, studentA has misbehaved, they receive warning1 on 16th March 2010 at 0915. They continue to misbehave, escalate to warning2 16th March 2010 at 0930 and so on until warning 5.

    I then want to be able to produce easy reports. The whole system should be really easy to use and quick to input. What tables do people suggest for this. I will use a switchboard and queries obviously to pull the necessary data, just unsure about logging it all really.

    Thanks,

    sqpr

  2. #2
    ConneXionLost's Avatar
    ConneXionLost is offline Simulacrum
    Windows XP Access 2003
    Join Date
    Jan 2010
    Location
    Victoria, Canada
    Posts
    291
    Hi spqr,

    All you should need is two tables (plus one lookup table):

    tblStudent
    StudentID (PK)
    ForeName
    SurName

    tblIncident
    IncidentID (PK)
    StudentID (FK)
    WarningType
    Comment
    DateTimeStamp

    tlkpWarningType
    WarningType

    Cheers,

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

Similar Threads

  1. How to create warning notice
    By bluepowa in forum Programming
    Replies: 3
    Last Post: 09-29-2009, 03:15 AM
  2. Create student teams via query?
    By jmccullough in forum Programming
    Replies: 0
    Last Post: 08-19-2009, 08:21 AM
  3. Trying to create Student fixtures database, need help!!
    By jmccullough in forum Programming
    Replies: 0
    Last Post: 08-10-2009, 01:56 PM
  4. Records deleted with NO warning message.
    By evanscamman in forum Access
    Replies: 2
    Last Post: 12-14-2007, 11:18 PM
  5. Security Warning
    By mojo53777 in forum Security
    Replies: 0
    Last Post: 11-16-2007, 06:23 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