our project
We wanted to create a database for Buffalo’s Guest House to generate a more organized way of collecting information. The hotel was previously using a paper-based system. This guest house is a hotel for the families and friends of patients who are in the hospital, and need a place to stay.
Our database keeps track of all guest information, patient information, rooms available and payment methods using tables. Our guest information is located in a table that has all their personal information, contact information, and number of guests staying. The patients table includes patient name, hospital that they are located at, and hospital postal code. Payments is sorted by length of stay, price of room, any discounts they might have, type of payment and total price. Lastly, the rooms table includes room number, capacity of the room, price, type of bed and number of beds. All this information was then used to create other queries, forms and reports.
Ours forms provide an easier way to add, delete, and find records. There is even an option to print the table and close forms. We have three reports: Guest list, Monthly Earnings, and Most Popular Hotels. The reports are a great way to accessing a greater range of information, that would be useful for employees at the Buffalo Guest House.
Our database keeps track of all guest information, patient information, rooms available and payment methods using tables. Our guest information is located in a table that has all their personal information, contact information, and number of guests staying. The patients table includes patient name, hospital that they are located at, and hospital postal code. Payments is sorted by length of stay, price of room, any discounts they might have, type of payment and total price. Lastly, the rooms table includes room number, capacity of the room, price, type of bed and number of beds. All this information was then used to create other queries, forms and reports.
Ours forms provide an easier way to add, delete, and find records. There is even an option to print the table and close forms. We have three reports: Guest list, Monthly Earnings, and Most Popular Hotels. The reports are a great way to accessing a greater range of information, that would be useful for employees at the Buffalo Guest House.