Hi,
I am trying to design a system where I can monitor attendance. The reason for this is that my client wants to know how many total hours students have attended per course. I have a good idea of the structure of my tables for doing this but am not sure how to run the queries. This is my idea for the structure and then my questions regarding it below:
tbl_courses
course_ID
course_name
start_date
end_date
day_of_week (multiple choice, monday, tuesday, etc.,)
start_time
end_time
There could be an easier way of doing this with number of sessions but it would be really useful to have the dates for each class.
Would it be possible to create a query that would automatically generate the dates for all of the classes using this information? Does anyone know what functions I would need to use in the query to do this?
Then my following question once I have managed to design the query, is how can I then record whether people attended? Each person has a unique ID and once they are enrolled on a course would have their ID next to the course ID in another table. I would then need a yes/no box to record whether they attended. I'm really unsure how I would do this part. Is it even possible? Because if not I may not pursue it.
Thanks for any help with this. Sorry the message is so long!
Russ
I am trying to design a system where I can monitor attendance. The reason for this is that my client wants to know how many total hours students have attended per course. I have a good idea of the structure of my tables for doing this but am not sure how to run the queries. This is my idea for the structure and then my questions regarding it below:
tbl_courses
course_ID
course_name
start_date
end_date
day_of_week (multiple choice, monday, tuesday, etc.,)
start_time
end_time
There could be an easier way of doing this with number of sessions but it would be really useful to have the dates for each class.
Would it be possible to create a query that would automatically generate the dates for all of the classes using this information? Does anyone know what functions I would need to use in the query to do this?
Then my following question once I have managed to design the query, is how can I then record whether people attended? Each person has a unique ID and once they are enrolled on a course would have their ID next to the course ID in another table. I would then need a yes/no box to record whether they attended. I'm really unsure how I would do this part. Is it even possible? Because if not I may not pursue it.
Thanks for any help with this. Sorry the message is so long!
Russ