An example of Access Application Development includes this Production and Quality Recording System.
Technical Service Consultants Ltd (TSC), a clinical company and global supplier of swabs and microbial consumables based in Lancashire, United Kingdom (UK).
Since 30 years, TSC has been manufacturing high quality products in UK for use in pathology laboratories and applications across the world. Their product range is widely used in sample collection, transport identification and storage to obtain accurate results. They began their work in the clinical field with dry swab collection kits and Probact transport swab systems. Today, TSC possesses the most extensive range of swabs to meet requirements ranging from paediatric to large animals. The company takes keen interest in innovations and evolving products based on customer feedback. TSC created the first bacterial bead preservation system, Protect, along with products for bioluminescence (ATP) testing. TSC also operates its own plastic injection moulding company under the Goodbrand Plastics brand.
Production and Quality Record System (PAQRS)
A multi-user application was required to administer Production Flow Control system. It should be capable of managing product, batch, irradiation and quality control records on the production line.
The application was developed using Access 2000 Forms and Visual Basic for Applications (VBA). An Access database resided at a centralized server for client Access applications to connect to it over the network.
TSC was looking to completely restructure their existing system for collecting, and recording data , and generating reports. Their conventional way of managing production and quality records was becoming too costly and time consuming.
The scope of the project was to design a system that could be deployed in a multi-user environment with all the data stored at a centralized database. They were not looking to make a large investment in technology and were seeking a solution that did not require the purchase of additional IT infrastructure.
The challenge was to design a custom application which would fit in effortlessly with their existing method of managing production data. The new system would have to be simple to set up and administer but be capable of automating all activities involved in their production line. It was essential that the system be consistently efficient and error-free. And all manufacturing and production data should be accessible from multiple locations.
A customized Access application was designed to create a centralized data repository with simple, intuitive screens for tracking user information, entering and updating production, manufacturing and quality records.
The system was divided into various sections to enable easy and quick access to all kinds of data.
The completed PAQRS enabled multiple users to create batch records with product details and record its irradiation status report. It also allowed users to edit existing batches, products and irradiation reports. Direct database editing was restricted for system users with the exception of the system administrator.
Some useful features available with the implementation of the system were:
Below are some sample screens of the application:
Screen 1: Home screen for accessing the different sections of the system
Screen 2: Screen for managing system users
Screen 3: Product management screen
Screen 4: Handling irradiation records
Screen 5: Batch processing screen
The application lifecycle covering system redesign, development, testing and delivery was accomplished within a time frame of 4 months.
By obtaining a bespoke application, TSC was able to implement a system that worked exactly as per organization’s needs but without any unnecessary components. The software was designed specifically according to their requirements and this resulted in the system users performing the same amount of work in significantly less time. TSC users were able to closely monitor and report all production line data. This directly enabled TSC to reduce costly errors, improve efficiency and service delivery. Additionally, it helped them to reallocate resources to other important functions.
Some key advantages following the implementation of the system were: