Access Database for Root Cause Analysis

Completado Publicado hace 6 años Pagado a la entrega
Completado Pagado a la entrega

I need a data base set up for storing data acquired during a root cause analysis.

I personally have some data base experience, and could build this myself, but I would like somebody else to create it. My company Interfor. We are a lumber manufacturer, web site: [login to view URL]

I would like the color themes to be similar to the web site. I understand communication of expectations are very important for this project, so person hired for this project needs to be flexible as I want to make this perfect. This job can land multiple projects with me, as I have several other data bases that I want to incorporate in one place. Currently we use MS Excel to perform functions of data collection where a data base is more suitable.

Attached are:

(1) Sample RCA form currently used.

The purpose of this data base will be to allow users to:

(1) Allow users to fill in data per attached excel spread sheet

(2) We need a field called "Root Cause Types" to relate each Root Cause to

(3) Be able to perform quires for the following:

1. Summary of all Corrective Actions not complete

2. Chart that shows percentage of RCAs per Equipment

3. RCA Type Report (how many of each and percentage of type vs grand total)

I would like the home screen to look like a webpage, that has a navigation bar on top. With the following buttons:

Home - Takes users to home screen

Edit - Allows users to find RCA and edit data

New - Allows user to enter data from below

Reports - Be able to perform above quieres

On the rest of the page, I would like some key performance indicators

Number of Current Outstanding Corrective Actions

Number of RCAs performed to date

And 2 pie charts that show RCA Type percentages, and RCA vs Mill. I have a quickly sketched up drawing of this below.

If you are familiar with RCA process this will be much easier. The following milestones will be created

20% Initial Draft of Database for review.

40% Second Draft of Database reviewed (2nd verification of changes from 1st draft)

40% Final Approval, delievery of completed data base.

Due date will be 30 days..firm

Administración de bases de datos Programación de bases de datos Excel Microsoft Access

Nº del proyecto: #15922579

Sobre el proyecto

5 propuestas Proyecto remoto Activo hace 6 años

Adjudicado a:

alaeddindhahri

Hi, I'm a professional Databases developer. I have read your project description and I'd like to help you get this app done. I have checked the attached homepage sample and we can build on that Relevant Skills and Exp Más

$555 USD en 10 días
(73 comentarios)
5.9

5 freelancers están ofertando un promedio de $525 por este trabajo

schoudhary1553

Greeting, I have understood your Access Database for Root Cause Analysis task and can do it with your 100% satisfaction. Please ping me for more discussion. Relevant Skills and Experience I have more than 5 years of Más

$555 USD en 10 días
(310 comentarios)
7.9
WebInfoSolutions

I think you want to get this done using MS Access. right? Can you share the excel workbook? Relevant Skills and Experience VBA dev Proposed Milestones $736 USD - on end

$736 USD en 15 días
(27 comentarios)
6.4
sherifamgadnabih

i am a lead .NET software engineer Relevant Skills and Experience i am a lead .NET software engineer and responsible for creating a web and desktop applications using different languages and technologies Proposed Mil Más

$500 USD en 10 días
(10 comentarios)
4.4