Online Surveys / Administration for University of Colorado Cosmetic Specialists with ASP.NET and SQL Server

In this post I will detail a project that was created for the University of Colorado Cosmetic Specialists at UCH Hospitals in Aurora, CO.  The UCH CS needed a series of forms to capture data from patients submitting information online.  They also needed a way to view this information and perform reporting functions.  This project uses a SQL Server 2005 backend database with Stored Procedures to secure data and comply with HIPAA patient security requirements:  http://www.hhs.gov/ocr/privacy/

Here is a view of the homepage:

http://cucosmetics.com

This is the Appointment page.  On this page a person can submit an online request for an appointment with one of the Cosmetic Specialist doctors.  When this request goes through, administrators will be notified by email and a record will be written in the database for future reference through the Administration page.

This is the Pharma Survey page.  Companies can fill out this survey to receive information on products / research.  There is also a similar page for people to fill out and receive information.  Past records from both surveys are available for viewing in the Administration page.

This is the Administration page where all data and administrative features are centralized.  Questions for all surveys can be edited and changed in this section.   Data from past responses can also be viewed.  Detailed reporting and search capabilities are included for all candidate / company responses.  All data is stored in a SQL Server database.

Administration for survey questions / web order.

Candidate Search / Reporting

As with all software and websites we create, this project can be modified to suit your needs. Call or request a quote here: http://www.spagnolidesign.com/Contact.aspx