The Sailing bed and breakfast club started back in late 1980s. The goals of the club are efficiently provide cheap accommodation on the beaches in the bay for members and to provide a structure to allow members to socialize and network. To enable the members rate to remain low the bed and breakfast are available for the general public to use at higher rates.
What the club needs is something that will allow the booking officer to record all details of a booking accurately and quickly. They should be able to print this out as an invoice, which can post or email prior to the booking. The booking should then be capable of being transferred to a list containing all the bookings for that week. This list should allow the booking officer to quickly judge who can be accommodated and who can't. Finally the list needs to be capable of being quickly communicated to the relevant caretaker.
Therefore, the Database system you will develop (Assignment 2 Part B) should contain
1. A login screen
2. A switchboard with welcome message and menu to open forms and reports.
3. A data entry form to record
a. Current accommodation costs and arrangements (Master data)
b. All details of a booking (First
Name,Surname,Members(Yes/No),Address,Suburb,Postcode,Phone,B&B
Location(Required),Arrival Date,Departure,No. of Adults,No. of Children)
c. A button to calculate Total cost of booking
4. Multiple reports (You must create queries for each report)
a. An invoice, contain details and cost of the booking
b. A list, containing all the bookings for that week group by B&B Locations.