Hey guys, i have an assignment due for tomorrow and ive been trying all my reading week to get my database done but i have a massive problem, Ive tried contacting my tutor but ive had no reply,
I have been asked to make a database (with no experience in access) that will show a 'easyhol' system, which is renting out houses with a tarif which changes the price, i have made 3 tables, a booking table, client table and property table,
one of the problems i have is making the price of the property show up in the booking table without entering the data twice...
but im having trouble mainly with the tarrif and getting all my tables to link together through relationships, this is what my assignment sheet says:
'The Tariff is used to determine the weekly rental price. Prices for a tariff vary according to the week commending date (all bookings begin on Saturday). Thus, given a week-commencing date and a tariff code, it’s possible to look-up the weekly rental price to be charged when a Booking is made.'
^^ is exactly what it says on my assignment sheet, im not asking anyone to do my work for me but i really REALLY would greatly appreciate any help that could be delivered today on the 14th of november,
Ill keep myself logged in so feel free to ask me anything, i could post the full assignment briefing if anyone is interested in helping me,
Thanks a lot guys,
Dave.
I have been asked to make a database (with no experience in access) that will show a 'easyhol' system, which is renting out houses with a tarif which changes the price, i have made 3 tables, a booking table, client table and property table,
one of the problems i have is making the price of the property show up in the booking table without entering the data twice...
but im having trouble mainly with the tarrif and getting all my tables to link together through relationships, this is what my assignment sheet says:
'The Tariff is used to determine the weekly rental price. Prices for a tariff vary according to the week commending date (all bookings begin on Saturday). Thus, given a week-commencing date and a tariff code, it’s possible to look-up the weekly rental price to be charged when a Booking is made.'
^^ is exactly what it says on my assignment sheet, im not asking anyone to do my work for me but i really REALLY would greatly appreciate any help that could be delivered today on the 14th of november,
Ill keep myself logged in so feel free to ask me anything, i could post the full assignment briefing if anyone is interested in helping me,
Thanks a lot guys,
Dave.
