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

A

AJLenarz

#1
I have only recently got my feet wet in Microsoft Access. I am blown away with its capabilities and relatively user-friendly abilities. I am looking at possibly creating a APQP type d-base (process flow, fmea, control plan, ect…).

Does anybody else have something similar out there that I could look at and get some ideas? Any assistance would be appreciated.

Thanks.
 
Elsmar Forum Sponsor

Marc

Hunkered Down for the Duration
Staff member
Admin
#2
I haven't personally seen anything that complex done in Access but I don't get out much. There is a lot you can do though. How about it folks - anyone seen anything this complex in Access?
 
A

Al Dyer

#3
I've never used, or tried to design, an access database for the entire APQP process although I previously designed and used one for specifically for the PPAP end of APQP.

We now use a canned program for the entire APQP process that is somewhat flexible in allowing us to redefine fields and checklists.

Access is good, but it does have its limitations.

ASD...
 
W

wes wiszniewski

#4
Fmea and Control plans

Integrating Fmea and Control plans into Access aplication is a great idea. I would also like to see adding process map if possible and make part numbers specific. There was software by Software Realities named Sorge Quality System which integrated all these and lot more but is not available anymore.
 

Howard Atkins

Forum Administrator
Staff member
Admin
#5
There is a packaged software that uses does all this on an Access framework.
They give you a runtime version
We have had discussions in the past about PPAP and APQP software

Search for software in the PPAP/APQP forum to see discussions on commercial applications etc.
In general the cost of developing a good implementation can be higher that the cost of purchasing.
It depends what you need.
 
#6
I created an Access relational database for FMEA from scratch. That way you can put the features in you want and leave out the ones you don't need. Anybody with a passing knowledge of Basic programming can get this done. You can database image files, documents, numbers, entries, whatever your programming skills and experience will allow. I do it myself because I enjoy it, the canned programs generally do more than I want but not what I want, and they are too expensive for what you get.

I also have an Excel Spreadsheet that another friendly Supplier of the Customer gave me. It has the whole PPAP, APQP, etc. in one file with multiple sheets. You start at sheet one with Customer Name and as you fill it in it puts the relevant info on the right forms in the right places. I believe the Original came from AIAG.
 

Howard Atkins

Forum Administrator
Staff member
Admin
#7
There is a DELPHI version of the excel sheet as an attachement at the cove.
Does your version have a relationahip between the flow chart, CP and FMEA, this is the real problem to maintain this unity.
 
#8
Sorta

The Access database is a nifty tool for keeping all of your FMEAs in one place, updating, adding and printing. No connection to Flow or Control Plan.

The Excel connects flow to FMEA to CP but only in a rudimentary way with the title blocks. It does not connect the flow boxes to FMEA potentials to Control Plan control items.

Wouldn't it be really cool to have a big open source Access APQP database developed here at the Cove. Oh, it gives me a headache just thinking about it.
 

Marc

Hunkered Down for the Duration
Staff member
Admin
#9
I would LOVE to see an open source solution, but I'd prefer it in MySQL or PostgreSQL rather than Access.
 
N

nickh - 2011

#10
I have seen a number of Access developed FMEA products on the market, but none that are open source. Having developed a number of Access databases in the past, I would offer the following advice:

1. You're probably better off not attempting to integrate process flow charting directly into the database. A more workable solution is to allow the user to upload a flow chart created in another application and have the Access database store it in a controlled directory and just display a link to the file. (Off topic: My preference is to do the flow charts in Excel, since not everyone has Visio, RFFlow, Smartdraw, etc.).

2. Expect problems if the database grows large. I've created some that started with small user bases that eventually grew to several hundred people. There's a reason that Microsoft recommends using it for only a small number of concurrent users (5-10). A pet project can turn into a babysitting headache. This is the kind of situation that gives Access a bad name. It's perfect for small groups, but beyond that it just doesn't scale well.

3. Learn to design disconnected forms. By that I mean that the data in the forms is not live. I think Access calls them "bound" fields when they are connected directly to the data source. Using bound forms can lead to a lot of concurrency issues (two or more users trying to access the same data at the same time). By default, the forms wizards create bound forms, so it is more of a hassle to create disconnected ones.

4. Run the compact / repair indexes at least once a week and even more frequently if the database grows large.
 
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