Chat with us, powered by LiveChat You are in charge of Dysan Investment 's database, which contains all of the information on the properties your firm has listed and sold. Your task is to determine the length of time each pro | WriteDen

You are in charge of Dysan Investment ‘s database, which contains all of the information on the properties your firm has listed and sold. Your task is to determine the length of time each pro

 Exp19_Access_Ch03_ML2 – Investment Properties 1.2 

 Exp19 Access Ch03 ML2  Investment Properties 1.2 

 Access Chapter 3 Mid-Level 2 – Investment Properties 

  

Project Description:

You are in charge of Dysan Investment 's database, which contains all of the information on the properties your firm has listed and sold. Your task is to determine the length of time each property was on the market before it sold. You also need to calculate the sales commission from each property sold. Two agents will receive commission on each transaction: the listing agent and the selling agent. You also need to summarize the sales data by employee and calculate the average number of days each employee 's sales were on the market prior to selling and the total commission earned by the employees 

     

Start Access. Open the   downloaded Access file named Exp19_Access_Ch03_ML2_Investment_Properties.accdb.   Grader has automatically added your last name to the beginning of the   filename.

 

Create a new query in Design   view using all three tables. Add the following fields, in the order given:   from the Agents table, add the LastName field; from the Properties table, the   DateListed, DateSold, SalePrice, SellingAgent, and ListingAgent fields; and   from the SubDivision table, the Subdivision field.

 

Add criteria to the query to   ensure that the DateSold field is not empty (hint: you will need to use NULL   as part of the criteria). Run the query to ensure empty fields are not   displayed for the DateSold field. Return to Design view.

 

Format the SalePrice field as   Currency. Save the query as Sales Report.

 

Create a calculated field in the   first empty field named DaysOnMarket that will calculate the number of days each sold   property was on the market when it sold. Add a caption of Days on   Market.

 

Create another calculated field   in the first empty field named ListComm that will calculate the listing agent's commission based on the   sales price and a listing commission rate of 3.5%. Add a caption of Listing Commission and format the field as   Currency.

 

Create another calculated field   in the first empty field named SellComm that will calculate the selling agent's commission based on the   sales price and a selling commission rate of 2.5%. Add a caption of Selling Commission and format the field as   Currency.

 

Save the query and switch to   Datasheet view. Add a Total row. Calculate the average number of days on the market   and the sum for the SalePrice and the two commission fields. Save and close   the query.

 

Create a copy of the Sales   Report query named Sales Summary by Last Name. Switch to Design view and   remove the DateListed, SellingAgent, ListingAgent, and Subdivision fields.

 

Display the Total row in Design   view. Group by LastName and change the DateSold field Total row to Where.   Show the sum of SalePrice, the average of DaysOnMarket, and the sum for both   ListComm and SellComm.

 

Change the caption for the   SalePrice field to Total Sales and format of the DaysOnMarket field as Fixed. Run   the query. Adjust column widths as necessary. Adjust the Total row in the   Datasheet view so it shows the sum of Total Sales. Save and close the query.

 

Create a copy of the Sales   Summary by Last Name query named Sales Summary by Subdivision. Open the query in Design view   and replace the LastName field with the Subdivision field, ensuring the Total   row is set to Group By

 

Sort the query results so the   lowest average Days on Market is first and the highest average Days on Market   is last. Limit the results to the top five values

 

Close all database objects.   Close the database and then exit Access. Submit the database as directed.

Marcos_Exp19_Access_Ch03_ML2_Investment_Properties.accdb

ID FirstName LastName HomePhone Title CellPhone PerformanceReview mSysRowId
1 Juan Rosario-Galarce 228-9999 President 224-0000 NA OW92l1AOt8YEvNCfRQGWjuHdoocDWyU2pYNEaHomYB4=-~4YsAc8NCK8Fu9Ecp1Q5W3g==
2 Kia Hart 222-9999 Senior Age 224-0001 Excellent OW92l1AOt8YEvNCfRQGWjuHdoocDWyU2pYNEaHomYB4=-~4YsAc8NCK8Fu9Ecp1Q5W3g==
3 David Royes 226-9999 Agent 224-0002 Good OW92l1AOt8YEvNCfRQGWjuHdoocDWyU2pYNEaHomYB4=-~4YsAc8NCK8Fu9Ecp1Q5W3g==
4 Ko-Yun Yang 221-9999 Agent 224-0003 Good OW92l1AOt8YEvNCfRQGWjuHdoocDWyU2pYNEaHomYB4=-~4YsAc8NCK8Fu9Ecp1Q5W3g==
5 Steven Lookabil 222-0000 Agent Trai 224-0004 Satisfactory OW92l1AOt8YEvNCfRQGWjuHdoocDWyU2pYNEaHomYB4=-~4YsAc8NCK8Fu9Ecp1Q5W3g==
6 Angela Scott 228-0000 Agent Trai 223-0005 Good OW92l1AOt8YEvNCfRQGWjuHdoocDWyU2pYNEaHomYB4=-~4YsAc8NCK8Fu9Ecp1Q5W3g==
ID mSysRowId
1 N0hzTZjc8evAFnY/mmPmqeONtAxug+dI97bXuVvB4Us=-~Qnhgb3U/hFsNIWvoNZuJ7Q==

<

HOW OUR WEBSITE WORKS

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of 
HIGH QUALITY & PLAGIARISM FREE.

Step 1

To make an Order you only need to click ORDER NOW and we will direct you to our Order Page at WriteDen. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
 Deadline range from 6 hours to 30 days.

Step 2

Once done with writing your paper we will upload it to your account on our website and also forward a copy to your email.

Step 3
Upon receiving your paper, review it and if any changes are needed contact us immediately. We offer unlimited revisions at no extra cost.

Is it Safe to use our services?
We never resell papers on this site. Meaning after your purchase you will get an original copy of your assignment and you have all the rights to use the paper.

Discounts

Our price ranges from $8-$14 per page. If you are short of Budget, contact our Live Support for a Discount Code. All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.

Please note we do not have prewritten answers. We need some time to prepare a perfect essay for you.



Listing DateListed DateSold ListPrice SalePrice SubDivisionID City SellingAgent ListingAgent mSysRowId
10001.0 2012-05-28 146000.0 3 Dale City 1 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10002.0 2012-07-22 163600.0 3 Dale City 2 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10007.0 2012-06-22 239600.0 3 Dale City 3 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10008.0 2012-08-12 239600.0 3 Dale City 2 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10020.0 2012-07-23 2012-08-15 108000.0 99000 3 Dale City 4 2 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10021.0 2012-07-22 436000.0 3 Dale City 3 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10022.0 2012-10-24 439600.0 3 Dale City 4 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10027.0 2012-08-25 2012-10-17 115000.0 114000 14 Wood Town 1 4 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10028.0 2012-07-24 471600.0 14 Wood Town 2 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10034.0 2012-08-12 502020.0 14 Wood Town 2 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10035.0 2012-08-13 2012-10-18 125990.0 124350 14 Wood Town 2 3 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10038.0 2012-08-12 507600.0 14 Wood Town 5 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10039.0 2012-09-01 509600.0 14 Wood Town 6 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10044.0 2012-09-03 2012-10-20 129900.0 126000 14 Wood Town 6 2 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10046.0 2012-09-04 2012-10-21 130000.0 128950 14 Wood Town 5 2 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10047.0 2012-09-05 2012-10-22 131000.0 125000 14 Wood Town 4 5 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10054.0 2012-09-01 540000.0 14 Wood Town 1 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10084.0 2012-09-21 588000.0 14 Wood Town 4 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10096.0 2012-09-21 608000.0 14 Wood Town 5 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10098.0 2012-09-21 459000.0 14 Wood Town 6 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10099.0 2012-09-23 613400.0 6 Northern Heights 6 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10114.0 2012-09-24 2012-10-28 155000.0 155000 1 Northern Heights 1 6 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10115.0 2012-09-23 624000.0 6 Northern Heights 1 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10845.0 2012-10-11 1199600.0 5 Brookville 3 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10846.0 2012-10-11 1199996.0 5 Brookville 5 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10861.0 2012-10-11 1260000.0 5 Brookville 1 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10864.0 2012-10-11 1269600.0 5 Brookville 3 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10868.0 2012-10-13 2012-11-01 317400.0 314900 1 Brookville 5 6 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10869.0 2012-10-12 1275600.0 11 Hightown 4 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10872.0 2012-10-13 1279000.0 11 Hightown 5 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10873.0 2012-10-14 2012-11-02 319900.0 319000 2 Hightown 6 1 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10875.0 2012-10-15 2012-11-03 319900.0 317000 2 Hightown 4 1 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10885.0 2012-10-18 1300000.0 11 Hightown 5 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10888.0 2012-10-19 2012-11-30 326000.0 322000 2 Hightown 3 2 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10890.0 2012-10-18 1316000.0 11 Hightown 2 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10891.0 2012-10-18 1316000.0 11 Hightown 1 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10896.0 2012-10-18 1339600.0 11 Hightown 2 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10897.0 2012-07-16 1339600.0 11 Hightown 4 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10898.0 2012-06-22 1340000.0 9 Northern Heights 2 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10899.0 2012-06-23 2012-07-15 336400.0 335000 9 Northern Heights 3 1 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10910.0 2012-09-01 1359600.0 9 Northern Heights 4 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10911.0 2012-06-22 1359600.0 9 Northern Heights 5 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10913.0 2012-09-21 1359600.0 9 Northern Heights 4 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10914.0 2012-10-02 1360000.0 9 Northern Heights 3 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10925.0 2012-09-01 1390000.0 13 Water Valley 3 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10926.0 2012-08-12 1390000.0 13 Water Valley 3 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10927.0 2012-10-02 1392000.0 13 Water Valley 2 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10928.0 2012-10-03 2012-11-03 348000.0 335000 13 Water Valley 5 2 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10932.0 2012-07-22 1396000.0 13 Water Valley 1 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10959.0 2012-09-21 1462000.0 13 Water Valley 2 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10966.0 2012-09-22 2012-10-31 372300.0 339000 4 Eagle 2 6 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
10968.0 2012-09-23 2012-11-01 374900.0 375000 4 Eagle 3 3 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
11012.0 2012-09-28 2012-11-06 430000.0 425000 4 Eagle 4 3 k1t2qStBmuqg/SvglWjpUTu7LIol5gNZRYcEyyP6TSw=-~Elmo0s0bLgrmOE8Q54tR6Q==
11025.0 2012-09-29 2012-11-07 449000.0 429000 4 Eagle 5 2