I have constructed a seven table database for dealing with holiday cottages.

The seven tables are:

Bookings
Cottages
Customers
Ratings
Owners
Regions
Sales Reps

I have created the 7 tables and created the primary keys (BookingID,CottageID,CustomerID,RatingsID,OwnersID ,RegionsID,RepID)

The ratings table because cottages come under different ratings (Family, Sporting etc..).

I need to create a form which

*Adds a new booking, and also adds the new customers details
*Checks the avalibility of the cottage for the chosen week
*allows the user to choose a rating from a combo box, which then filters the cottages availible for selection in that category.

If anyone could help me with this I would be very grateful, I have emailed my lecturer but he is not replying and the assignment needs to be in on the 12th!