Topics Search

Attendance Table in Database

Attendance Table in Database
Views: 2
I want to set up a student attendance database as part of a student database I am constructing. My primary table in the database is student demographics and I want to be able to pull up a student's information using a tabbed form and one of the tabs would list a student's absences.

I would imagine that I would create a table called"Attendance" and the fields would be as follows:
pk-ID- Autonumber
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.
Sponsored Links:

More topics

 

Database of attendance

Preview
I am building a database in Access 2007 for a learning centre.
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
 

Database of attendance

Preview
I am building a database in Access 2007 for a learning centre. 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.
 

Database Desing for Tracking Attendance

Preview
I am creating student attendance tracking system in asp.net. With attendance I need to track students attendance every day and want to generate charts with those data.

Charts for Daily Attendance report, Weekly Report, and monthly Report. For this how to design database in msaccess?
 

Converting attendance data for reporting

Preview
I think I am out of my depth here - but desperately need to get reports created out of a database that captures dates and attendance marks.

Currently the table was 12 weeks so there is:

ID
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
 

Club Database and daily attendance date recorded

Preview
I need an example of a gym or club/martial-art attendance database. what I want to do is type in a code for a member and his or her attendance is recorder on a table as a date. So that a t a later point I can see out of several hundred members who hasn't been in between a specific date. And so that I can do statistics later on.
 

Community centre attendance database

Preview
I'm new to access ,and I need to get an attendance database up and running for a single class attending a community centre.

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.
 

Student Attendance

Preview
I was wondering if someone could help me design an Access database to store students records and be used at classes to monitor attendance.
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.
 

Attendance Record

Preview
I'm wondering what the easiest way is to create an attendance record for my scout database. One of which I can create queries and recrods from.

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
 

Can a report be put in a form?

Preview
I have two tables, Student Information and Student Attendance. I have a Student Information form and also a Student Attendance form. The Student Attendance form is used to input daily attendance and the apend it to the Student Attendance Table.

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.
 

Automate Attendance

Preview
Daily Task: Take attendance daily.
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