Access Database: Attendance Planning

Completed Posted Jul 9, 2007 Paid on delivery
Completed Paid on delivery

**Project Requirements**

1. Create an Access database with forms for setting expected attendance times, for providing a password protected login for each employee, for providing a method of calculating available capacity for each day and displaying this information in a convenient way.

2. This database will supplement the attendance system provided by our MRP system (Jobboss). This is phase one of a multi-phase project which may include tools for reporting booked time for each job operation and for automatically shifting work to groups that have capacity in any given day.

3. JobBoss currently doesn’t provide a secure login in for each employee who will be reporting their time to projects. This supplemental database will add a table of passwords and a login form which will include login button that will time stamp when the employee started, logout/login button for lunch and a logout button for the day. All login and logout data will be stored in a table.

4. JobBoss also doesn’t provide a calendar by group for planning attendance. This supplemental database will add a planning table with employee ID, attendance date, beginning and ending times, and a note field. A form will be provided to edit each date and provide methods for scheduling attendance by repeating patterns (i.e. schedule the same attendance time each day or week). I’m not sure what is the best way to handle the repeating function in the database. Please make a recommendation.

5. The calendar form should include a method for adding holidays and non-work days to the schedule.

6. A form should be provided to show actual employee attendance compared to planned attendance. It should include actual time worked versus planned time worked as well as average minutes late or early.

## Deliverables

**Deliverables**

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. This includes the complete database with forms, tables, queries, macros and all other items that make it function. The access database should be saved in Access 2003 format.

2) Deliverables must be in ready-to-run condition, as indicated in the description.

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

Windows XP, Access 2003

Engineering Microsoft Microsoft Access MySQL PHP Software Architecture Software Testing Windows Desktop

Project ID: #3105250

About the project

10 proposals Remote project Active Jul 11, 2007

Awarded to:

pShankar2

See private message.

$85 USD in 6 days
(403 Reviews)
7.1

10 freelancers are bidding on average $76 for this job

Prashantskin

See private message.

$68 USD in 6 days
(515 Reviews)
7.0
dynamicasystems

See private message.

$85 USD in 6 days
(4 Reviews)
3.2
vw6535550vw

See private message.

$85 USD in 6 days
(8 Reviews)
3.2
gocodego

See private message.

$55.25 USD in 6 days
(17 Reviews)
2.9
oruckenaneu

See private message.

$85 USD in 6 days
(4 Reviews)
2.5
focus4vw

See private message.

$85 USD in 6 days
(5 Reviews)
2.1
cipriant

See private message.

$50.15 USD in 6 days
(5 Reviews)
1.6
ravindra2vw

See private message.

$51 USD in 6 days
(1 Review)
1.4
abdurrahmanvw

See private message.

$85 USD in 6 days
(5 Reviews)
1.1
sharakevw

See private message.

$85 USD in 6 days
(0 Reviews)
0.0