Orange Coast Database Associates Database Training, Design and Programming Home Page
 Home --> Programming --> Projects

Click for map of the Laguna Niguel and San Juan Capistrano area.

Related services

Group Training

Individual Training

Related Pages

FAQ's

Links

Site Map

Programming and Consulting

Request Information or Quote

Sales: 800-355-9855

Back

Home

About Us

Training Catalog

Contact Us

Summary of programming, consulting and database design projects worked on...

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 can 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.

BackTop

Insurance Agency (Corona Del Mar, CA)
Industry: Financial Services

This multi-user Microsoft Access project implemented a leads tracking and bonus reporting system. It uses a shared backend database on the office server. Reports include applications, leads, bonuses and contacts.

 

Bond Trading Firm (Corona Del Mar, CA)
Industry: Financial Services

This Microsoft Access project implemented a business intelligence front end to the existing trades database. The trades database recorded information on all bond and equity trades the firm placed. Reports provided included trade blotters, daily sales, trade recaps, settlement spreadsheets and many other.

 

Industrial Products (Lake Forest, CA)
Industry: Manufacturing

This application was created for the marketing department of a major manufacturer of tankless water heaters. The database tracks demographic information by plumber, distributor and sales representative. Drill down forms and graphs were provided by each of the above categories showing performance by goal area.

 

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.

 

 

Related Services

Need quick, convenient training for yourself or your organization? We also provide custom on-site training for groups and private training in San Juan Capistrano. Contact us @ 800-355-9855 for more information or request a quote.


Copyright(2001-2009) D.H.D'Urso & Associates

Contact Info. | FAQ's | Site Map | Back | Home | Top