PDA upgraded a rapidly aging Microsoft Access database application for a heat treat lab. The application consisted of multiple access databases all used to collect specific criteria on testing and inspection from the clients’ personnel. The Access application provided a means for manual data collection, file/photo attachments, import features, calculations, and export features. The challenges with the system were the day-to-day administration and troubleshooting, limited security, lack of historical data querying, and inflexible to future enhancements.
The path that Process and Data Automation recommended was to upgrade the Microsoft Access application to a web-based application with a Microsoft SQL database backend. Moving to a system such as this would allow the client the ability to input data to the system from one common interface through multiple areas of the lab. This would allow the consolidation of extraneous databases into a Microsoft SQL database. Microsoft SQL is a far superior database tool for collection methods, archiving, and querying. When coupled with a web application, the client will have the ability to apply security levels restricting data and reporting access. The web application was developed to provide a powerful interface to the database for querying the data collected. The querying criteria included Part Number, Order Number, Project Type, and Lab Number that was filterable by this criteria and date. The client retained all the required functionality provided by the existing Access application with the new web application including importing, exporting, file/picture storage, etc. and gained functionalities that satisfied their wish list, along with the flexibility to add endless future enhancements.
HOW WE DID IT:
Process and Data Automation achieved this upgrade using our software development lifecycle. The software lifecycle identifies all aspects of developing new applications for a client. In this case, we were replicating an existing application and adding a plethora of enhancements. The following steps were taken to ensure the clients’ needs were met:
Aerospace company with more than 3,000 employees at approximately 12 production sites.
INDICATIONS CLIENT HAD NEED:
PROVIDED BY PDA:
PROJECT HARDWARE & SOFTWARE:
© 2020 Process and Data Automation, All Rights Reserved.