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

Joe Cruse

Mopar or No Car
#11
This would be a nice project to work on, but I tend to agree with Marc and nickh that MySQL would be a more appropriate platform, at least for the Back End of the project. Might do a MySQL back end and craft an MS Access front end for the data entry and bells and whistles. There are too many folks out there that would have enough data entry to overload Access.

I would also tend to agree on linking to other applications for stuff like charts, as MS Access chart capabilities are not all that great. It tends to be more limiting than Excel, even though they use the same application for charts. Just harder to deal with in Access.

We are a smaller company, and Access has worked great for relational database work for us, including a LIMS, safety records, and quality records. We had, to this point, only captured CA/PA activity in our setup, but I'm transferring all our customer complaint, raw material nonconforming, in-process nonconforming, and customer complaints into this system. Internal audits are next, once I get my changes to a process-based audit style in place.

I'd love to learn MySQL and VB, bt there's not enough time in the day.
 
Elsmar Forum Sponsor
N

nickh - 2011

#12
Someone will need to double check this if they're interested, but I don't think that MySQL natively supports transactions yet. I believe that you need to use InnoDb tables to do this. Last I checked using InnoDb required a $$ license. I've only used MySQL for personal projects - several years back - so I'm no authority on it. If you're going to develop a database system to support quality systems, I think that you'd definitely want to use a system that supported transactions.

Also, if you're using Access, I assume that you're an MS shop. PostgresQL (which does natively support transactions) nows will run on Windows as of their 8.0 release.
 
P

pampas2

#13
The closest I've come is to develop and ECN tracking and input system and a Corrective Action Report database in Access. I'd be glad to purge the records and send you a sample if you are interested.

Paul
 
T

tracy5000

#15
Paul,

I'd be interested in a purged version of your database - I'm getting ready to start trying some similiar type stuff for auditing stuff
 
J

jacko

#17
any version

I would like to get any version of some PPAP software. Can anyone help me with this?
 

Manix

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

This thread seems to have evolved over the last 6 years, and is the only one I can find when talking about using Access as a tool for integrating APQP activities and documentation.

I am looking to implement a similar system, I am calling it the "Project Portal". This will allow me to record all Project specific data ONCE, and use this data for numerous activities and documentation.

I currently find that there are so many separate requirements and forms etc.... that I am replicating so much data, and jumping around between Word, Excel, Form to Form, checklist to checklist.

We are a small organisation and on the APQP and Project Management side of things I am the main man. Maybe one or two others may also be involved, but the database will probably not used by many users at all.

My main question I put to you all is, has anyone used Access on any element of the APQP/PPAP/Project Management side of things? If so is anyone prepared to share their experiences, tools, tips and techniques?

I am interested to know if there are any more Canned products out there, but really, given the size of our operation, these are not always viable, and simply create yet another bit of software/location in which to store data! I want something that will help minimise the duplication of effort, and effectively mould to the way we work.

Input always appreciated......I hope this thread does not get lost in the ether, just didn't want to start a new one as this thread is just a perfect place to discuss (or continue to discuss as it were).
 
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