Microsoft Access APQP type database for Process Flow, FMEA, Control Plan, etc.

hansin

Starting to get Involved
#31
Absolutely. This would help generate ideas and aid others. This is how I have learnt databasing so far, by looking at others DBs and learning how they have developed functionality etc....
I want to get it and learn how to creat a apqp database,but i am poor in access!
 
Elsmar Forum Sponsor
M

Matt W - 2009

#32
I have been working on a stripped down version of my database for some time now as I've left my previous company and in my current role I personally have no use for it now. So as such I felt it would be better to share it than just leave it to gather dust so to speak. However with work commitments etc this is a very low priority for me, watch this space as I will post it at some point in the future - although what timescale this may be I've got no idea!
 

Manix

Get Involved!!!
Trusted Information Resource
#33
I have been working on a stripped down version of my database for some time now as I've left my previous company and in my current role I personally have no use for it now. So as such I felt it would be better to share it than just leave it to gather dust so to speak. However with work commitments etc this is a very low priority for me, watch this space as I will post it at some point in the future - although what timescale this may be I've got no idea!
Thanks Matt, that would be great if you can share it. We look forward to seeing it sometime in the future! :)
 
P

processanalyzer

#34
I was lucky enough to sit in on a demonstration of software that is being developed that uses Microsoft office, the access and excell, and if you think this stuff has no power you are missing the most incredible thing you will ever see. It is equal to minitab in every way and might have more capabilities. If I may say, the company is Dbar-innovations, look in the www. call them and get a demo, it is worth it if for any other reason to see what they did with a cheap little Microsoft package.
 
A

Amouchicou

#35
If you can develop with VB in access, then there is little limitation to what you can't do. The big question is: is it worth it??? buying software vs. create your own tool.
 

Manix

Get Involved!!!
Trusted Information Resource
#36
If you can develop with VB in access, then there is little limitation to what you can't do. The big question is: is it worth it??? buying software vs. create your own tool.
Yes a balancing act indeed. But think of it this way: Buying "off the shelf" means less development resource, but does mean (unless you are very lucky!) adjusting your processes and procedures to suit the software. Which means HR resource in terms of physically implementing the require changes and holding the changes in terms of training etc....

A self-developed kit can be tailored to how you actually do this. However of course this consumes more resource on the development front. However, it is dangerous game in terms of just replicating what you currently do, this may not be the best way to do it!!! An established off the shelf option may include best practice!!!

Like I say a balancing act, especially in terms of APQP, that is supposed to be a standardised approach to product realisation anyway!!!? :bonk:
 
M

mcward316

#37
Matt W / Manix, did you ever come up with something worth posting? I think it would be extremely valuable. Thanks.
 
M

mcward316

#39
Re: Microsoft Access - APQP type database for process flow, fmea, control plan, etc.

Hi Jennifer, thanks for your interest. Sorry, nothing yet, as I have been pulled away on other things! I am still rounding off the Concern Database (NCM, Cust Complaints, Cust Rtns & Audit findings) and will try and publish some output from that in the near future.

I will produce an APQP type database and I PROMISE to publish some of my ideas here. Watch this space. You never know, you may have just spurred me on to get on with it!!!!
Manix? How is your progress going?
 

Manix

Get Involved!!!
Trusted Information Resource
#40
Re: Microsoft Access - APQP type database for process flow, fmea, control plan, etc.

Manix? How is your progress going?
Hi and Welcome to the cove.

I do have a Quality Concern Database that includes customer concerns, NCMs, corrective actions, supplier performance etc... but I cannot post anything here without significant work in neutralising it and scaling it down. Also I don't think it is the best developed piece of kit as it's kind of grown organically. It is very cumbersome in terms of structure, I am sure a "real" programmer would probably have a heart attack if they saw it!!

In terms of APQP elements, I am no further forward. It is still an area of interest for me to develop, as learning lessons from precious projects is important to us, so the FMEA element is critical to enable this.

If you are more specific on what you want ot get from such a tool, I may be able to offer you snippets on how we have tackled it using Access. We have recently moved to Access 2010 which is much "nicer" to use and develop than previous versions, though all my best work resides in 2003.

Happy to help with anything specific you need help with :) Let me know.
 
Thread starter Similar threads Forum Replies Date
I How to build a Microsoft Access MDB Database for Document Control Document Control Systems, Procedures, Forms and Templates 6
T Microsoft Access Database to create a Simple Calibration Certificate General Measurement Device and Calibration Topics 6
P Creating a Traceability Database with Microsoft Access Document Control Systems, Procedures, Forms and Templates 7
C Microsoft Access Database for In-Process Run Charts Quality Assurance and Compliance Software Tools and Solutions 4
J Microsoft Access Integrated Database Question - PPAP Module Software Quality Assurance 13
J Help with Microsoft Access ODBC Database Query Criteria Misc. Quality Assurance and Business Systems Related Topics 35
J Microsoft Smart Art Turtle Diagram Process Maps, Process Mapping and Turtle Diagrams 9
M Informational Microsoft Built a Bot to Match Patients to Clinical Trials Medical Device and FDA Regulations and Standards News 0
J Microsoft Teams to manage Internal Audit System? Internal Auditing 3
D Microsoft Excel database to Stand-alone software Calibration and Metrology Software and Hardware 3
QSM_Rick Controlling Multi-Tab Microsoft Excel Forms Excel .xls Spreadsheet Templates and Tools 5
A Free software similar to Microsoft Project - Any suggestion? APQP and PPAP 5
Marc ASQ Linkedin Group - Microsoft Sharepoint discussion - June 2017 Quality Assurance and Compliance Software Tools and Solutions 0
Marc Microsoft to rip up P2P Skype, killing native Mac, Linux native apps World News 0
Marc Microsoft just bought LinkedIn For $196/Share World News 9
M Active X and latest update from Microsoft - Dec 2014 After Work and Weekend Discussion Topics 4
N Microsoft Word - How to make high-light go away after text is put in Excel .xls Spreadsheet Templates and Tools 5
B How to validate Microsoft Excel Spreadsheet Calculations for the Cpk value Capability, Accuracy and Stability - Processes, Machines, etc. 9
O Chi Square Normality Test using Microsoft Excel Excel .xls Spreadsheet Templates and Tools 2
insect warfare IRS pays Microsoft for Windows XP support After Work and Weekend Discussion Topics 2
Marc Microsoft to push out XP patch on March Patch Tuesday - 2014 After Work and Weekend Discussion Topics 19
V Alternative to Microsoft Office - Open Office vs. Google Docs After Work and Weekend Discussion Topics 26
Jim Wynne Have you tried Microsoft Windows 8? After Work and Weekend Discussion Topics 25
AnaMariaVR2 Guide to Microsoft Excel for Calculations, Statistics, and Plotting Data Excel .xls Spreadsheet Templates and Tools 11
M Microsoft Excel - Trouble with Auto-Entry of Dates Excel .xls Spreadsheet Templates and Tools 13
H 4.2.3 Document Control using Microsoft Sharepoint - Visibility of Draft Documents ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
L 21 CFR Part 11 Requirements - Microsoft Excel Add-on Functions 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 6
Q Looking for Microsoft Dynamics AX Training Videos for Inspection Journals Manufacturing and Related Processes 1
J Conditional Formatting for Microsoft Excel Excel .xls Spreadsheet Templates and Tools 2
Colin Changing the Colour of a Date in Microsoft Excel Excel .xls Spreadsheet Templates and Tools 4
X Microsoft Excel 2003 Formula Restrictions Excel .xls Spreadsheet Templates and Tools 9
michellemmm Pagination in Microsoft Word Documents Document Control Systems, Procedures, Forms and Templates 21
H AS9101D Microsoft Word Format: Worth It? AS9100, IAQG 9100, Nadcap and related Aerospace Standards and Requirements 2
Marc Microsoft Losing Big To Apple On Campus After Work and Weekend Discussion Topics 18
P Magic with Microsoft (things that could not be explained) Funny Stuff - Jokes and Humour 8
Marc Apple Dethrones Microsoft As World's Biggest Tech Company After Work and Weekend Discussion Topics 6
E Signature of Records - Microsoft Word forms Records and Data - Quality, Legal and Other Evidence 7
Claes Gefvenberg Microsoft Windows users: Which windows version are you using? March - April 2010 After Work and Weekend Discussion Topics 37
S Microsoft OneNote - Is anyone using Microsoft OneNote Quality Assurance and Compliance Software Tools and Solutions 13
D Microsoft Word problems Document Control Systems, Procedures, Forms and Templates 11
M Microsoft Sharepoint as Document Control Software - FDA Validation Requirements Document Control Systems, Procedures, Forms and Templates 15
Marc The Hidden Cost of Using Microsoft Software After Work and Weekend Discussion Topics 14
Stijloor Microsoft's Ballmer: Windows 7 is nearly final After Work and Weekend Discussion Topics 13
Coury Ferguson Bill Gates to step down from Microsoft After Work and Weekend Discussion Topics 8
A Fullscope with Microsoft AX ERP System Manufacturing and Related Processes 1
B UK standards body taken to court over OOXML (Microsoft's Open office XML) Other ISO and International Standards and European Regulations 6
GStough Microsoft InfoPath - Anyone Ever Used This? Document Control Systems, Procedures, Forms and Templates 7
Stijloor Microsoft Offers to Buy Yahoo for $44.6 Billion World News 3
L Pareto question Microsoft Excel Excel .xls Spreadsheet Templates and Tools 6
Jim Wynne Vista Deathwatch - Is the new Microsoft OS down for the count? World News 30
Similar threads


















































Top Bottom