Odulo Enterprises - Consulting Services - Sample Projects

Indian Summer Registrations

Yeahman Productions were to hold a large international five-day event, for which people needed to register and prepay. A printed registration form was made available in the brochure, but the form was very complex, and no system was in place to capture and process the data. Registration information would have to be hand entered into a spreadsheet for each sign-in and check payment or cash at the door would have to be collected. Also, statistical reporting and printed rosters would need to be generated and to do this in a spreadsheet would be very time consuming and limited.

We designed, developed, implemented, and managed for them a web-based registration system with e-payment capabilities and a SQL Server back end to handle the results. (Click on the snapshot below to see the registration form full scale.) As a result, 93% of attendees have registered over the web, half of them paid electronically.

Registration Form

We built secure interactive on-line data views, each with custom data editing capabilities, for the staff to process and interact with the data. Click on any of the snapshots below to see the full size image. Note that clicking on the edit record icon opens the record in a customized edit window, where the relevant information is displayed, and only the appropriate fields are available for editing.

Package View

As seen in the example above and one below, clicking the edit icon opens the record in a custom edit window with the appropriate fields available for modification.

Payments View

We also built an MS Access solution to handle sign-ins and last minute reporting and analysis at the event location. The database in this application was synchronized with the SQL Server database on the web just before, during, and after the event.

MS Access Registration Screen

Click on the snapshots to see the screens full size.

MS Access Report

The ability to see all totals in real time over the web was extremely valuable to the staff of Yeahman Productions. They did not have the manpower and would not have been able to handle all these registrations manually without the use of this system. Without the use of the MS Access solution onsite for registrations, they would have not been able to efficiently track who had signed in, who had purchased which package and options, and who still owed money.