Suoritettu

Access Database for Root Cause Analysis

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

Taidot: Tietokannan hallinto, Tietokantaohjelmointi, Excel, Microsoft Access

Näytä lisää: root cause analysis, i need data entry done today, i need data entry cv, php, css, html, javascript, database administration, database programming, microsoft excel, what is root cause analysis, rca root cause analysis, i need data entry projects, jobs i need data entry, i need data entry work, i need data entry work to be done, i need data entry projects in uae, i need data entry operators, law firm access database, bmc remedy itsm root cause analysis email engine

Tietoa työnantajasta:
( 13 arvostelua ) Sequim, United States

Projektin tunnus: #15922579

Myönnetty käyttäjälle:

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 Lisää

$555 USD 10 päivässä
(68 Arvostelua)
5.8

6 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

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 Lisää

$555 USD 10 päivässä
(268 arvostelua)
7.6
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 15 päivässä
(24 arvostelua)
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 Lisää

$500 USD 10 päivässä
(10 arvostelua)
4.4
yangdev

Hi there, how are you? I read your job details carefully and checked attached sketh design. I 'm strong at db administration, and db programming, also frontend is one of my mainstrength. Let's talk. Relevant Skills an Lisää

$555 USD 10 päivässä
(1 arvostelu)
0.8
$277 USD 7 päivässä
(1 arvostelu)
0.1