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.
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 Access database and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html). I can send you a sample of my previous work upon request.
$250 USD en 7 días
4,8 (67 comentarios)
6,1
6,1
10 freelancers están ofertando un promedio de $319 USD por este trabajo
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 looking for an Access based solution? I can certainly crate the kind of system you need in Access as well but given my experience with such systems, excel based setup will be far more effective for your purpose.
In either of these based on your preference, I will create a setup that will allow you to select the location and will fill the employees based on availability as you mentioned.
I am an expert in Excel and Access based systems and have designed fairly complex automation systems based on these tools. I have done more than 500 projects here on freelancer with excellent ratings and can assure you best quality work.
Please send a message to me if you would like me to work on this project for you and we may discuss the next steps.
Look forward to hear from you and thank you for considering my bid.
Best Regards,
Rishi
(Automyze Consulting)
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. Please consider my bid and let me discuss with the requirement.
Thanks
Prakash
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.
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 administration and maintenance with Linux/Unix and Windows Networking.