Access Database for Root Cause Analysis
$250-750 USD
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
Project ID: #15922579
About the project
Awarded to:
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
5 freelancers are bidding on average $525 for this job
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
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
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