Attendance Table in Database
I would imagine that I would create a table called"Attendance" and the fields would be as follows:
Attendance Date- Date/Time default value set to NOW StudentID- Linked to studentID from Demographic table AttendanceStatus- Combo with values "unexcused", "present", "excused", "suspended", "tardy" - - the default value would be unexcused and once the
student was checked into the door he/she would then be marked present or tardy depending upon arrival time.
Do I need a column for each day of the year that attendance is required? I am having trouble visualizing what the screen would look like. I imagine it looking like a list of student or combo box listing all students and once the students name was clicked orselected the time and date would be recorded and the student's attendance status would be changed from unexcused to present/tardy.
This data would then be recorded in an attendance table which could be viewed in table form or each student's record would be linked to a tabbed page on the demographics form and it would list dates absent.
Thank you for taking the time to report an issue.
What's wrong... Please write below.
After having done the initial database of the personal data, classes, teachers, ecc., now I need to relate the attendance registry to the main table.
I think this is a many-to-many relationship, because one person will have various dates of attendance, and one date will have many persons which will enter the school
I think this is a many-to-many relationship, because one person will have various dates of attendance, and one date will have many persons which will enter the school.
Charts for Daily Attendance report, Weekly Report, and monthly Report. For this how to design database in msaccess?
Currently the table was 12 weeks so there is:
12WeekProgramme.Week 1 Date
12WeekProgramme.Week 1 Attendance
12WeekProgramme.Week 2 Date
12WeekProgramme.Week 2 Attendance
And so on.
Marks are AA/UA or /
Is there a way I can export the dates/marks to a new table with only the 2 columns? Then I could use that to tally types of attendance within a specified date range
It is for one class with sixteen students.
The students are attending a course every day for nine months. Don't need a table for classes as they are just doing one subject.
I can't figure out the best way to do this database? What I really need from a query is to be able to see what their attendance is like up to the present date, as we have meetings with students and discuss their attendance history with them.
I currently have 4 tables
Class table classid
Register table registerid ,studentid,classid
student table studentid
Attendance table registerid
Iv looked on the site but can't seem to find a sample database that meets my requirements.
I was also wondering if Its better to create a new table for address and parent contacts rather than place it in the student table.
I would like a form to select the class and then the date . for example class could be maths and the date could be left blank if its todays date. also a drop down menu ender the date would be nice to load a previous date and class to edit an attendance.
Report Attendance record by Scout
Report Attendance record by Term
Report Attendance record by Date
Report Attendance record by Activity
Fileds I am looking at is
Date - Meeting date
Name - Scout Name, needs to be associated as a pull down list from scout name [scout input table]
Activity - Pull down box [Indoor Activity] [Outdoor Activity]
Just not sure how to do it
My Student Information form is used for inputing basic student information and then it's apended to the Student Information table.
I'd like to make each student's attendance viewable on the Student Information Form. If so, could you explain how this is done.
I've also read something about subforms. This is my first time working with Access 2007.
Goal: automate more.
Currently done every day:
I enter the current date, the student ID# (primary key from student table) which pulls basic demographic, and then I enter numbers 3, 2, or 1 for how many classes they attended that day. Done for each student daily.
I have the following in my db:
A Table of All students. An attendance table for historical data. Most students attend 3 classes a day; however some may attend 2 and on a rare occasion, maybe 1 class per day. A query of active students (say I've got 10 active students) that is related to the attendance table.
Hope to get:
A full class roster form.of the 10 students, with the date auto defaulted to "today".and a default number of 3 in each attendance field. If the student does less than 3, I will manually change those numbers.(rare) Then I want the attendance information to go to the attendance table