Project Description:

The Prestige Hotel chain caters to upscale business travelers and provides state-of-the-art conference, meeting, and reception facilities. It prides itself on its international, four-star cuisine. Last year, it began a member reward club to help the marketing department track the purchasing patterns of its most loyal customers. All of the hotel transactions are stored in a database. Your task is to help the managers of the Prestige Hotels in Denver and Chicago identify their customers who stayed in a room last year and who had two persons in their party.

Start Access. Open the downloaded   Access file named Exp19_Access_Ch02_ML2_Hotel. Grader has automatically added   your last name to the beginning of the filename. Save the file to the   location where you are storing your files.

Import   the location data from the Excel file Location.xlsx   as a new table in the current database. Using the wizard, specify that the   first row contains column headings, set the LocationID field to be indexed   with no duplicates, and set the LocationID field as the primary key. Import   the table with the default name Location   and do not save the import steps.

View   the Location table in Design view and change the field size for the   LocationID field to Long Integer.   Save the table. Click Yes in the   dialog box indicating that some data may be lost. Close the table.

Add   the Location, Orders, Members, and Service tables to the Relationships window to begin establishing   relationships in the database. Close the Show Table dialog box. Create a   one-to-many relationship between the Location table and the Orders table   using the LocationID field. Enforce Referential Integrity. Select the option   to cascade update the related fields.

Create   a relationship between the Members and Orders tables using the MemNumber   field, ensuring that you enforce referential integrity and cascade update   related fields.

Create   a relationship between the Service and Orders tables using the ServiceID   field, ensuring that you enforce referential integrity and cascade update   related fields. Save and close the Relationships window.

Create   a new query in Design view using Location,   Members, Orders, and Service tables.   Add the following fields to the query (in this order): ServiceDate from the Orders table; City from the Location table, NoInParty from Orders table; ServiceName   from the Service table; and FirstName   and LastName from the Members   table. Set the criteria in city field to limit the output to Denver.

Display   only service dates from 7/1/2017   to 6/30/2018 (Hint:   Use the Between   command).

Set   the NoInParty criterion to 2.   Sort the results in ascending order by the ServiceDate. Run and save the   query with the name Denver Rooms 2 Guests.

Use   Design view to change the order of the query fields so that they display as   FirstName, LastName, ServiceDate, City, NoInParty, and ServiceName. Run, save   the changes to the query, and close the query.

Copy   the Denver Rooms 2 Guests query   and paste it in the Navigation pane, renaming the new query Chicago Rooms 2 Guests.

Open   the Chicago Rooms 2 Guests query   in Design view, and change the City criterion from Denver to Chicago.   Run the query and save the changes. Close the query.

Close   the database and exit Access. Submit the database as directed.

Pay attention to all formalities regarding content and structure. Remember that is important that you justify your answers and include in-text citations throughout the submitted document, as seen in class, as well as a list of references. This directly affects the quality and credibility of your work.

This task will be used as a starting point for your final assessment. Choose a company related to the book industry and select a specific region in which such company operates (examples: Penguin Random House, Goodreads, Pearson). Develop an assessment paper on consumer behavior including:

Brief introduction to the company, highlighting the key value that it has to the customer

Table with the segmentation of customers, clearly identifying 3-5 groups and including proper descriptors for each one.

Buyer persona for one target group, developing it visually.

Personal elements that affect this target group as customers, explain all necessary aspects (lifestyle, occupation, economic situation, personality, self-
concept). Make sure to emphasize how this affects the way they behave with the brand.

Social elements that affect this group. What are the reference group that affects them the most? Why? Make sure to emphasize how this affects the
way they behave with the brand.

Cultural elements that affect this target. Apply a key cultural analysis technique learnt throughout the course. How does culture affect this target when
purchasing from the brand?

Short conclusion highlighting key factors that shape the behavior of these customers.

Formalities:

Wordcount: 2000 words

Cover, Table of Contents, References and Appendix are excluded of the total wordcount.

Font: Arial 11 pts.; line spacing 1.5.

The in-text References and the Bibliography must be in Harvard’s citation style.

Imagine you are the manager of the medical records team for a regional managed health care organization with 40 locations across the state. Your department handles the medical records for all locations. Your team receives requests from patients, attorneys, insurance companies, and internal and external clinicians. Your leader, the director of medical records and billing, would like to know how effective your team’s relationships with its customers is. 

Instructions:

Due Thursday:

Post a substantive response that addresses each of the following components (minimum 175 words):

How would you find out how the customers feel about your team’s work?

Would the way you measure consumer relations depend on the type of customer? Consider whether you think the way you measure customer satisfaction of internal customers, such as clinicians and other employees, should be different than external customers, such as patients, insurance companies, attorneys, and clinicians at other health care organizations.

What things do you think would be most important to measure to show effective consumer relations? Some important metrics might be how quickly an issue was resolved, how knowledgeable or friendly the records specialist the customer interacted with is, how accurate the information received was, or how satisfied the customer is with the service they received.

Why are effective consumer relations important in health care? How might consumer relations matter to you in your current health care job or a future health care job?