Convention Registration

[Guest]

I am setting up a registration for a convention. I was told to use access
program. I need some suggestions on which program to use and how to set it
up. I need a program which I can have a printed base for registration table,
with participants name, what they purchased for the convention, and number of
tickets. For example if they bought 2 lunches and for which days, or if they
purchased a speicla event. I also would like the program to put in
alphabetical order and total amount of items sold for the hotel count. Any
suggestions you can give me would be greatly appreciated. You can contact me
at (e-mail address removed).

Thanks in advance.

Sandy

 

[Guest]

I don't know how detailed your events are but you would need at least three
tables to get started. One would be be for the attendees. One would list the
events. One would contain the events that each attendee purchases tickets for.

tblAttendee
-------------
AttendeeID
FirstName
LastName
Address
etc...

tblEvents
----------
EventID
EventName
EventDate
EventPrice
etc...

tblPurchasedEvents
----------------------
ID
AttendeeID
EventID
Quantity
etc...

The data could be sorted in whatever manner you wish.