SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 305 Weeks Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 03 Dec 2017 My Price 10.00

marketing department track the purchasing patterns

Please follow the instruction and edit the access file

Attach the access file back after editing

Thank you!!

  • EX16_AC_CH02_GRADER_ML2_HW - Prestige Hotel

     

    Project Description:

    The Prestige Hotel chain began a member reward club to help the marketing department track the purchasing patterns of its most loyal customers. In this project, you will 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.

     

    Instructions:

    For the purpose of grading the project you are required to perform the following tasks:

    Step

    Instructions

    Points Possible

    1

    Start Access. Download and open the Access database named exploring_a02_grader_h3.accdb.

    0

    2

    Import the downloaded a02_grader_h3Location.xlsx workbook 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.

    13

    3

    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.

    6

    4

    Begin establishing relationships in the database by adding the Location, Orders, Members, and Service tables to the Relationships window. 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.

    13

    5

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

    9

    6

    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.

    9

    7

    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.

    9

    8

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

    7

    9

    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.

    13

    10

    In Design view, 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.

    6

    11

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

    8

    12

    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.

    7

    13

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

    0

     

    Total Points

    100

                                                                                                                           

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 03 Dec 2017 06:12 AM My Price 10.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)