FMEA and Risk assessment in Microsoft Access
- Thread starter QMS Auditor
- Start date
QMS Auditor
Registered
The department Manager prefer MS ACCESS.
QMS Auditor
Registered
any help???
pleaaaase
pleaaaase
Tagin
Trusted Information Resource
Not supported?
- MS Access 2013 - end of support is 2023
- MS Access 2016/2019 - end of support is 2025
- MS Access is part of Office 365
As to whether it is a good product or not, the Access I knew was indeed clunky and rather primitive.
Agent Smith
Registered
'Clunky' is a polite adjective to use for MS Access. My experience with it has been that it is severely limited in terms of how many different users can be writing to/reading from it... it has some security issues, and that Access databases are prone to corruption. It's also a PITA to try to do meaningful data analysis from data in an Access database. Things like 'CNTRL-F' work, but those work in a MS Word document too.
Most of the folks I've worked with who advocate MS Access have a mental model of it as a 'better collection of spreadsheets', yet they can't make the mental leap to a true relational database, like MS SQL.
If the effort is a FMEA... this is one of the obvious applications where a relational database is the better choice. It is very likely that items like 'Severities' and 'Risk Controls' will be repeated for different 'lines of analysis'... a relational database allows for easy discovery/review/modification of repeated elements without having to do a line-by-line review of every Access database entry. My intent is not to diminish the efforts and capabilities of 'Access Wizards', its just that there exist better tools that are both more powerful and less prone to the difficulties of Access.
Most of the folks I've worked with who advocate MS Access have a mental model of it as a 'better collection of spreadsheets', yet they can't make the mental leap to a true relational database, like MS SQL.
If the effort is a FMEA... this is one of the obvious applications where a relational database is the better choice. It is very likely that items like 'Severities' and 'Risk Controls' will be repeated for different 'lines of analysis'... a relational database allows for easy discovery/review/modification of repeated elements without having to do a line-by-line review of every Access database entry. My intent is not to diminish the efforts and capabilities of 'Access Wizards', its just that there exist better tools that are both more powerful and less prone to the difficulties of Access.
