 |
|
|
|
|
|
MS Access Projects
An Access Database system which is used to create bills on material that combines several components from inventory into finished products. These finished products are reported on a sales order. The system creates bills of lading and facilitates invoicing. End of month reports are generated to show what components were used to create each finished product. This system uses and MS Access front-end on the users system with a back-end database on the network server.
(2008) Procurement Metrics Procurement metrics system to track and report project status and savings. This system uses and MS Access front-end on the users system with a back-end database on the network server. System includes customized reports options with the ability to export data to PowerPoint.
(2006 - 2010) Tour Inventory Inventory control system using MS Access containing replicated databases to support offsite users. System includes customized reports options with the ability to export data to Excel spreadsheets
(2006 - 2010) Logo Printing Control system for unique logo printing, using MS Access with split front-end / back-end database. Production status and shipment tracking available to networked customer service personnel.
(2004 – 2010) Core Production MS Access database application to document and report on production activities. Front-end database installed on users system with a back-end database on the network server.
(2004 – 2010) Unit Line System Production control system using MS Access to generate production, efficiency, quality and engineering reports. Front-end database installed on users system with a back-end database on the network server. System includes customized reports options, statistical charts, and the ability to export data to Excel spreadsheets.
(2006 - 2010) Work Order System Database using MS Access and Excel spreadsheets to create and track maintenance work orders.
(2000 - 2001) Planning System Menu driven MS Access database application to control sales forecasting, production scheduling and outsourcing. Created ODBC link to import data from the corporate level AS/400 system to be used at the local production and sales offices.
(2000) Returns Recycling MS Access database created to manage inventory of returned goods, rework, re-ship, and cost reports.
(1999) Warranty Replacement System Developed MS Access database to control and document customer returns, complaints and warranty replacements.
Visual Basic (VB6) Projects (1999) VHS Loading production application - Windows application written using Visual Studio with a server based MS Access back-end database to document and report quality and inspection results.
(1999) Slitting Data Control System - Windows application written using Visual Basic with a server based MS Access back-end database to document departmental production and quality results.
(1998) Automated Testing System - Windows application written using Visual Studio, using GPIB and digital I/O interfaces to control testing hardware and measurement equipment, with a server based MS Access database.
Call 770-605-8692 to set up an appointment. |
