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.
(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
6 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
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