Theater Management Database         

Home

Screen Shots
Reports

The program is designed as a lower-cost solution/replacement for the facilities management software that I was seing back in the 90's such as Select Ticketing Systems Inc. PASS program. (As far as I can tell they are not even in business anymore) The TMD would also be a workable and simplified solution for organizations that currently use multiple office programs for theater management. The concept for the database was inspired by comments on the difficulty of use and high cost of the PASS program, and by laments about using a dozen or so programs to keep track of everything.

The TMD is a multipart database consisting of four sub-databases and one master database. The four sub-databases would be as follows: crew, facilities (by room), customers, and equipment. The master database would then track each event using data pulled from the four sub-databases and from data entered for the particular event. The TMD would run off Microsoft Access and would use and link to other Microsoft Office programs as needed.

Once programming is complete, the product will be a “template” database, ready to be customized on a theater-to-theater basis with little work. Additionally, as a theater changed, the database could be changed to fit. With the “template” will be directions (as help files from within the program), and codes to run and modify the database.

Linked to this page is screen shots and sample reports. Please be warned, these page will take some time to load due to the large amount of graphics! If you have Adobe Reader you can view and print the paper brochure

The project was started as my thesis for may Masters degree from Boston University.

horizontal rule

Unfortunately I have decided to completely abandon the work that you see here. After working on it more I found that I had some serious problems to over come to finish it.
     1) The time it would take to finish the program alone was to great.
     2) Although I am a good programmer, I do not possess the expertise in Access or Visual Basic needed.
     3) It had way to much glitz to it.
     4) I was attempting to make it work in two different types of theaters (Arts Center and Producing).

So I started all over again...then I threw that version out....then I started again using Visual Basic as the interface instead of access....then I threw out that version....So it is all currently saved on my hard drive.

The good news is in the time since I first started this the internet and technology has gone a long way. I have looked around on the web for varios variations of event managment software. My current favorite is Eventbooking.com mostly due to the fact it is completely web based. However there are many other good ones out there that run the gambit of both price and usability.

 




All information subject to change. Not liable for the information contained on any of these pages.
Copyright © 2011 DTF Productions    Last modified: November 07, 2011
[Company Logo Image]