Year 12s: what will be the first way you research your future options? >>

CPT3 AS Computing Coursework- Village Hall- HELP!!

Hi

Ive been doing my coursework, and just realised i don't know what to do next.
I have so far made two tables and forms for them
The tables are:

tbl Customer:
Customer ID
Surname
Forename
Title
Address 1
Address 2
Postcode
Telephone Number
Email Address

and

tbl Bookings:
Customer ID
Booking ID
Event Title
Booking Date 1 (ie, Monday, Tues..)
Booking Date 2 (ie 01/01/2006)
Booking Slot (ie Morning, Evening....)
Type of Booking (ie One off, Reg, or Occasional)
Evening Extention (ie Yes or No)
Fee Due
Fee Paid (ie Amount still left to pay)

Ive made a relationship with the two tables, which links the Customer ID's in them both.

I was wondering if i am actually on the right tracks, am i doing it wrong, or/and if there is any new tables i should make or something.

Are there any other tables needed? Or anything else

Any advice will be a real help....i am reaaaaaaaaaaaaalllllllyyyyyy stuck lol!!

Thanks

Reply 1

HearTheThunder

There's a huge CPT3 thread already, stick it in there.

And er yeah can't really help since ours is done in pascal but the customer ID *is* the foreign key in my bookings file

Reply 2

HearTheThunder

ba810

Hi
Type of Booking (ie One off, Reg, or Occasional)

There are only two types of bookings? Regular or occasional, I don't know what this "one off" thing you've come up with is :wtf?:

oh yeah, cheers

I had a 3rd table with Period and Costs stored in it, for each period.

My class is using htat for a huge IF query to work out the costs for invoices, however i went and used VB to code it. Up to you really, you can get by without it, but if ur using Access solely, then u will need it.