Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2006
    Posts
    2

    Unanswered: attendance database design help

    hi,

    i have little access skills and have been asked to put together a db to monitor attendance at work. i would really appreciate some tips on table design and forms.

    here are the specific requirements of the db;

    - one student can attend many different courses.
    - each course runs for 10 weeks.

    i'd like to be able to have forms to;

    - add a student.
    - assign classes to a student.
    - record absence via a combo box for each student for each week
    - the data may be entered in batches so I was thinking a combobox would be better than the date function.

    i'd also like to have a report mechanism that can record if a student is absent for 3 or more classes.

    i did find a db from somewhere and have changed bits of it but the enrolment table confuses me. i can't see how to adapt it to assign students - this seems to be done by vbscript on the new register button. is it possible to adapt this to my requirements or should i start again with the structure below?

    a table for students
    studentid
    firstname
    lastname

    a table for the courses
    courseid
    coursename

    a table for attendance
    attendanceid
    courseid
    studentid
    present/absent (combobox)
    week

    any advice would be great!

    cheers
    mark
    Attached Files Attached Files

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Advice? Try and disguise your homework/project assignment better ... Otherwise, try searching this forum for the previous students who've posted this same damn question in the past over and over again ...
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Jun 2006
    Posts
    2
    um, thanks. this isn't a school project. like i said, i've been asked to do it for work and have not used access a great deal.

    i did do a search on this and there is some stuff there. some of it is relevant and some is not.

    i'll try to make sense of it.

    thanks

  4. #4
    Join Date
    Apr 2006
    Location
    Huddersfield, UK
    Posts
    154
    i spotted something that may be of use on databasedev.co.uk but to generally create the database you are after it is more or less straigt forward.

    You have the 3 components of your database, Students, courses and attendacnes.

    Your attendances needs to be strucutred well in order to manage the attendance over the 10 week period, i'd have the following fields;

    Course ID
    Student ID
    week 1 (Yes/No/combo)
    Week 2 (Yes/no/combo)
    to Week 10 (yes/no/combo)

    then use this as a sub-table to courses... you can use a sub form and magae attendances for 10 weeks for each course.

    Hope this helps,

    If you need more advice let me know

    Dan
    sometimes simple is best.... and i'm just a simple fellow.

  5. #5
    Join Date
    Apr 2006
    Location
    Huddersfield, UK
    Posts
    154
    Also,

    Doing it this way you'll be able to see what student has attended what courses, etc.

    You could go one step further and go down the route of,

    Master table Courses
    > Sub Table Class Run
    > Sub-Sub table Attandance per class.

    Courses (just have course details, eg tutor, name desc etc)
    Class run (Week number (1-10) and date, possibly comments (if clas not run)
    Attendances, just to assign Students, to weeks to Course.

    Hope this helps;

    Dan
    sometimes simple is best.... and i'm just a simple fellow.

Posting Permissions

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