Develop an Inspection Management System
$750-1500 USD
Pagado a la entrega
I need to develop a microsoft access database for an offshore compliance company. The database will need to function as a standalone program that will be used by several levels of clearance. Users must be able to log into the system which will determine what data/forms/reports that user will have access to. I have already begun development but am unable to press forward due to prior commitments. In general most of the tables and relationships are already estabished but may need adjusting to achieve desired functionality.
The data consists of: Clients, Operators, Platforms, Inspections, Inspection Types, and Employees. I have attached a preliminary cardinality diagram that can be referenced to understand the data relationships.
The system needs to be highly intuitive for the end user. I will require documentation of the database as well.
The database need to be HIGHLY INTUITIVE for the end user. The end product should appear to be a standalone program to the end user (EU). Interface needs to be dynamically compatible with any screen size as well as function on Windows 7, 8.1 and 10. Front end/back end to be developed in MS Access 2010. Upon finalizing the design, the system will be split and the bBackend will be stored on a server or else SQL so that multiple EU's can manipulate data. The front end will remain microsoft access and will be handled on each machine using access runtimes. At the inspector level, the program will be run on tablets so all interface needs to be touch screen compatible. Swipe guestures would be a nice touch but ensure that system works without touch screen as well.
Preliminary list of items that will need to be developed:
1. The system needs to be a secure, multi-user platform with varying levels of clearance. (Administrator, Accounting & Financial, Human Resources, reporting, staff, contractor).
a. ability to adjust which clearance levels have access to what items.
b. ability to change levels of clearance within the employees table. This needs to be something that the administrator level can determine/update.
2. There will need to be a login screen that upon successful login the system determines clearance of user. I currently have a username/password associated to each employee along with level of clearance. This system would need to be further secured/developed. This needs to be database specfic and not based on the user profile of the users computer.
3. Develop highly intuitive forms for adding/editing Clients, Operators, Platforms, Employees, and Inspections.
4. When adding a client, the EU needs to be able to select assoicated operators as well as platforms.
5. There are many types of inspections as well as inspections categories that may be performed. This needs to be a cascading system in which the EU is able to select an inspection type, and then sub type from a narrowed down list. The types/sub types need to be easily added/edited by me/end user and stored in tables. No complicated code that results in difficult changing/updating of inspection information.
6. Ability to add new inspection types easily and they need to become options once the new table is added.
7. Colors/styles need to be assigned using themes so that I can manipulate them easily based on final company identity.
8. Full documentation will also need to be provided upon approval of completion of the database.
9. All code and otherwise becomes the sole property of myself. If code is used that is not public realm/free notify me immediately.
10. Inspectors will not have access to an internet connection so a sync function will need to be developed. The sync function should be able to identify changes/additions to inspection data and upload to the backend when activated.
11. Need to be able to search for inspections by information such as client, platform, operator, and platform owner.
12. Report based on specifc inspection.
13. Trends reports. Need to be able to see which regulations are broken most based on specific platform, operator, or client within a specified time frame. (1 report for each and a dialog to specify this information)
14. Archive function that can be activated and archive information on a yearly basis (inspection data only).
Milestones:
1. Database Functionallity. Developer to submit database in a fully functioning form. I need to be able to test all functionality. Any further refinements must be completed before moving onto the next stage. Repeat until satisfactory.
2. User Interface Completion. Developer to submit database in a fully refined highly intuitive form. Any further refinements must be completed before moving onto the next stage. Repeat until satisfactory.
3. Documentation. Developer to submit full documentation of the program. Any further refinements must be completed before moving onto the next stage. Repeat until satisfactory.
*** Correction: Database to be developed using Microsoft Access 2013.
I have not set a hard deadline, but I would like to have work completed within a month. Also I would like bi-weekly updates.
Nº del proyecto: #7170112
Sobre el proyecto
19 freelancers están ofertando un promedio de $1165 por este trabajo
Hi, I have +7 year experience in MS Access Development. Also have work in sharepoint. Thanks & Regars
Hi, i am fulltime freelancer and i am very very familiar in Microsoft Access database. Database programming is my expert and i really like this kind of programming. According to your requirement, it's not very difficul Más
Understand you need Access 2010/ 2013 based offline solution with multiuser facility with access restrictions. At Freelancer I have completed the contests with such facility. I shall provide a working manual. About Más
We can create this sytem for you at very low cost as we have a team of experienced designers and developers. We want long term relation with you that's why working at very good prices. Hope you will give us a chance to Más
I have seen your database, is well formed and normalized, but I'm a Microsoft Partner from many years and think that the best solution is to develop a windows desktop application. I suggest to convert your database to Más