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

M

Matt W - 2009

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

Now I have to confess that I’m not an active user of these forums, but I came across this thread some time ago when researching using Access to create an APQP database and having revisited it since then and seeing the most recent post on the subject I thought I'd register on the forum to share my experiences.

From the outset as I should make it clear that I’m not an Access programmer, or for that matter have any kind of formal Access training, I’m a Project Manager for an engineering business and I’m not posting this to sell my database (or give it away for that matter!). But simply to answer Manix's question, yes, it is possible to use Access as a database for APQP/PPAP/Project Management and do so very successfully.

About 3 years ago the company I work for was working towards Q1 accreditation, the big problem was how we controlled and managed our PPAP process, due mainly to the large number of components and suppliers involved. It was decided that a database needed and I was tasked with selecting a suitable one for the business. During the course of my research I found that the majority of products on the market just weren't suitable for my needs, they either cost too much, or they had dozens of features I didn't need and none of the ones I did, they didn't work the way I wanted them to or were just plain too complicated. So the decision was taken that we should develop our own database and being the person with the most knowledge of Access I was given the task.

The database initially took about 2 weeks to develop from scratch, it wasn’t perfect by any means, but it was a good start and it has continued to develop over time and it’s now a very solid and reliable database, even in a multi-user environment. The database covers the following aspects of the APQP/PPAP process (not an exhaustive list); Bill of Materials, PPAP and IMDS status of child parts (including an annual revalidation timetable), Process Flow, Control Plans (linked to the Process Flow), PFMEA (again linked to the Process Flow), OEE and the PSW front sheet. The likes of the OEE and PSW can be exported to Excel spreadsheets, as many customers want these documents in their own Excel format rather than using the standard AIAG ones.

Admittedly not being an Access programmer the database may not be written as an expert would do it, but being an engineer and understanding how the various bit of information are used is a great advantage and allows a greater degree of freedom. I feel the main benefit though of developing your own database is the flexibility it gives you of being able to tailor a database to the way your business works. I’ve attached a couple of screenshots for information.
 

Attachments

Elsmar Forum Sponsor

Manix

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

Thanks Matt W and welcome to the cove. I am glad my post prompted you to register and share your exeprience. Your DB looks very, VERY similar to the sort thing I would like to acheive. You seem to be in the same position I am currently, Projects Manager looking for a way to stream line our APQP projects. I too am not an Access programmer but I have learnt quite a bit over the last year or so and have produced a Tooling Database, a Material Reporting Portal (to monitor and record IMDS and RoHS compliance of all of our products) and I am also currently working on a Customer Complaints, Non-Conformance and Customer Return database, all using Access.

I agree that whenever I start work on these sorts of projects, I find that current commercially available packages just don't do what I want them too and/or are overkill and thus overpriced!

Your input and screenshots have given me some good ideas as to how I maybe able to acheive a more streamlined and organised approach to managing data.

I will endeavour to try and develop something, though 2 weeks is an optimistic target, I will post my experiences here!
 

Jen Kirley

Quality and Auditing Expert
Staff member
Admin
#23
Re: Microsoft Access - APQP type database for process flow, fmea, control plan, etc.

How is this going, Manix? I am also very interested in such a tool. I regret to say I am a noob with Access and VB, thus no help in designing such a database database.
 

Manix

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

How is this going, Manix? I am also very interested in such a tool. I regret to say I am a noob with Access and VB, thus no help in designing such a database database.
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!!!!
 
J

jacko

#25
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!!!!
Any luck with that yet? I wish I had time to develop something like that. Your screenshots look good to me.
 

Manix

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

Any luck with that yet? I wish I had time to develop something like that. Your screenshots look good to me.
Sorry not as yet. I have been very busy with other things over the last few months. I will of course try to keep this thread upto date with any updates I do have.
 
D

dyfhid

#27
> Material Reporting Portal (to monitor and record IMDS and RoHS compliance of all of our products)

I have been assigned the task of writing a RoHS Database for my firm, a marine electronics manufacturer. I have written several datasbe and digital dashboards for the company thus far. I am the Supplier Quality Tech, and have been maintaining the RoHS Certs received from Suppliers as part of the First Article Process. With the changes coming down the pike for RoHS and WEEE my boss has decided that I should be electronically maintaining the RoHS documentation.

We are also implenting a requirement of component level test results for RoHS, and I need to include that. We are in the process of scanning all teh paper certs we have received thus far and I am thinking that the database should include links to the scans, at a minimum, but I was looking for other folks who may have already gotten such a thing done to look for ideas, when I came across teh revival of this thread, and the mention quoted above of the Material Reporting Portal.

I wonder if it is possible to post screenshots to glean ideas from?
 

hansin

Starting to get Involved
#28
Re: Microsoft Access - APQP type database for process flow, fmea, control plan, etc.

Now I have to confess that I’m not an active user of these forums, but I came across this thread some time ago when researching using Access to create an APQP database and having revisited it since then and seeing the most recent post on the subject I thought I'd register on the forum to share my experiences....
Can i share with it?
 

Marc

Hunkered Down for the Duration
Staff member
Admin
#29
Assuming they are stripped of company specific markings and information, those of you who have a database you are willing to share -- It will be VERY much apreciated!

Marc
 

Manix

Get Involved!!!
Trusted Information Resource
#30
Assuming they are stripped of company specific markings and information, those of you who have a database you are willing to share -- It will be VERY much apreciated!

Marc
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....
 
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