SBS - The best value in QMS software

Developing an Access ECO Tracking Database - Need help

L

LisaWeiss

#1
Hi, I came across this site while doing research on ECO databases. I have been tasked with creating one in Access (2003) for my company. We are a small R&D company and everything is manual. I was wondering if anyone had a sample database I could use? Any help would be appreciated.

Regards,

Lisa
 
Elsmar Forum Sponsor

Stijloor

Staff member
Super Moderator
#2
Re: Need help with developing Access ECO Tracking Database

Can someone help Lisa?

Thank you!!

Stijloor.
 

Wes Bucey

Quite Involved in Discussions
#3
Re: Need help with developing Access ECO Tracking Database

Hi, I came across this site while doing research on ECO databases. I have been tasked with creating one in Access (2003) for my company. We are a small R&D company and everything is manual. I was wondering if anyone had a sample database I could use? Any help would be appreciated.

Regards,

Lisa
A lot depends on how expert you are in Access, but even more depends on what your organization has for an Engineering Change Order process and how willing they are to populate the fields when creating and revising documents each time.

Depending on your budget, there are some software solutions (electronic data management) which use either Access or SQL as the database engine. If your document list will grow much to more than a few hundred documents, most folks find SQL is a more robust database engine than Access, but many folks stick to Access to avoid the learning curve for SQL.

Your organization's task is to determine BEFORE you begin just how many fields they want to have for potential queries and file sorting of original documents and the ECOs which trigger the revised versions of those documents. Frankly, I wouldn't consider trying to keep track of ONLY ECO's when, with a little extra effort, the organization can track ALL its documents.

:topic:
You may or may not have noticed this is the start of the Labor Day weekend and traffic here in the Cove traditionally drops off a lot on holiday weekends. If you don't get the answers you seek this weekend, come back Tuesday and add another post to this thread to bump it to the top of the recent post queue.
 
H

headhunter

#4
Re: Need help with developing Access ECO Tracking Database

Hi, I need similar database. If you found something I will be glad if you share it. If no ,I can try to make something.

EDIT: OK, because I'm new in my company, I didn't know that they don't use MS Access... Will be problem for you if it will be made in OpenOffice?
 
Last edited by a moderator:

Ninja

Looking for Reality
Staff member
Super Moderator
#5
You might also consider (unless forced to use a specific program) trying Filemaker Pro. The current version (11) comes with starter solutions, one of which is a document library which might go most of the way toward what you're trying to do.

I am not associated with Filemaker, but am a long time user and have been very pleased with it.
I use it to handle 10K's and 100K's of records and have seen no issue with capacity.
 

Wes Bucey

Quite Involved in Discussions
#6
You might also consider (unless forced to use a specific program) trying Filemaker Pro. The current version (11) comes with starter solutions, one of which is a document library which might go most of the way toward what you're trying to do.

I am not associated with Filemaker, but am a long time user and have been very pleased with it..
I use it to handle 10K's and 100K's of records and have seen no issue with capacity.
From what I gather in a quick perusal of the File Maker website, it DOES use the more robust SQL database engine.

Frankly, for a relatively miniscule $299, I don't think anybody could create a similarly robust Access program in man hours costing less than $300. I am [was?] pretty adept in Access and I'm pretty sure it would have taken me a lot longer than $300 of my time to make one, together with necessary documentation for someone to work it in my absence.

Note, this is NOT an endorsement of File Maker or any other specific brand of software, but it is an endorsement for buying off-the-shelf software unless you are an absolute database maven who also writes clear and concise documentation for others to use your program effectively.
 
T

True Position

#7
On this topic, Microsoft just started selling their own 'Microsoft Visual Studio Lightswitch 2011' which is designed to be a step up from Access type projects and simplify creating the types of application you're thinking about making. I've played around with it and it's fairly simple, if you understand databases enough to create something in access you'll probably create a much better more useful product with Lightswitch.

It's designed from the start to build a 2 or 3 tier application using a standard MS-SQL database. Also, it has very simple tools to run the server and database inside Microsoft Azure. (MS's competitor to Amazon ECC)
 

Ninja

Looking for Reality
Staff member
Super Moderator
#8
..., but it is an endorsement for buying off-the-shelf software unless you are an absolute database maven who also writes clear and concise documentation for others to use your program effectively.
Good point and I agree. I would hasten to emphasize/clarify my own post however...

The starter solution would get you most of the way. There would be some customizing to do. It's worth the head start, IMO, but it isn't a COTS ECO tracking Dbase solution...just a head start.

Customizing is easy...but that's my own perpective as said {closet} Dbase maven. Others could easily see it differently.
 
S

saravananpg

#9
Hi,

Have you developed the access dbase to store ECO implementation!
If so can you share me, I will take it as your valuable input.
Presently I am using Access dbase only for the ECO management within department.
 
Thread starter Similar threads Forum Replies Date
Q Storing and developing SAMD (Software as a Medical Device) in the Cloud IEC 62304 - Medical Device Software Life Cycle Processes 3
T Ideas for developing a Supplier Quality Management System, non automotive ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 5
J Quality Assurance in China - Developing a quality management system for a California company Misc. Quality Assurance and Business Systems Related Topics 9
D Co-developing a new medical device ISO 13485:2016 - Medical Device Quality Management Systems 2
S Root cause analysis - The system of developing a work instruction is not effective Problem Solving, Root Cause Fault and Failure Analysis 1
L Problems while documenting the SOUPs used for the software we are developing IEC 62304 - Medical Device Software Life Cycle Processes 4
A Developing a ISO 9001:2015 Internal Audit Plan and Schedule Internal Auditing 40
D Developing an Umbrella Management System Quality Management System (QMS) Manuals 2
R Developing procedure for Determining Company's Context And Interested Parties ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 53
Richard Regalado Sample Plan for Developing an ISO 22301 Business Continuity Management System (BCMS) Business Continuity & Resiliency Planning (BCRP) 3
D Developing a Supplier Risk Matrix Supplier Quality Assurance and other Supplier Issues 4
M Developing a new Plating Vendor - What software to track certifications Software Quality Assurance 2
T Need help developing an ECO (Engineering Change order) procedure Document Control Systems, Procedures, Forms and Templates 3
T Developing an AS9100 Internal Auditor Training Program AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 2
AnaMariaVR2 Developing Innovative Ideas for New Companies: free course Training - Internal, External, Online and Distance Learning 0
F Developing a Robust MSA Program - over 35,000 gages in 1 million square ft. facility Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 6
T Developing Reward Programs for Employees Quality Manager and Management Related Issues 4
H Identifying Potential Automotive Suppliers before Developing New Products Supplier Quality Assurance and other Supplier Issues 2
S Developing Documentation and Defining Processes as Subcontractor IATF 16949 - Automotive Quality Systems Standard 6
A Developing Technology and Equipment to Manufacture Clients Product - Can exclude 7.3? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 8
B Developing a Segment-Based Customer Service Benchmarking 6
B Developing a Queue Management Procedure - Need some help writing a Proposal Quality Manager and Management Related Issues 2
Sidney Vianna ISO 9001 - Its Relevance and Impact in Asian Developing Economies ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 0
R Developing a c = 0 Sampling Plan Inspection, Prints (Drawings), Testing, Sampling and Related Topics 3
AnaMariaVR2 Preparing for the RAC Examination -- Developing an RAC Study Plan Professional Certifications and Degrees 1
P Developing a Counterfeit Parts Prevention Program AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 8
L Developing a QMS Manual for AS9100 and ISO 9001 AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 20
Q Developing a Sampling Plan for a New Product Inspection, Prints (Drawings), Testing, Sampling and Related Topics 14
P Developing Performance Standards - ISO 14630:2008? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 10
P Developing a SOW for Entire Site Calibration Requirements General Measurement Device and Calibration Topics 3
J Developing Plans for Corrective Actions for Audit Non-Conformities ISO 13485:2016 - Medical Device Quality Management Systems 5
M Developing a Career Plan Career and Occupation Discussions 5
A Policy for Suppliers - Developing a Supplier Policy Document ISO 13485:2016 - Medical Device Quality Management Systems 3
M Developing your own personal "Body of Knowledge" document. Professional Certifications and Degrees 3
K Developing an TL 9000 Audit Checklist - Help required TL 9000 Telecommunications Standard and QuEST 2
E Developing the Essential Requirements Checklist - Identifying Requirements Other US Medical Device Regulations 3
N ISO 9001 and the HR Function - Developing a Total Quality Management System for HR ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 16
B ISO Clause Reference for Developing Common Customer Service Standards ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
M Developing a CPI for First Pass Yield Final Inspection - Need help Quality Tools, Improvement and Analysis 7
M Developing a Medical Device Audit Checklist 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 5
A Developing HR (Human Resources) Policies ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 1
A Developing a Position Grade for Employee Suggestions ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
B Developing In-House Calibration Capacities General Measurement Device and Calibration Topics 5
S Developing Petrochemical Company Processes - Help needed Process Maps, Process Mapping and Turtle Diagrams 1
S I need help in developing a Center of Excellence Misc. Quality Assurance and Business Systems Related Topics 5
D Input Requirement Document for developing Product Presentation by Multimedia Solution Document Control Systems, Procedures, Forms and Templates 2
T Developing the Risk Management Plan - Risk Management Policy and Objectives ISO 14971 - Medical Device Risk Management 25
O Developing a QMS for biomedical start up company which only does R&D? ISO 13485:2016 - Medical Device Quality Management Systems 5
Z Developing an ISO 13485 System - New Small Medical Device Company ISO 13485:2016 - Medical Device Quality Management Systems 11
F Developing a corporate GMP/Quality training program for temporary workers Training - Internal, External, Online and Distance Learning 1

Similar threads

Top Bottom