Can you help me?
Jan. 9th, 2012 12:45 pm![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
dreamsharkWell, Minicon, really. But I've been tasked with finding/creating a programming database for this year's Minicon, and I'm hoping I don't have to write it myself. Ideally I'd like a simple Access-based database. I'd consider an online database if it's free, fully functional and well-documented. In many ways an online one would be preferable, but I know so little about Web-based programming that I'm not very comfortable with it. I'd prefer something I can tinker with.
Our needs are relatively simple with Minicon at the size it is now at: about 35 programming items and 100-200 programming participants.
We need to be able to extract the following reports from the database.
Search by Programming Participant:
output: Mailing labels
output: list of programming items for this participant with all detail, including flag for items they are moderating
output: brief summary of programming items by day and time
output: list of participants who are moderating at least one item (along with the items they are moderating, of course)
Search by day and venue:
output: 8.5" x 11" room placards for display outside programming room each day
output: Participant tent cards, sorted by room
Programming items in spreadsheet format, one item per row, which can be sorted and filtered in Excel.
Unnecessary bells and whistles (all desirable, but we can live without)
Automatic generation and printing of badge back stickers (can be formatted manually from Search by Participant)
Automatic generation and printing of notification letters to participants (highly desirable, but can be formatted manually)
Automatic checking for schedule conflicts (can be done manually)
Output schedule in grid format (this can be done by hand in Excel)
Fancy tent cards with the item name printed upside down for display on the back of tent card (let 'em learn to read upside down)
Anybody have any ideas? If you happen to have such a database in your back pocket (or are just dying to write one in the next couple of weeks) that would be great. But what I'm really looking for is ideas on who I could contact at other conventions around the country that might have one to share. Time is of the essence.
Our needs are relatively simple with Minicon at the size it is now at: about 35 programming items and 100-200 programming participants.
We need to be able to extract the following reports from the database.
Search by Programming Participant:
output: Mailing labels
output: list of programming items for this participant with all detail, including flag for items they are moderating
output: brief summary of programming items by day and time
output: list of participants who are moderating at least one item (along with the items they are moderating, of course)
Search by day and venue:
output: 8.5" x 11" room placards for display outside programming room each day
output: Participant tent cards, sorted by room
Programming items in spreadsheet format, one item per row, which can be sorted and filtered in Excel.
Unnecessary bells and whistles (all desirable, but we can live without)
Automatic generation and printing of badge back stickers (can be formatted manually from Search by Participant)
Automatic generation and printing of notification letters to participants (highly desirable, but can be formatted manually)
Automatic checking for schedule conflicts (can be done manually)
Output schedule in grid format (this can be done by hand in Excel)
Fancy tent cards with the item name printed upside down for display on the back of tent card (let 'em learn to read upside down)
Anybody have any ideas? If you happen to have such a database in your back pocket (or are just dying to write one in the next couple of weeks) that would be great. But what I'm really looking for is ideas on who I could contact at other conventions around the country that might have one to share. Time is of the essence.
no subject
Date: 2012-01-09 07:33 pm (UTC)