Tables :: Attendance Tracking System - Adding Hours For Each Student Enrolled In Class Session

Jul 12, 2013

I'm creating an attendance tracking system, the attendance system needs to : Allow an instructor to enroll students into one or more classes, and then add attendance by date to each class(es). The problem that I'm having is, attendance is tracked by the number of hours that a student attends class. For instance, if class1 is in session from 8a.m. - 12p.m. student1 may only stay 2.50 hours of that class and student2 may stay 3 hours. The teacher needs to be able to add attendance to class1 for July 12, 2013 and add hours for each student enrolled in this class session who attended on that day. I have the following so far, minus the attendance:

Students -This is just the basic demographic information that instructors will need to enter on students.
StudentID (PK)
StudentLastName
StudentFirstName
DateOfEnrollment
LevelOfStudy
DateOfBirth

Location - These are the locations in which our students can attend classes
LocationID (PK)
LocationName
County
City
LocationPhoneNumber
LocationFaxNumber

Classes - These are the classes that our students can attend.
CRNNo (PK)
ClassName
LocationID
InstructorID

Instructor - These are the instructors that teach our classes.
InstructorID (PK)
InstructorLastName
InstructorFirstName
InstructorEmailAddress

Enrollment - This table enrolls the student into a class
StudentID(PK)
CRNNo (PK)
LocationID (PK)

View Replies


ADVERTISEMENT

Tables :: Student Database For Daily Attendance - Column Limitations

Dec 31, 2012

I'm in the process of constructing a student database for my school which would track (in addition to detailed student information) the daily attendance of over 270 students.

It is my understanding that there is a limit of 255 field names per table, so I can't use the student names as field names, nor can I really use dates as this would not quite cover even a year.

Student ID and AttendanceDate as field names is also not really a feasible strategy, as each week this would eat up 1300+ rows, so I would run out of space in that direction as well.

My question is ultimately am I better off building this in excel 2010, or is there a way of doing this in access that I have overlooked?

View 4 Replies View Related

General :: Student Database - Transfer Of Payment To New Semester And Session

Nov 18, 2012

I am creating a student database in ms access2007 but finding difficult to go further. In my database, I have created the following

Student-info-table
SemesterTable
SessionTable
PaymentTable

Then a query from the payment that shows student I'd,arrears,amount due,paid. And balance

My question is

1.How do I transfer the students and their balance to a new semester and session
2.Do I have to new student and payment tables every semester bcos payment are made every semester
3. I want to keep each students payment for as long as they remain in the school
4. A session is made up three semesters how do I transfer students to a new session

May be my tables layout are faulty...

View 1 Replies View Related

Pupil / Student Attendance / Register

Feb 25, 2007

This idea has been sending me nutty for months!

I’m a travelling music teacher. So my many pupils are split into many small groups (of 1, 2 or 3 pupils).

What I want is to open a form with lesson details. I’d select a date and then a group and then the details of the pupils in that group would come up (probably in a subform). I could then enter data for each pupil for each lesson e.g. whether they were absent.

That’s it!

My current tables are

[pupils]
pupilID (pk) (autonumber)
pupilname (text)

[groups]
groupID(pk) (autonumber)

[lessons]
lessonID (pk) (autonumber)
lessondate (date)
group (text)

[pupilinlesson]
pupilinlessonID (pk) (autonumber)
group (text)
pupilID (number)
absent? (Y/N)
lessonID (number)

This last table is supposed to store the data of each pupil in each lesson.

Relationships

[groups]groupID 1 – M [pupils]group

This is probably quite easy for someone who knows how. Lots of people must need registers of pupils!

Thanks

View 2 Replies View Related

General :: Using Bar Codes And Access For Student ID And Attendance?

Jul 5, 2012

I run an after-school youth program for high school students. My issue is an accurate way to track attendance of students. We have MS ACCESS 2010 on our computers at work.

On any given day we may see between 30 to 50 students, so this is a small operation - - and the reason I'm adverse to buying fancy "custom" software and hardware "systems". Because students come and go and vary over time, we may see 100 kids in a given week, but in the past 2 years of operation, we have had well over 250 students come through our program, with some returning at various times.

What I would like is to be able to

1) Make a simple ID card with student photos and a unique ID # that can be ...

2) Scanned by a simple barcode system.

2b) Actually two barcode swipes ... one swipe at the front door / main entrance, and a 2nd swipe by a hand held bar code in the various four classrooms to be sure the student is not only in the building, but also went to the correct class.

3) That the input of that information dumps into our ACCESS database so we can track student attendance, and ...

3b) provide reports out to school counselors / principals of the numerous highs schools that our students come from, to let them know which of their kids are actively attending our program.

My questions are ...

A. Can this be done with ACCESS?

B. Would it be better to do this with EXCEL?

C. If ACCESS can handle it, which types of bar code devices would be the best choice for us to purchase? (We would need a total of five barcode scanners. One at the front desk, and one in each of our four classrooms.)

The system would need to be expandable seeing that this could easily be doubled in terms of classrooms and students within the next year or so. We are currently just 2 years old.

View 3 Replies View Related

Forms :: Attendance Table - Find Student ID Before Update

Apr 2, 2013

I have a table called Attendance were information about the Student and the class they are attending is collected.

Another table called Student, this hold information about the student. I am using a Form called Attendance to input my information. What I am trying to achieve is:

BeforeUpdate on a text box:

When you input Student_ID it looks at the Student Table to see if the Student ID is valid before the information is updated to the Attendance Table.

View 4 Replies View Related

Forms :: Attendance Tracking And Fees Calculating For Gym Database

Apr 11, 2013

I'm creating a Gym Database and need to be able to track attendance for specific classes. I need to have a system in place allowing me to do a register for attendance for each activity.

I also need to be able to calculate fees based on attendance. So if a person attended Gym 5 times in the month (£5 per session) and then Swimming 3 times in the month (£2 per session). My system should automatically calculate this based on the attendance tracking.

Also: In the booking stage, I need to have a field telling me how many spaces are left on each activity. Say for example I'm booking Person 99 in for Swimming and there is only 11 places left I need the field to display 11 places left. After that booking it should update saying 10 places left because Person 99 is booked in.

View 1 Replies View Related

General :: Spreadsheet For Attendance Hours / Employee

Nov 3, 2013

I have:

- tbl_company (containing company info)
- tbl_employee (containing employees info)
- tbl_cim (containing working contracts info, related with both tbl_company and tbl_empployee)

In the tbl_cim i have starting date of the contract, working time per day (in hors, according to the contract), ending date of the contract, etc.

I need:
- once a month i have to generate a "excel-like" sheet containing employees (rows) on a selected company, days of the month (1-31) i choose (columns) and hors worked on each day (according to the working_time from tbl_cim). The working hours i have to be able to modify.
- the days before start date of the contract have to be empty; the days after end date, also.
- the saturdays and sundays have to be marked ina different color (cell background).

I ask:
- what tables i have to create additionally?
- how can i create a form for this infos?
- is there a way to do this with less vba as possible?

In my country, Romania, this type of "spreadsheet" is called a "pontaj" and companies have to do it every month. I would like to step from Excel to Access with it.

View 1 Replies View Related

Time Tracking System

Apr 24, 2006

I have a time tracking system where users can clock in and clock out. I want to have an error message when they clock in and then accidently clock in again. Therefore, they can only clock out after they have clocked in. The data goes into the table called "Timeclock Table". The fields in that table are SSN, Clock-In, Clock-Out, and TimeStamp. the clock in and clock out are check boxes. can you guys help me??????

View 1 Replies View Related

HRIS System - Tracking

Aug 31, 2007

I'm new at database and in the process of creating an HRIS system. I have all relevant employee information in an Employee table however, i want to know what is the best way to track employee history, such as increase in salary or dept changed etc? Its this done through forms? Please help and thank you in advance.

Activ

View 2 Replies View Related

Database Design For Container Tracking System?

Apr 17, 2014

I am designing a shipping container tracking system for my work and would like to know what the best design is for this.

There are many excel sheets that provide data on the status of containers along the supply chain i.e. shipping schedule, data from the logistics supplier showing status at the wharf, data for movements on our site etc.

Each container has a unique identifier according to what stock it carries and also a container no. designated by the shipping line. I was planning on use the first one as a primary key.

My first instinct was to have a main table that contained all of the information, with queries that updated the fields from the other data sheets.

View 8 Replies View Related

Tables :: Primary Web Based Inventory System - Update Raw Data From Another System

Mar 13, 2014

I have our primary web based inventory system that I am exporting to Excel and using this as an import to Access for the main raw data for my database. This being inventory it changes daily so I am updating this table every day. When I try to append the table it ads all the records. I am wanting an easy way to add only the new records/take out the ones that are no longer there. Basically update the table with what is currently there.The only have I have found to do this is by running non-matching queries and update queries.

View 2 Replies View Related

Queries :: Importing Data From Clocking On System To Analyse Worked Hours - Link Paired Record?

Jul 5, 2013

I have been tasked with importing data from a clocking on system to analyse worked hours.

There is no option to amend the format of the export which is not great

surnameforenameField2Field3xxx
xxx
11/06/201319.18
xxx
xxx
11/06/20135.37+
xxx
xxx
12/06/20135.41+
xxx
xxx
12/06/201319.21

The plus indicates a night shift worker
eg started at 19.18 and finished at 5.37 on the 12th

so for every record I have staff id , date, and clock time ( I have stripped out the + ) and created a yes/no field to identify the records where field2 should actually be field2+1

I have sat in query design screen for ages and cant think how on earth I am going to calculate hours worked for a given staff member and date combination.

for every combination of staff id and date there should be 2 records - a clock in and a clock out

I thought about creating new fields clockin and clockout but struggling to see how I can link the 2 "paired" records together

vb script with dlookup for every record ?

View 10 Replies View Related

Modules & VBA :: Class Variable Resets When Adding New Record In Subform

Mar 30, 2015

I have a parent form which has a class variable (class module instance) to store the form' status and more.... and when i add a new record to the subform it resets the class variable field' data. but this only happens on first transaction, but if i re-run the steps (re-set the variable field value) it's not happening again.

View 3 Replies View Related

Error Adding Hours

Dec 23, 2006

I have the following SQL to add hours
SELECT tblTrip.PaySlipReference, Sum(tblTrip.NDays) AS TotNDays, Int(Sum(tblTrip.FlyingTime)*24)&"."& Format (Sum(tblTrip.FlyingTime),"nn") AS TotFlyingTime, Int(Sum(tblTrip.DutyTime))&"."& Format(Sum(tblTrip.FlyingTime),"nn") AS TotDutyTime, Int(Sum(tblTrip.TAFB))&"."& Format(Sum(tblTrip.TAFB),"nn") AS TotTAFB, Sum(tblTrip!DutyPayRate*tblTrip!TAFB) AS TotDutyPay, Count(tblTrip.NDays) AS NumberOfTrips
FROM tblTrip
GROUP BY tblTrip.PaySlipReference;

Refering to the part "AS TotFlyingTime" it works perfectly as the format is a 24h and never goes over 23.59 hh.mm. The problem I incour is a incorrect result for the other two parts of the code: "AS TotDutyTime" and "ASTotTAFB", these data have values over 23h59m.

View 2 Replies View Related

Multiple Tables Per Person (student)

Nov 13, 2006

Hi

I have a DB for students.
I'm making notes each time we've had a chat.
Is there a possibillity to make a relationsship between 2 tables so I can make multiple records for one person? (or any other way)
For ex. 03-04-06 there were a couple of things I wrote down.
and 03-06-06 there were some other things I wrote down about the same person.
and then I will be able to backtrack this information
How do I do this.

Mikael

View 6 Replies View Related

Modules & VBA :: Adding Time With Work Hours Function

Sep 13, 2014

In my DB that we use and a workflow tool, some of our work has and due date and time.If we get the complete_package our work time starts and we have X amount of time to complete our work. This is something i worked on but set it aside, now i am coming back to try and fine tune this so it returns a more accurate value.

So if we receive and [Date_Complete_Package_Received] at 09/13/2014 09:00:00 AM and based on the work being done we have 5 hours to complete the work, then the [Date_and_Time_Complete_Package_DUE] would be 09/13/2014 02:00:00 AM. That part is simple and i have coding that does that just fine. [SLA_Time] is where it gets the amount of time allotted, we have 5,10,12,14,and 16 hours depending on what is being done.

Code:
Me.Date_and_Time_Complete_Package_DUE = DateAdd("h", [SLA_Time], [Date_Complete_Package_Received])

This is done on AfterUpdate of a field on one of my forms and it works the way it is but what i need is to be able to run this through my Workhours Function so i am not getting values that our in off hours.The following doesn't work i know i can't use the Workhours function with the DateAdd but this is just to show what i am trying to do.

Code:
Me.Date_and_Time_Complete_Package_DUE = WorkHours(DateAdd("h", [SLA_Time], [Date_Complete_Package_Received]))

I have a Workhours module and it is used for a lot of things and it works perfectly.

View 1 Replies View Related

Queries :: Adding Up Times To Get Total Amount Of Hours

Dec 5, 2014

I have a table of hours that have been worked by employees for each day of the week

[moh] (Monday's hours),[tuh],[weh],[thh],[frh],[sah],[suh]
data eg (this is how I would like it to be inputted into the table)
7:24:00,7:24:00,7:24:00,7:24:00,7:22:00,0:00:00,0: 00:00

This equates to 36:58:00

I have tried

Total Hours: [moh]+[tuh]+[weh]+[thh]+[frh]+[sah]+[suh]

but I am struggling to get what I want in the right format.

How to record the initial data or a formula to format the end result.

Excel just does it !!!!!

View 1 Replies View Related

Tables :: Set Up Attendance Database That Has Multiple Status Available For Single Day

Dec 9, 2012

I need to set up an attendance database, that has multiple statuses available for a single day.Example: employee can be present, he can have a sick leave, he can be away on training, or business trip, etc... And for some of those statuses, like business trip, i need to be able to freely enter a comment, stating where he is etc..

Anyway, the key is that this database should be able to offer a "headcount" option, and traceability for past statuses for at least a year, for every and all employees. Now i just need to set up the database tables and relationships.

View 6 Replies View Related

Tables :: Setting Up A Soccer League Database To Track Attendance

Dec 7, 2012

I run a soccer league where we track players attendance for each game. I currently do it on a spreadsheet where each game date is a column and each player is a row. We also track which team they play on at each game (they can play on different teams different weeks). I currently have a second tab in the spreadsheet to record which team a person plays on each week.

Setting up a table of fields for this is relatively easy. The problem comes to data entry. I want to be able to visually see the data like I can in a spreadsheet (names in rows, dates in columns, intersections containing either team name or whether attended) and whilst a cross-tab query gives me the layout, I cannot input data in a cross-tab query.

View 1 Replies View Related

Modules & VBA :: Daily Renting Cars System - Adding Dates When Client Not Paying

Jan 16, 2015

I'm making a daily renting cars system. The client should pay every day ( day by day). Everything is ok but if the client pay at these days....

dd/mm/yyyy
01/01/2015
02/01/2015
03/01/2015
10/01/2015
11/01/2015
12/01/2015

At the date 15/01/2015 i want to check the payments. How to let the system show me that the dates

04-05-06-07-08-09-13-14-15/01/2015

the client didn't pay the fees

Opening the payment form and make a new record everyday even if the client didn't pay and finally by a query I'm getting a list where the payment date field Is Null, but is there any other solution without adding the dates manually.

View 3 Replies View Related

Need Better Tracking With My Tables

Oct 19, 2005

I have a DB thats working fine, but (there always is a but) I now need to do something a little bit different. I need to be able to track my originators and who they have brought into the company. So I will have an originator and many down-line originators, and these people that come in down-line will have people coming in down-line from them and so forth and so on. I have a table that has all originator info and originatorID, but will I need another table or can I just add to the exisisting one. Here is the table structure:

‎Originators:
-------------
OriginatorID -autoNumber
FirstName - Text
LastName- Text
OrigSSN- Text
Address- Text
City- Text
State- Text
PostalCode- Text
HomePhone- Text
WorkPhone- Text
CellPhone- Text
FaxPhone- Text
EmailName- Text
BirthDate- Date/time
Level- Text


If more info is needed please let me Know.. Thanks in advance.

Scott

View 4 Replies View Related

Tracking Down Linked Tables

Feb 1, 2006

I am trying to deconstruct a database that has several linked tables. Is there a way to find the source database for the linked table from within the original database?

View 3 Replies View Related

Tables :: Tracking Data Associated With Samples

May 10, 2013

I'm looking for some input on table design.

I work in a lab and am looking to track data associated with samples on PCR plates usually in 2 formats

96 well (8x12) rows A-H and Columns 1-12
384 well (16-24) row A-P and Columns 1-24

each well will have at least 3 pieces of information associated with it:Sample
Assay
Qulaity Score

but more may be added as I progress with the design.

field such as run name run date and operator for each plate would also be needed

What would be the best way to structure the table?

Obviously listing well A1, sample in A1, QA for A1 etc etc as fields wouldn't work as theres a 255 field limit and 3*96 = 288 and thats before we even get to 384

I could have a table for each run but that feels like bad design to me, as if you wanted to look at quality trends across time you would need to query multiple tables and query the date associated with each to even knwo which table to look in

A table for each well along with its QA score, assay and a look up field linking it to a list of plates, which would contain the run date etc. (this table listing runs is already present in my database)

Some background on current structure

Tables

Booking - contains a list of worksheet numbers along with info such as submitter, and conditions for the test such as assay

Experiment - expirment number conditions and associated DNAs

DNA - a list of dna samples

Plate - name of plate and info such as run date and associated worksheets

View 4 Replies View Related

Tables :: Tracking Several Years Of Data?

Oct 26, 2012

I am looking to track the salary information for my small firm over a number of years. Does it make sense to create a table with multiple fields that would be structured like this (2011401(k), 2011Medical, 2011 LifeInsurance, 2012401(k), 2012Medical, 2012LifeInsurance, etc) or is there a better way to tackle this?

View 14 Replies View Related

Queries :: Subtract 8 Hours Of Work From Result Hours

Nov 29, 2014

I want to subtract 8 hours of work of the Result of employee work hours/

There is attachment...

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved