Help !!!!!!!!

  • Thread starter Thread starter BrianBailey
  • Start date Start date
B

BrianBailey

Hi - I'm an Student at the university of Brighton on a Finance course
An unexpected module when i started the second year was an acces
project. I am barly computer literate and im stuck in a bit of a rut.
am in dyer need of help! I'll lay out my system so far:

My system is based around a pool hall and at the moment I hav
5 tables. Member type, member details, reservation, table an
Gameinprogress". The problem is im not sure if a reservation system i
possible - or failing that (the information being written on paper) i'
not sure if the additoinal booking fee cant just be added whe
calculating the price (not sure if i even CAN have a price table).
feel my situation is wrong as is the way im looking at the problem.

Can anyone out there give me some guidance>? or even a bit of advice!
know my quation is a bit bland but anything u can tell me will b
helpful!

Thanks for your time,
Bria
 
Hi - I'm an Student at the university of Brighton on a
Finance course...

Brian,

I might be able to help if you can describe the business
purpose of the database application. Don't get hung up in
tables and fields yet, just describe in detail the data
you want to manage, what outputs you want to produce, etc.-
-in other words, define the problem.

One way to think about it is: How would you handle this
problem without a computer--what information would you
record and how would you organize it? If you can create a
workable system on paper, implementing it into Access will
be much easier.

Best regards.
Kevin Sprinkel
Becker & Frondorf
 
Hi - you could try this - but I'm sure there are lots of other options
to figure out your problem:
3 Tables: 1) Tables ie Table 1, Table 2 etc
2)Members - member details including Member id
3)Booking - Table; Date; Start time; finish time; Member
id; res (Y/N), booking fee; fee; any others
Make a form based on Tables: this simply lists the tables available.
Make a subform based on Booking. Check the query so that date and start
time are descending (or ascending). Format date field in table design -
same for time fields. It maybe not want you want, but it may give you a
couple of ideas.
 
Back
Top