Projects

History of projects accomplished by CT Data Services.

Title

Description

Technologies Used

Contact Management Database

This project was developed for a mortgage broker professional giving the ability to manage both the contact  information and data regarding the mortgage process.  The system allows the broker to easily  manage the status of the clients and generate custom mailing lists from the information.

MS Access

Sales Report Generator

This project was designed to import an externally supplied spreadsheet of sales information. The system normalizes the data during  import to simplify report generation.  Several custom reports were built into the system.

MS Access, MS Excel

Document Management System

This is a complicated document handling system that manages several thousand Word documents. The system controls and maintains the revision status of the documents  The system allows only authorized members to change documents and others to print and view. The system was designed to allow the packaging of related documents into a single package to simplify retrieval. The system tracks submitted change requests. Using the built in reporting and graphing functions the system allows management to quickly see the status of all the documents and change requests.

MS Access, MS SQL Server, MS Word

Repair Documenting System

This system was developed for an aircraft operator to allow them to document the repairs performed on the aircraft.  A web based entry form was developed using ASP to allow remote entry of data directly into the system improving the response time of the support staff.

MS Access, MS SQL Server, ASP

Client Eligibility Database

This system was developed for a charitable organization to aid in the tracking and certification of clients benefiting from the service.

MS Access

Gift Gathering Database

2 versions of this type of system where developed to aid 2 charitable organizations in tracking their fund raising events  The system also generates a Thank you letter to be sent to the donor.

MS Access

Educational Companion  Web site

As part of a development team we we're responsible for the PHP and database interactivity  This site was designed as a companion to the textbook. The site provides students and instructs an area to post files, perform evaluations and review grades. The site also automatically notifies students of upcoming assignments and grades via e-mail

PHP, MySQL, HTML

XML Gateway Access

Developed a ASP based site the submits a XML based query to a remote server and then process the returned XML results for display to the user.

XML, XSL, ASP, MS SQL Server