:: Katalyst :: Technical Support, Server, and Network Management

Client: A Fast Growing Jewelry Manufacturer

The Work Order Manager is a custom designed Access database application for a growing jewelry manufacturing company. It is designed to handle and track inventory, work orders and payments. All elements of the system such as the database, the forms, the reports, and the supporting modules that handle the business logic have been built using the tools offered by Microsoft's Access 2003.

Salient Features:

		Search functionality based on various criteria such as customer, inventory or work-orders.

		Editable search results in a grid layout to allow easy modifications to data.

		Dynamic report generation based on user selection of customers/company/inventory source.

		Allows choosing the location of paper for label printing.

		Uses Security and Audit trials to keep track of application usage and customer activities.


Katalyst tasks:

		Adding the Inventory module

		Adding the Costing module

		Customization of label printing to enable choosing of location of paper.

		Customization of search form.

		Customization of reports

		Configuring VPN/remote access to client network

		Removal of auto-out dating from work order/labor form

		Adding functionality to support Barcode-scanner.

		Managing user access to various components of the system via security file.

		Converted the architecture from monolithic to client-server (split code/tables) for easier maintenance & better performance.



Technologies: Windows Server 2003, MS Access 2003, Specialized Bar Code Fonts