Find Jobs
Hire Freelancers

MS Access Attendance Table / Query Design

$100-250 USD

In Progress
Posted about 11 years ago

$100-250 USD

Paid on delivery
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
Project ID: 4430522

About the project

4 proposals
Remote project
Active 11 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Kababayan, let me do it for you. Please see my profile. Thanks
$150 USD in 2 days
4.9 (38 reviews)
6.5
6.5
4 freelancers are bidding on average $244 USD for this job
User Avatar
Hi, I have experience with this project, I happily if work with you in this project. Best Regards
$250 USD in 10 days
4.7 (10 reviews)
4.7
4.7
User Avatar
Hi, i can do this task, thanks.
$200 USD in 7 days
5.0 (3 reviews)
2.4
2.4
User Avatar
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.
$375 USD in 12 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of PHILIPPINES
Cainta, Philippines
5.0
10
Payment method verified
Member since Jul 25, 2010

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.