Event Management Database for a Charity

[countrylife]

I manage the bookings for events arranged for members of a charity. To date I have used Excel to record the information produced but it is not a satisfactory method. What I would like to do is to create a database in Access 2010 so as to produce a record of each event, those attending and very important, income per member/event.

There would be:


1.A table containing the details of those members who apply for tickets to a specific event and would include first name,last name,full postal address,post code.

2.A table listing each event detailing the event's name and location and date.

I don't really have a problem managing to create a database with the above information but...the problem arises when it comes to recording income from each member toward the cost of each event. There will normally be a fixed price per ticket but occasionally additional charges for meals, single-room supplements, transport etc. I assume that I should simply place such amounts in additional fields within the "events" table?
However members occasionally send a donation, (which is totally voluntary and the amounts will vary) included in their cheque payment to the charity, in addition to the cost of the event. How should I record this?

Finally I hope to create a form to simplify the entry of the required information.

I will be most grateful for any advice.

[June7]

Review http://office.microsoft.com/en-us/te...001017829.aspx