This website uses cookies to ensure you have the best experience. Learn more

Cmis 351 Assignment 1 Essay

2090 words - 9 pages

Introduction

The purpose of this report is to analyze the Queen’s Inn current reservation system and propose a recommendation for management to move towards an automated system that will increase profit, transparency to management on daily operation and to introduce a solid tracking system of their customers promoting efficiency and accuracy by using Microsoft Access.

As a result of utilizing automated advanced database entry system like Microsoft Access, users will be able to generate queries and reports based on their own desires without going through circles or complex steps. Using a database querying system, anyone in management of Queen’s Inn will be able to find out how the ...view middle of the document...

Queens Inn Reservation System Analysis

Queries completed on the daily operation reservation of Queens Inn number of guests, the length of their stay, and the daily rate for the room result shows that the business status is healthy. It shows every room category in the Inn is always booked, even with the more expensive ones - the Ocean and Bay-window rooms.

According to the query using MS Access, on average Queens Inn accommodates from 2 to 4 visitors a day. It seems that major percentage their visitors favors the Ocean rooms. It shows that visitors love to stay in the Ocean rooms because it offers the full view of the ocean, as opposed to the Bay-Window rooms which have limited view, and the Side rooms view doesn’t show much of the ocean. The report clearly shows that that visitors are willing to pay for more for the Ocean rooms.

Query |
Room Type | Arrival Date | Departure Date | Sum Of No of Guests | Avg Of No of Guests | Min Of No of Guests | Avg Of Daily Rate | Min Of Daily Rate |
Bay-window | 2004-12-01 | 2004-12-03 | 2 | 2 | 2 | $150.00 | $150.00 |
Bay-window | 2004-12-01 | 2004-12-04 | 2 | 2 | 2 | $150.00 | $150.00 |
Bay-window | 2004-12-03 | 2004-12-06 | 3 | 1.5 | 1 | $150.00 | $150.00 |
Bay-window | 2004-12-04 | 2004-12-07 | 1 | 1 | 1 | $150.00 | $150.00 |
Bay-window | 2004-12-05 | 2004-12-07 | 3 | 1.5 | 1 | $162.50 | $150.00 |
Bay-window | 2004-12-10 | 2004-12-15 | 1 | 1 | 1 | $150.00 | $150.00 |
Bay-window | 2004-12-20 | 2004-12-23 | 2 | 2 | 2 | $150.00 | $150.00 |
Bay-window | 2004-12-24 | 2004-12-28 | 4 | 4 | 4 | $175.00 | $175.00 |
Ocean | 2004-12-01 | 2004-12-03 | 4 | 4 | 4 | $325.00 | $325.00 |
Ocean | 2004-12-01 | 2004-12-09 | 3 | 3 | 3 | $112.50 | $112.50 |
Ocean | 2004-12-02 | 2004-12-04 | 1 | 1 | 1 | $300.00 | $300.00 |
Ocean | 2004-12-04 | 2004-12-12 | 2 | 2 | 2 | $292.50 | $292.50 |
Ocean | 2004-12-05 | 2004-12-07 | 10 | 3.33333333333333 | 2 | $281.67 | $250.00 |
Ocean | 2004-12-05 | 2004-12-08 | 2 | 2 | 2 | $250.00 | $250.00 |
Ocean | 2004-12-09 | 2004-12-13 | 2 | 2 | 2 | $300.00 | $300.00 |
Ocean | 2004-12-10 | 2004-12-14 | 3 | 1.5 | 1 | $262.50 | $250.00 |
Ocean | 2004-12-13 | 2004-12-16 | 2 | 2 | 2 | $325.00 | $325.00 |
Ocean | 2004-12-14 | 2004-12-16 | 2 | 2 | 2 | $200.00 | $200.00 |
Ocean | 2004-12-17 | 2004-12-20 | 1 | 1 | 1 | $200.00 | $200.00 |
Ocean | 2004-12-19 | 2004-12-21 | 1 | 1 | 1 | $200.00 | $200.00 |
Ocean | 2004-12-24 | 2004-12-31 | 5 | 5 | 5 | $198.00 | $198.00 |
Side | 2004-12-13 | 2004-12-15 | 2 | 2 | 2 | $125.00 | $125.00 |
Side | 2004-12-14 | 2004-12-17 | 2 | 2 | 2 | $125.00 | $125.00 |
Side | 2004-12-20 | 2004-12-30 | 3 | 3 | 3 | $112.50 | $112.50 |
Side | 2004-12-24 | 2004-12-31 | 6 | 6 | 6 | $148.50 | $148.50 |

Users easily research the average length of stay per room type by simply sum the days of stay then divided by the number of rooms. The average result after running the query in Access reveals that the length of stay for...

Other Papers Like Cmis 351 Assignment 1 Essay

Ausenco Financial Statement Analysis

528 words - 3 pages your student id only; • Do not upload your name, unit code, university name, cover sheet, essay question, or any other identifying details on the attached essay document. This is to protect your privacy. Instructions for electronic submission: • Access the LMS web site. • FIND [pic] ANALYSIS of AUSENCO  near the top of the first LMS web site • Drop the final copy of Part 1 of your assignment containing

Essay Requirement

351 words - 2 pages Assignment Minder KG, R Block, Level 2 of the Library at Kelvin Grove Campus. Include the following in your folder when you submit 1. Your Essay with 1.5 spacing between the lines 2. Your reference list (a) in alphabetical order (b) single spacing for each entry 3. Your Essay Draft (from Week 8) with your tutor’s comments page. 4. The QCD111 Essay Criteria Sheet As well as submitting the hard copy to Assignment

Essays

322 words - 2 pages details that will support this perspective. ➢ a reflective essay deals with a topic/issue of importance to you. Your aim is to present the reader with a glimpse inside your mind as you consider that subject. ❖ The difference: narrative essays tell “what happened” to the writer; reflective essays tell what the writer thinks/feels about a subject Take note: 1. Use the English Essentials for both assignment formatting

Christian Worldview

916 words - 4 pages 7 Simple Steps for the M7 Assignment The Worldview Essay Purpose: The purpose of this assignment is to develop and complete the assignment from Module 1. You will be writing again about your personal worldview. Now that you are a worldview expert, this should be a piece of cake, especially if you follow the directions below. Step #1 – Read, Read, Read! a) Read the Module 7 lecture (CLASSROOM>>CANYON CONNECT>>Module 7 Readings) b

Qnt351+Syllabus+Spring+2014 (3)

2671 words - 11 pages draw from the data? | May 5 | | Individual MyStatLab® Problems | Complete the assigned problems in MyStatLab®. Note: You will have an unlimited number of attempts to answer each problem correctly. | May 5 | 6 | Learning Team Data Collection | Use either the data one of your Learning Team members retained from RES/351 or the data from University of Phoenix Material: Ballard Integrated Managed Services, Inc., Part 1.Discuss

Fanacial Accounting

1300 words - 6 pages and claim they are your own, then you will be guilty of plagiarism. The Australian Guide to Legal Citation (AGLC) is available on VU Collaborate and the VU Library website. Footnotes must be used to acknowledge the source or sources of information contained in the assignment. You put a raised number at the end of the information you are citing. These numbers run in order throughout the essay for example, after the first footnote it would run 1

Biblical Worldview

1014 words - 5 pages Essay Instructions You will write 4 essays (double spaced, 12-point Times New Roman font). The first essay must be 1,000–1,200 words, and the following essays must be 750–1,000 words each. Essay 1 corresponds to the Essay 1 prompt as listed below. Essay 2 corresponds with the Essay 2 prompt, etc. through all 4 essays. Each essay is a separate assignment. In completing each essay, research must be conducted through 2–4 peer-reviewed, scholarly

Government

647 words - 3 pages of the following topics for your Writing Assignment 1 essay. 1. As the authors explain in Chapter 2, "The Founding and the Constitution," the Constitution can be changed by formal, as well as informal, means. Complete the following assignment: • Describe the formal amendment process, as put forth in Article V of the Constitution and explain why the founders chose those rules for formally amending the Constitution. • Provide an explanation

Application Assignment 5

1216 words - 5 pages 302 or MATH 351 | 3 | MATH 243 Analytic Geom. & Calc. C Pre-Reqs: MATH 242 | 4 | CIEG 213   CE Materials Laboratory Co-Reqs: CIEG 212 | 1 | COMM 212  Oral Communication  | 3 | CIEG 311   Dynamics Pre-Reqs: PHYS 207, MATH 243 | 3 | PHYS 207 General Physics I Co-Reqs: MATH 241  | 4 | MSEG 302   Materials Science Pre-Reqs: CHEM 103, PHYS 207 | 3 | Breadth Requirement | 3 | MATH 351 Engineering Math I Co-Reqs: MATH 243 | 3

Nope

931 words - 4 pages | July 7July 8 | N/A | 3% | C | | Activity 5: Theme and Understanding Assignment 1 PostAssignment 1 Response | July 8July 9 | N/A | 3% | KU | | Activity 6: ISP Reflective Journal (dropbox) | July 9 | July 10 | 4% | T | | Activity 7: Poetry Essay Assignment 1 (dropbox) | July 10 | N/A | 9% | A | Unit 3:Hamlet | Activity 1: Culminating Assignment EssayAssignments  ModuleAssignments 1-5: Required Reading | July 13 | N/A | | N/A

Mathematical Optimization

5831 words - 24 pages Mathematical Optimization: Models, Methods and Applications Final Assignment 06-11-2015 Rasmus pages / 13.137 characters (including spaces) | Part 1 General about part 1 The purpose with this part is to analyze a Single-Sourcing Problem (SSP). A Single-Sourcing Problem of course both has benefits and risks, but I will discuss that furthermore through the assignment. During the assignment I will try to discuss and comment on everything

Related Essays

Assignment 1: Essay “The Mummy’s Curse”

997 words - 4 pages Assignment 1: Essay “The Mummy’s Curse” HUM 111 – World Cultures I Mini Session August 24, 2014 When it comes to curses and mummies, it almost seems like they go hand in hand, like PB&J. Whenever we see a mummy in movies or any type of storytelling there has to be a curse, it just wouldn’t seem right without it. Legends about the "Curse of the Pharaoh's" first was first stated by the Arabs

Calculate Square Footage Essay

657 words - 3 pages CMIS102 Homework Assignment 1 (Worth 13% of your grade) Student Name: Angelica Hines Class/Section: CMIS 102.1202.7983 Professor Name: Ronald McFarland Assignment due date: 04/01/2012 Problem definition: Calculate the usable area in square feet of house. Assume that the house has a maximum of four rooms, and that each room is rectangular. A. Problem Analysis – Following the directions in the assignment, clearly write

Pivottables Cmis 351 Essay

721 words - 3 pages CMIS 351 – Assignment 4 After reviewing the Sales transactions in our PivotTables, we are able to see trends that can assist us with our marketing communications and how to target our audiences appropriately. It is important to note that only one day of sales transactions were used in our PivotTables. The figures portrayed in the PivotTables is only a small scale analysis of consumer behaviour. We can use this tool over an extended period of

Challenges And Reward Of Teaching Essay

649 words - 3 pages will receive will help me meet the challenges head on and appreciate the rewards as they come. In this essay I will discuss my top three challenges and rewards as it relates to the text and information presented in this course. CHALLENGES The multidimensional aspect of the classroom will be challenging. Having a large number of events occurring at the same time will make it difficult to decide what to deal with first. I will have