Access Database: Attendance Planning

**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