In Progress

Access database to manage employee locations

Need a Access database in .accdb. I have 20 work sites, up to 80 different positions at each work site that need to be manned 100% of the time. I would need to maintain a list of my employees with which positions the are authorized to perform, their current locations, how long since the last time they have been scheduled and if they have any Leave of Absence.

I need a form where I select the Site, Then position to be filled, then what skill it requires, the dates the employee will fill the position and then which employee is available(an employee not scheduled in another position and is not on a LOA), Employee's should be sorted based on who has not be assigned in the longest time. Have a Save button to check the last person to be assigned to the position and any people in the future in a effort to verify multiple people are not assigned to the same position or something similar to prevent double booking of the position.

I need to be able and view each site and see by day and week who will be filling each position at each site. The positions should be rows and the date column. The person in each position for that period will be the value.

Skills: Database Administration, Microsoft Access, SQL

See more: database employee payroll microsoft access, access employee attendance database, employee database access template, employee database access 2010, employee database access 2010 template, employee database access, track employee training database access, access manage database, access employee safety database, access employee training database, access mysql database jscript check duplicates, manage backend access database vba, access database code check inventory, create database access 2003 access 2007, convert database access exe, inventory database access, mailing list database access, oracle database health check operations

About the Employer:
( 0 reviews ) Sierra Vista, United States

Project ID: #12086987

Awarded to:

paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a database. I have 7 years’ experience designing and developing Access databases. I would approach your project by creating a draft More

$250 USD in 7 days
(67 Reviews)
6.1

10 freelancers are bidding on average $319 for this job

$450 USD in 5 days
(125 Reviews)
6.3
shikhamehta

Hey, I reviewed the requirements brief and would recommend that the setup that you are looking for be built in Excel rather than Access because of the flexibility it offers. Is there any specific reason you are look More

$294 USD in 9 days
(82 Reviews)
5.9
AwaisChaudhry

Hello I have read what you exactly need. However, I would like to ask you a few questions. I do work in a smart way and do not rest until I get the job done. Please feel free to contact me anytime so we can have a deta More

$294 USD in 3 days
(12 Reviews)
5.4
$294 USD in 3 days
(20 Reviews)
5.5
prakashmondal

Hi, I am interested to develop this application as web application where all the employee can login using their credential and administrator can view all the employees status and make roster to make sure 100% manned. More

$350 USD in 7 days
(26 Reviews)
5.4
WebInfoSolutions

I am assuming that you want all the data entry forms + Reports in MS Access. I can do this...............

$294 USD in 7 days
(23 Reviews)
5.6
mdkass

Hello, I can make an application that uses Access database as a back-end, and the user interface is more easier to use than Access forms and more attractive. or can make it all in Access. Regards.

$300 USD in 5 days
(21 Reviews)
5.0
$411 USD in 3 days
(18 Reviews)
4.3
crypthne

I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administ More

$250 USD in 10 days
(18 Reviews)
3.8