table design query - attendance (1 Viewer)

[jimmylegs]

hi,

i'd like some initial help with how best to set-up my tables for a database i need to create. if anyone could give me a synopsis of what i need to do it would be great and then i can try and piece it together.

here are the requirements;

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

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

as i said, some pointers or examples would be great as i am new to this. i pressume i need;

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

Am most stuck on the date part. the data may not be entered every week so i can't really use a date function. instead i need a combobox or something to be able to select the week.

cheers
mark

 

[The_Doc_Man]

This is a common problem handed out to students at various schools. The forum's tool bar includes a "SEARCH" function. Look for "class" and "student" keywords in titles of various articles. Many people have asked this same question. You should be able to find what you want in the search list.

 

[yabai]

cheers for the tip