Access Database for Root Cause Analysis

Completed Posted 6 years ago Paid on delivery
Completed Paid on delivery

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

Database Administration Database Programming Excel Microsoft Access

Project ID: #15922579

About the project

5 proposals Remote project Active 6 years ago

Awarded to:

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 More

$555 USD in 10 days
(73 Reviews)
5.9

5 freelancers are bidding on average $525 for this job

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 More

$555 USD in 10 days
(310 Reviews)
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 in 15 days
(27 Reviews)
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 More

$500 USD in 10 days
(10 Reviews)
4.4