Develop an Inspection Management System

Cancelado Publicado Feb 19, 2015 Pagado a la entrega
Cancelado 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.

Microsoft Access Sharepoint SQL

Nº del proyecto: #7170112

Sobre el proyecto

19 propuestas Proyecto remoto Activo Feb 20, 2015

19 freelancers están ofertando un promedio de $1165 por este trabajo

torajiv

Hello I am an exclusive MS Access developer completely dedicated to this platform - I do not work on any other database. I am also among the top three MS Access developers on this site. You can verify by go Más

$800 USD en 20 días
(154 comentarios)
6.8
qitsol

A proposal has not yet been provided

$1184 USD en 20 días
(32 comentarios)
6.3
jeanek

Good Day, I would like to express my interest in your project. I am a holder of a BSc. Computing degree from the University of Greenwich (UK) and have over 8 years professional work experience in the IT industry Más

$750 USD en 20 días
(5 comentarios)
4.9
swarm22

Hi, I have +7 year experience in MS Access Development. Also have work in sharepoint. Thanks & Regars

$1250 USD en 20 días
(6 comentarios)
2.9
pegasus9529

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

$1200 USD en 14 días
(1 comentario)
3.2
tandonshailendra

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

$750 USD en 20 días
(4 comentarios)
2.4
eplanetsoftindia

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

$750 USD en 20 días
(2 comentarios)
1.1
grahamcollinwood

A proposal has not yet been provided

$1250 USD en 20 días
(0 comentarios)
0.0
sha2014man

Предложение еще не подано

$833 USD en 21 días
(0 comentarios)
0.0
girofreelancer

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

$1500 USD en 30 días
(0 comentarios)
0.0
ahmedmostafat

A proposal has not yet been provided

$1250 USD en 20 días
(0 comentarios)
0.0