Topics Search

Attendance Tracking

Attendance Tracking
Views: 43
I am trying to design a very simple database for tracking attendance of my church's youth group. We meet weekly and for various events and fundraisers. I want to be able to track who attended each week or each event. I would also like to use it to be able to print out contact info (phone, email, etc. ) So far, I have is Tbl_Students and a form to enter in their information.
Sponsored Links:

More topics

 

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?
 

Adding multiple columns

Preview
I have the below query -

SELECT [QA Tracking].[State], ([QA Tracking].[Misnumbered Check Number]+[QA Tracking].[X-Post Not Rej/Flag]+[QA Tracking].[Check Rejected for Incorrect Reason]+[QA Tracking].[Mis-Keyed Vendors]+[QA Tracking].[Vendors Not Charged]+[QA Tracking].[Vendor Charged Incorrectly]+[QA Tracking].[Altered Error]+[QA Tracking].[Missed EE's Not Flagged/Rej]+[QA Tracking].[Check S/B Paid]+[QA Tracking].[No Issuance Keyed/Checked]+[QA Tracking].[Check S/B Rej]+[QA Tracking].[Stale Date Missed]+[QA Tracking].[Missing Signature(s)]+[QA Tracking].[Invalid MICR Line]+[QA Tracking].[Invalid Flag(s) Not Checked]+[QA Tracking].[Processor]) AS [Total Project Errors]
FROM [QA Tracking];

But when I run it in Access, nothing is showing up in the Total Project Error column for any of the States
 

Attendance Log - Missing person(s) Query

Preview
I have a daily attendance tracking of 100 staff, and would like to be able to find out who was missing in particular date by running a query.

I have two tables

1) List of staff members (Name and Dept)
2) Daily log of who attended (Date, Name, Dept etc
 

Attendance Log - Missing person(s) Query

Preview
I have a daily attendance tracking of 100 staff, and would like to be able to find out who was missing in particular date by running a query.

I have two tables

1) List of staff members (Name and Dept)
2) Daily log of who attended (Date, Name, Dept etc.)
 

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.
 

How to Query fields with check boxes?

Preview
I'm creating an attendance tracking database. I have a table called Attendance that has Employee Name, Tardy and Absent. The Tardy and Absent fields are check boxes, some checked, some not checked at all. I'm trying to create a Query to just give me the count for each person, how many tardy are in that record for that Employee Name and so on.

What I did was this:
Field: Tardy
Table: Attendance
Total: Count
Sort: (Blank)
Show: (checked)
Criteria: Abs(DSum("Tardy","Attendance"))

Now what this does is simply count the boxes regardless of if there checked or not. How can I make this show the sum of only those that are checked true.
I been reading before asking and I was reading I could do something like = Count(IIF([Tardy] = True,1,Null)) but even though Tardy only exist on one table and I have specified that table it still tells me that Tardy could apply to too many things when I try and run it
 

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
 

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
 

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.