Aquinas Grammar Documentation
Aquinas Hotel Instructions.
This page will help you be able to effectively work the Aquinas Hotel Program using Microsoft Excel. N.B. To effectively execute the program for Aquinas Hotel you must first open both worksheets involved in the Program;
Assignment1 and Storage1.
If both of these are not opened then the spreadsheet will not function properly.
To add a new Customer;
In order to add a new customer to the Aquinas Hotel register, starting from the main screen in sheet Assignment1 click the link labeled, ‘Add New Customer’. This will automatically link you to the details page of the program, where you can enter all the required information, Name, Address, Etc. Then you must scroll down and pick from one of the four pre-set buttons depending on what type of room the customer will be staying in. You will be required to enter the data on number of adults, children and amount of days staying. (N.B. without this information the program will not be able to calculate the bill effectively). Please Enter the date of the stay in the box provided. The customer Details will no be on the program and ready to calculate.
How to calculate the bill;
Once the persons details have been entered on the details page of the program, please ensure all fields are filled in, then click the button labeled, To the calculations page This will link you to the part of the program which will calculate the persons bill for you, once here many fields may be empty, but if you click the button labeled Calculate the program will automatically link in all the information it needs, and it will calculate the bill for you, giving you a final figure for the persons bill.
Archiving data;
Once the persons bill has been calculated and paid, the persons charge and the companies income will be needed to be transferred into the data archive. Storage1. (Please note that the document Storage1. Should not need to be altered in anyway and it completely self sufficient, so please do not alter anything.) In order to transfer to this storage medium, you must click on the button depending upon the month the person is staying, (e.g. If the person is staying in the hotel in January, the click on the button labeled Janurary etc.). The program will read the details it needs from the information entered and the calculated totals to archive the persons data and their bill.
How to check current income and performance.
If you wish to check the current performance of the Aquinas Hotel company, then go from anywhere within Assignment1 worksheet click on the to the main page link. This will bring you back to the main page, from here you should click on the Annual Performance link, which will bring you to the page which will show you the total income from the hotel over the current year to date, including a break-down of Bar, Restaurant and Leisure center by month, and overall income per month accompanied by an annual total. If you wish to compare the performance over different months click the link labeled Show this data as a Graph and you will be shown a page with 4 graphs on it, A Bar Graph, A Restaurant Graph, a Leisure Center graph, and a totals graph. This will allow you to check how your company is performing to date in a visual form. (please note, both these pages are totally self sufficient and should not be altered for any reason). Once you are finished you may link back to the main program by using the back to the main page link.
The Aquinas Hotel program is relatively straight forward to use and this page should help with most questions, if it doesn’t click the link for Microsoft help within the program or failing that e-mail me to report any major problems or if you just need help to fix something.
Click Here To Report any problems
