Devam Ediyor

MS Access Attendance Table / Query Design

Hello,

I need a table / query / form / report made from ms access database.

How the database works is we will scan the barcode of each employee on a form then it will log the TIME IN of employee and when the work is finish we will scan it again for TIME OUT and then we will have query / report to search each employee by date to see his TIME IN and TIME OUT and total how many hours he worked, please note that we will encode each employee name and barcode number to table so the system will just search for barcode number of employee and logs its TIME IN and TIME OUT also standard working hours is 8 hours so if the employee exceeds 8 hours then it will also have another field of OVERTIME so maybe multiple cross table is required here

basically i need in table are

1. Date (now) default date today

2. Employee Name

3. Employee Barcode

4. Employee Time IN

5. Employee Time OUT

6. Total Work Hours

7. Overtime

Now in Form this is what we need only

* TIME IN FORM

1. Date (now) default date today

2. Employee Name

3. Employee Barcode

So there is field for barcode where we will search then scan employee barcode then it will log the TIME IN

* TIME OUT FORM

1. Date (now) default date today

2. Employee Name

3. Employee Barcode

So there is field for barcode where we will search then scan employee barcode then it will log the TIME IN

Reports:

1. Open report and capable of searching each employee by date then it will produce report of employee from date to date and information will show his name, barcode number, start time in and time out, total work hours and overtime if he has exceeded 8 hours work.

I hope this is clear.

Thanks

Beceriler: Microsoft Access

Daha fazlasını görün: Query design, access query table, access attendance, access table query, access employee attendance database, access table query form, access attendance table design, access attendance database design, working time overtime database design access, attendance table access, query attendance access, barcode attendance access, access query design, attendance access, attendance report access, attendance time table access, attendance table design, access query attendance, time attendance database design, searching employee, scan design, open-table, ms access work, logs design, log cross

İşveren Hakkında:
( 10 değerlendirme ) Cainta, Philippines

Proje NO: #4430522

Seçilen:

rhomeu

Kababayan, let me do it for you. Please see my profile. Thanks

2 gün içinde 150$ USD
(38 Değerlendirme)
6.5

4 freelancer bu iş için ortalamada 244$ teklif veriyor

winnet21

Hi, I have experience with this project, I happily if work with you in this project. Best Regards

in 10 gün içinde250$ USD
(10 Değerlendirme)
4.7
omaralieissa

Hi, i can do this task, thanks.

in 7 gün içinde200$ USD
(3 Değerlendirme)
2.4
Tulear

Just award me this project, so that I may complete it. That's all you need to do, then you can focus on something else, or just have fun ! Thank you for your trust.

in 12 gün içinde375$ USD
(0 Değerlendirme)
0.0