Database Projects
Here is a partial list of some of the custom software projects we have been involved in over the past several years. As you can see, one of our strengths is the ability to make use of 3rd party tools to go beyond what the base tools are capable of doing:
Aon Risk Services (Southfield, MI)
Aon is a very large global insurance company. We created and maintain two separate applications for Aon. First is a FoxPro program that was originally written in FoxPro 2.5 for DOS and later converted to VFP. It is used to handle their commercial McDonalds Restaurant client data. Second is an MS Access/Jet application to handle their commercial Little Caesar's Restaurant client data. Both programs manage customer and location data, policy information, and among other things are used to generate proposals and invoices. They both make extensive use of automation with MS Word and MS Excel.
Construction division of Siemens USA (Chicago, IL)
Keith did some of the design and programming work on this project and lead a team of programmers to carry out the bulk of the work. It was a conversion from an archaic monster set of Excel spreadsheets that had been in use in many of their North American offices for a dozen years or so and had grown too large to manage properly. Keith worked closely with the Vice President of Operations in Chicago during most of the project. The program is in use throughout the USA and Canada and manages scheduling of employees and job costs. Tools used: MS Visual Basic and MS SQL Server 2000.
American Metal Processing (Warren, MI)
American Metal Processing heat treats metal parts (washers, clips, screws, etc.) for industry. They needed a custom program that would handle their needs without extraneous features that might confuse their staff. Previously they had been using a prepackaged program that was far too complicated for their needs and was difficult if not impossible to have customized. The application we designed and developed for them using MS Access with the Jet database tracks parts lists, heat treating "recipes", work orders, invoicing and more. It has extensive reporting built in, automatically, electronically faxes invoices to customers when a work order is complete and even captures signatures for shipping and processing steps that require authorization. It also automatically posts accounting data when a job is closed to their Peachtree accounting system.
The Law Center for Social Security Rights (Southfield, MI)
One of our talents is understanding our customers' needs. LCSSR's previous programmer was no longer available and there was very little documentation on the application he wrote. We came in and quickly learned the program and their needs so that we could maintain the existing program. Shortly after that we rewrote the backend from MS Jet to MS SQL 2000 and converted the front end (MS Access) to be able to use the new database.
Since then we have made a great many changes to the program including the ability to scan and store documents as PDF files so the staff no longer has to waste time locating their clients' physical files in the file rooms. We have been able to make this office nearly paperless by taking advantage of this sort of technology.
Soon we will be rewriting the front end for the web and converting the backend to MySQL. This program also takes advantage of automation in order to generate a great many reports in MS Word. The new conversion will no longer use any MS products and instead take advantage of the many open source options such as Open Office.
Meadowbrook Landscaping (Farmington Hills, MI)
Prior to our developing this application, the customer had been using paper and various programs not well suited for data management such as documents and spreadsheets to maintain customer information and generate invoices. As a small business owner, this customer was on a very tight budget and we were able to stay within his spending limit while giving him the results he needed to better run his business. This program manages customers, scheduling and invoicing and was written using MS Access and the Jet database.
Rental Professionals (Rental Properties Search Service in Southfield, MI)
This program provides customers with tools for accessing rental property listings via telephone, fax, text-to-speech, as well as customer billing features. Tools used: MS Visual FoxPro, Dialogic Hardware.
Center for Progressive Learning (School Fees/Management System in Troy, MI - no longer in business)
This system was written to handle data such as student records, student enrollments, tuition & fees, class scheduling, invoicing, teacher salary tracking, tax reporting, general accounting, reporting for a banking education company. It was written using MS Access with the Jet database.
Crane & Crane, Inc (Fruit Orchard / Packer in Brewster, WA)
This program was written using MS Access with the Jet database to handle vendor & customer data, packing, orders, scheduling and invoicing.
Childrens' Music Academy (Santa Barbara, CA)
This was a nice, clean, simple little custom application (and relatively inexpensive) written in MS Access with the Jet database. It maintains student & teacher data and scheduling. Tools used: MS Access and Jet database.
Torque and Force Measurement Technologies Company
Using a programming language called "TestPoint", a comprehensive testing program was developed in conjunction with specialized hardware to test and monitor production results of torque measurement equipment. The program "talks" to the testing hardware to apply electrical currents of various amounts, at specified intervals, to the torque measurement hardware, and tracks results, indicating when parts pass and when parts fail testing.
KitchenTools Software, Inc.
Catering Management Software Developed for professional catering houses by the principals of Quintesoft, this system written in Borland Delphi with extensive use of 3rd party tools. It was designed to manage accounting and production of large scale food production companies. It was built to take advantage of the free licensing of Microsoft's MSDE and SQL Express data engines. To see details about this project click here.
School Fees/Management System – American English School – Taiwan
This program was designed to manage student tuition, class scheduling, invoicing, teacher salary tracking, tax reporting, and general accounting reporting for international English schools. Tools used: MS Access/Visual Basic.
PLR International
Web-based application. Supply chain management software designed to manage import/export supply chain communications, product documentation, document tracking, import compliance.
Click here for our contact information. You can also fill out our contact form with your information and project details. We'd be happy to review your project and get back to you promptly.
