engleski

Microsoft Access database management of laboratory accreditation

Laboratory accreditation management is a complex task producing many documents that need to be well and systematically organized. We build a system organized through several Microsoft Access database applications that produce, organize or simply manage different types of accreditation documents. Frontend applications are available on every laboratory computer and access permissions are defined through login system. The database data are located on central file share server. Document hierarchy and managing are performed trough searchable Documents database that keeps all documents organized by types, accreditation fields, and laboratory organizational units. Every document in a database is easily accessible through Intranet access.Laboratory equipment is organized through another application database that enables managing of every laboratory part of equipment, including planning of periodically equipment calibration. Laboratory tests data are managed through Database of measurement procedures, which also serves for reporting of yearly test reevaluations and is a data serving application for laboratory web pages for Internet available test catalog. Laboratory personnel is managed through database which contains possibilities of yearly appraisement for every employee, managing education, personnel test performance skills and equipment training. Nonconformities and maintenance of laboratory equipment are managed through another database which replaces the need for paper form evidence for almost any type of information that needs to be collected on daily or periodically basis. Paper forms and paper documents are drastically reduced after 5 years of implementing such informational system. Retrieving the statistical report for almost any type of collected data is performed by a button click.

Accreditation; LIS; MS database

nije evidentirano