Committee Attendance

Apr 29, 2005

I have a task of creating a database to track committee members attendance at meetings. Members can be on more than one committee. I have created tables for committees, committee population and committee members.

The meetings would take place once a month and do not need an exact date. A Yes/No would suffice for record of attendance. My question is what would be the best way to set up the table to track this since members can be on more than one committee?

I'm thinking that having a separate meeting table for each committee would be a bad idea. But haven't come up with any other ideas. Any suggestions???

Thanks :)

View Replies


ADVERTISEMENT

Attendance Dbase

Feb 12, 2007

Dear fellows
hi
I need sample access dbase records and retreive attendance of students in course
thank you for help
moheb morcoss

View 3 Replies View Related

Attendance-Query

Apr 11, 2008

Hey,

for some days i've a problem with an Access-Query and up to now i didn't succeed to find an answer, i'm not even sure if there is one.

So, how to explain my problem.
I'm trying to compile a Database for my small department to organize our computer-short-course
students (application, grades, attendance...)

And with the grades i have a problem as well as with the attendance. Up to now we are just using paper sheets for grades and attendance. So i just thought that it would be the easiest thing to create a similiar-looking form, drawing of planned Query-output-layout is attached.

The attendance should be set with a checkbox. New days are set with a small subform.
For the attendance i've this table-layout:

tblAttendance
aSID
aCID
aDate
aPresent

When a new day is set, every student gets a new record at the tblAttendance, which shall be compiled together for the later Attendance Form.

So now the big question comes, is it possible to create
a query that fits my needs (variable amount of days and students and the possibility to set my records)? It is important that i've a big sheet with all the days, students of a course
at the same time.

Any suggestions - i'm completly lost.
Thanks in advance,
protos

View 2 Replies View Related

Calculating Attendance

Mar 17, 2005

i have tblmember tblclass and tblattend

the tblattend is

member 1d
class id
date of class
Attended (check box to say or no on a form)


i need to produce a quey which will calculate % attendance after each month and after each year of each member and class

how do i do this

View 10 Replies View Related

Sample Attendance Database?

Sep 7, 2006

I am trying to create an attendance application for my group of 6people, does anyone have or know where i can find any to look at. I don't even know where to begin.

Daily in and out. Keeping tabs of our vacation days/sick days.
I just need to know where to begin, or need a sample for ideas in creating this. I have looked high and low. Please show me/tell me if you have any or how you did it, if you have done it before. Thanks friends!

I posted this here but didn't get any response.
http://access-programmers.co.uk/forums/showthread.php?t=114099

View 6 Replies View Related

Access Attendance Register?

Jan 24, 2007

Hi,

Well I'm stumped...

I am creating a new database system for my cadet organisation, and I am in the early stages of learning how to use Access. (I am using this as a learning curve, as I need to get to grips with Access for University, there's no better way to learn than by doing.)

I want a system that stores the attendance of cadets on each night we meet, so far I have:

|Table| Cadets
CadetID - AutoNumber (PK)
FName - Text
LNAme - Text
Flight - Lookup from Flight Table

|Table|Flights
FlightID - AutoNumber (PK)
Flight - Text

|Table|Attendance
AttendanceID - AutoNumber (PK)
Attendance Type - Text

The table that actually contains the register I am unsure how to structure, it would have to contain Cadet Name/ID, the date and Attenance type, from attendance DB.

The table would be updated every Tuesday and Thursday, when we meet. I've been thinking for a while about how to do this and can't find a good solution.

As the data will be entered by a user (who won't know Access from Adam) I'd like a form that lists all the cadets in the Cadet table, as each of these will have to be registered, and then a drop down box listing the options from the Attendance table next to each cadet, doesn't have to be drop down, can be optionbutton, image....

In the final version I would like the cadets to be sorted by flight in the form, but lets not go mad yet!

Can anyone help me with this? Or am i simply being silly?

I haven't used Access for long, but have used VBA in Excel before and am a fairly experienced user; I will attempt anything but bare with me if at first I don't succeed.

Any help appreciated
Tim

View 1 Replies View Related

Attendance Data Type

Apr 19, 2007

Hello everyone, I am buiding up a database for activity school. Here first step of buiding the base, I got an attendance data type problem. i am now using "yes/no", but if i want to query about the number of student each class, is that possible?

Thank you for your help.

View 5 Replies View Related

Help! Need To Make Attendance Form!

Mar 20, 2006

I am trying to make a class attendance form, where user chooses classType
ex:"English, French" then the program shows all of the students from tblStudents that are enregistered in that class. And some how make it so that user could select on or many users in the same class and press add button which will add the students into attendance table for the current class and the current day,

**Allso what I would like to do if possible after the form above works, is to if the student has been allready added for the current day, the check box becomes un editable with appropriable comment in the comments line for that student or for examples the student registered for 12 classes, the attendance keeps track of the classes and when the student tryed to go to 13'th class the check box is uneditable and in the comments line for that student metions the reases.

View 6 Replies View Related

Sample Attendance Project?

Sep 7, 2006

I am trying to create an attendance application for my group of 6people, does anyone have or know where i can find any to look at. I don't even know where to begin.

Daily in and out. Keeping tabs of our vacation days/sick days.
I just need to know where to begin, or need a sample for ideas in creating this. I have looked high and low. Please show me/tell me if you have any or how you did it, if you have done it before. Thanks friends!

View 1 Replies View Related

Any Way To Record Weekly Attendance

Nov 26, 2011

My next challenge/task is to create a way to record weekly attendance. I have looked at several databases available online but not that really reflect what I need. Also I am trying to do it the simpliest way possible (for now) with my limited knowledge of VBA code.

Here is what I am hoping to do. I have a form linked to a query that will select the students assigned to a faculty member in all the courses that faculty teaches. I would then like to be able to use the same form, and a second combo box, to create records in an AttendanceTable that stores the attendance for that student in that course for that week. I have created a key using StudentID-CourseID to identify each student with each of the course they are enrolled in. It is also used to relate all the involved tables.

View 2 Replies View Related

Table Design Query - Attendance

May 26, 2006

hi,

i'd like some initial help with how best to set-up my tables for a database i need to create. if anyone could give me a synopsis of what i need to do it would be great and then i can try and piece it together.

here are the requirements;

one student can attend many different courses.

each course runs for 10 weeks.

i'd like to be able to have forms to;

- add a student.
- assign classes to a student.
- record absence via a combo box for each student for each week

i'd also like to have a report mechanism that can record if a student is absent for 3 or more classes.

as i said, some pointers or examples would be great as i am new to this. i pressume i need;

a table for students
studentid
firstname
lastname

a table for the courses
courseid
coursename

a table for attendance
attendanceid
courseid
studentid
present/absent (combobox)
week

Am most stuck on the date part. the data may not be entered every week so i can't really use a date function. instead i need a combobox or something to be able to select the week.

cheers
mark

View 2 Replies View Related

Time And Attendance Coding Database

Oct 21, 2006

Hi All,

I am setting up a database to help me prepare codes for employees timesheets in order to upload them into our payroll software. The table structure below is just my preliminary thoughts and current ideas and I guess I'm looking for ideas on how to work with my codes.

EMPLOYEE TABLE
EmpID (PK) - Employee ID # [Autonumber]
Surname - Employee's surname [Text]
Firstname - Employee's first name [Text]

ATTENDANCE TABLE
ShiftID (PK) - Shift ID# [Autonumber]
EmpID (SK) - Employee ID# [Foreign Key]
Date - Date of shift [Date/Time]
Start - Start time of shift [Time]
Finish - Finish time of shift [Time]
CostCtr - Cost centre being billed for shift. [Integer]

When employees work they are entitled to the following:
* Ordinary hours (code 001) for all hours worked.
* 10% penalty (code 006) for all hours worked when shift finishes after 18:00
* 12% penalty (code 007) for all hours when shift crosses midnight
* 50% penalty (code 008) for hours worked on a saturday
* 100% penalty (code 009) for hours worked on a sunday

The following shows data that in my Attendance table for an employee who worked shifts on the 16th (Mon), 17th (Tue), 20th (Fri), and 22nd (Sun).
ShiftIDEmpIDDateStartFinishCostCtr
18443416/10/0610:0019:00
28443417/10/0610:0019:003002
38443420/10/0622:0006:003001
48443422/10/0614:0022:00
From the above data I believe I will need to make another table that contains the entitlement codes generate from each shift.

For the first shift on Monday 16/10/06 I need to collect the following codes for the total calculation:
CodeHoursCostCtr
0019.00
0069.00

For the second shift on Tuesday 17/10/06 I need to collect the following codes for the total calculation:
CodeHoursCostCtr
0019.003002
0069.003002

For the third shift on Friday 20/10/06 I need to collect the following codes for the total calculation:
CodeHoursCostCtr
0018.003001 'Ordinary hours worked
0078.003001 '12% penalty as shift crossed midnight hour
0086.003001 'Only worked 6 actual hours on the Saturday as 2 hours were on Friday night.

For the fourth shift on Sunday 22/10/06 I need to collect the following codes for the total calculation:
CodeHoursCostCtr
0018.00'Ordinary hours worked
0098.00'Hours worked on the Sunday

From that information the only data I really need to store in a table would be the totals grouped by code and cost centre. Eg.,
CodeHoursCostCtr
00117.00
001 8.003001
001 9.003002
006 9.00
006 9.003002
007 8.003001
008 6.003001
009 8.00
Does anyone know the best way to go about this? Should I generate a new table that links these codes to an employee? Should I make a function to calculate the codes for each day and store them in a table or make the function only sum the code totals for the week and store them in a table?

Brad

View 1 Replies View Related

Problem Creating Attendance Records

Feb 3, 2007

I've got myself a little stuck!

I'm trying to create a database for our new theatre group. I've created a table for membership details (ID, Name, DOB, Address, etc.)

I want to create an attendance register - kind of the way a school register looks, so it will show on screen like a spreadsheet (names down the left-hand side, dates of the sessions across the top, and a grid for the attendance codes).

I know I could paste the membership details from Access to Excel and use a spreadsheet, but I'd like to keep it all together.

The attendance codes don't just contain present or absent, I would like to keep a record of payment 'P' or on holiday 'H' etc.

I'll keep searching and scratching my head, but any help would be appreciated.

View 1 Replies View Related

Feedback On Prototype Attendance Database, Please

Jul 13, 2007

I had trouble figuring out how to 1) register a group of people for a class, 2) create a list of dates to meet for a class (which I call sessions), 3) track attendance per sessions. Having looked for templates at Microsoft, I found plenty of Excel templates, but no Access. The closest is Student Registration template, which doesn't track attendance at all. So I figured I'd make a prototype to help me understand how everything works. Since I got so much input from everyone, I figure I'd return the favor and perhap make it a sample database, especially for those who desire a spreadsheet-like data entry while maintaining a properly normalized data structure.But I would prefer that other has tested and given feedbacks on the prototype before I put this in sample database forum (if that's okay with you admins) as this is my first time and I don't want to give others bad template. So anyway, here's the prototype.Note: The database is 100% undocumented, 100% error-handling free, and 100% unsecured. Use it wisely. :)PS: The attachment will reference a extraneous library. If you are getting an error, clear the reference for MS Office 11 Web Components.PSS: I knew I forgot something: There is still unsolved problem of correcting sorting the columns in datasheet view. While the underlying query correctly sorts the recordset, it seems to be ignored entirely in datasheet. If anyone has a solution, I'm all eyes here.

View 14 Replies View Related

Yearly Attendance Tracker/Calendar

Jan 29, 2008

I'm currently attempting to setup a small database to track a few things for the company I work for, namely attendance. Currently they use an excel spreadsheet that covers the current year. This worked great for them when they were still a small company, but with the number of employees shooting from 50'ish to a couple hundred the spreadsheet is just not a viable option any more.

What I need is suggestions on the best way(s) to go about implementing this.

First, I need to do a 1 year look back, on a montly level is fine. So from January 2008 back to January 2007 will work fine. What i have currently setup is a form with 12 of the basic Calender controls built into access 2003. Unfortunatley these wont quite work.

Basic layout of my database so far will be an employees info table, a lookup table for Attendance codes and their infraction values and an attendance (or I suppose more technically an absence) table. I would like to have a form that displays a calendar view for the last 12 months, that will allow me to view / update any absences for an employee. I would also like a way to insert company holidays / shutdowns in to the attendance table in a way that marks it on any employees calendar as a scheduled day off. I assumed i could do this with a simple "all" employee along with the dates and have the calendar search for entries with the Employee ID as well as the All flag and mark those on the calendar.

I think if i can just get the calendar setup covered I can figure out the rest of the data aspects, I'm just stuck on finding a decent way to implement the Calendar Aspect.

Thanks in advance!

View 14 Replies View Related

Attendance Database Table Structure

Sep 9, 2005

I would like to build a database to keep track of tardies and absences in my dept (~70 employees).

I need Date, Name, tardy or absent,

My current table:

TblEmployees
EmployeeID PK
Last Name
First Name
Team

TblEvent
EventID PK
Event (Tardy or absent)

TblAttendance
Date
EmployeeID
EventID

Is this a good structure? I need to be able to run a query that will sum the total number of tardies and divide by 6. That number will then be added to the total # of tardies. The query needs to only show the values over the last 6 months.
Any help is appreciated.

Thanks,
jason

View 2 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

New User Creating An Attendance Database

Jan 3, 2008

Hello, I am in the process of creating my database and I was looking for some guidance. My goal is to manage and track clients attending our program and ultimately being able to print and individual report with that information. Example: john doe on 12/28 attended 3 groups X,Y and Z.
I have created two tables one with the client's ID, name and starting date.
The second with the groups offered, the instructors and days and times of the groups.
The third I believe should be a dated table that would have groups and all the people who attended that day. This is where I am getting confused. I am not sure how to proceed.
Any ideas or suggestions would be welcomed.

Thanks in advance.

View 1 Replies View Related

Count Vs. Function For Attendance Report

May 26, 2006

Greetings!

I'm trying to make an Attendance Report for my students. I want the report to show each student and how many times they've been "Present", "Late" or "Tardy" in a month and in one year.

I've set up my db with two tables.

Table 1 - contains Student ID and Student Names
Table 2 - contains Attendance ID, course id, student id and the Status ("Present", "Late" or "Absent")

I used the sum queries and it doesn't do the count function properly. This is a copy of my query.

Thanks :o
Surfette

View 4 Replies View Related

Forms :: Enter Attendance At Event?

Jan 22, 2015

I have a database with three tables:

Participants (with name...), Events (with Event Name, date..., Event Attendance (Participant ID, Event ID, Date).

Relationships all work and reporting works. I now want to create a form for entering attendance into a single event as a batch. I only want to enter the event ID one time and then be able to enter participant ID's for all attendees. The event coordinator will have a tablet running the db at the door and each participant will use their ID card to be scanned into the event.

I don't want the coordinator to have to reselect the correct event between each participants scan but instead to enter the event once and have multiple participants ID's entered for the one event. The date field is defaulting to current date/time [Now()].

View 6 Replies View Related

Attendance Log - Missing Person(s) On Particular Date

Feb 15, 2012

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.)

View 6 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 Form - Checking The Box For Only One Record

Apr 6, 2015

I've got an attendance form set up with check boxes for each day I want to check attendance. I have two problems with this form.

1) All the boxes start out with little squares (I want them to be blank)
2) If I try checking a box for one person, it checks all the boxes in the column (same with unchecking).

View 3 Replies View Related

Forms :: Registering Attendance At Event With Three Fields?

Jun 8, 2013

I have a form, which registers attendance at an event, with three fields - ID (a combo box), Name, and Present.

When an attendee comes in, they give their number which is entered into the first field. Pressing carriage return, their record is loaded, and I can then check the 'present' field. Then I click the next button and await the next person!

I'd like the simplify the whole process - so that as soon as the 3 digit attendee number is typed, the present box for that record is checked, and the form is reset (curser back to the combo box to search for next record).

In short - all the registrar ever has to do is enter a three digit number!

View 8 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

Attendance Form - Need To Auto Update Names And Dates

Mar 28, 2006

Greetings,

I'm trying to create an attendance form for my school. I have an Attendance Form already that has the following information:

Student Name
Date of Attendance
Attendance Code

What I would like it to do is, automatically populate the date for all the students enrolled in the class. So if the Math class has 5 students, the form would automatically have all five students with March 28, 2006 and the next day have March 29, 2006 and so forth.

Any suggestions on how to go about achieving this task?

Many thanks in advance!
Surfette

View 2 Replies View Related







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