|
Summary
of programming,
consulting
and database design projects
completed...
|
Below is a
summary of some of the programming projects we have worked on in
recent years. (This is just the initial version of this page.
Updates will be issued over time.) Most work has been done in
Laguna Niguel, California and/or onsite. However, we do work in
conjunction with a large offshore company.
These
programming projects were implemented in Micrososft Access unless
otherwise noted. However, we also have local programming skills in
Visual Basic, Php, MySQL, SQL Server, FileMaker Pro and Visual FoxPro.
|
Back | Top |
|
Telecommunications
Support (Laguna Niguel, CA)
Industry:
Construction Services
This Microsoft
Access database basically maintains the information of employee,
functions, equipments, jobs and invoices for a firm laying
underground communications lines. Reports are available for weekly
sales, weekly time log, and invoices. Along with the same the
database has statistical reports based on employee, function and equipments.
|
|
|
National
Homebuilder (Corona, CA)
Industry:
Construction Services
This
construction management database contains information related to
community, phase, supplier, labor etc. There are several forms (such
as maintaining Temp Labor, Purchase Order, and Inspection Cycle Time
etc) and reports (such as Cost, Labor, Test Listing, Purchase Order,
Preview, Delivery items etc.) available in the application. There are
several Charts used to fulfill some specific presentation
requirements. Also users can export (or import) data to (or from)
Excel spreadsheets.
|
|
|
ClassWare
Web ERP (Laguna Niguel, CA)
Industry:
Education
Php/MySQL web
application for private schools. Maintains information on students,
vendors, classes, courses, time charges, etc. Information is captured
directly from web forms and placed in a MySQL database on the web in
real time. Numerous reports available. System runs on a Linux/Unix
server and is available through any standard web browser. No
installation required. Beta release but in production use.
|
|
|
Student
Evaluations and Questionnaires (San Juan Capistrano, CA)
Industry:
Education
Two small
Microsoft Access databases to record pre-class student questionnaires
and post-class student evaluations. Records and reports class counts,
suggestions, scores, demographics, etc.
|
|
|
Laboratory
Testing (Culver City, CA)
Industry:
Medical Services
This was an
object-oriented Middle Tier application written in Visual Foxpro. It
collected information from legacy FoxPro databases and normalized it
The data was then applied to a SQL Server database in near real time.
This allowed users to see test results over the web.
|
|
|
Psychiatric
Services for Youths (Long Beach, CA)
Industry:
Medical Services
This medical
database has been designed to keep track of the all the processes
that are followed for providing psychiatric services to youths and
children. It maintains the information related to staff, team,
position, training, client (agency), guardian, referral contacts,
discharge, funding, diagnosis, relationship. We did the original
design and implementation and have subsequently worked on several
forms and reports.
|
|
|
