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