Purchase Solution

Miles Real Estate Access Query List price by city subdivisio

Not what you're looking for?

Ask Custom Question

Nancy Miles, owner of Miles Real Estate, asks you to help her analyze the list price of all listed property by city and subdivision. She also wants to see which agent listed each property. You suggested that Ms. Miles add totals to each column to evaluate the properties using aggregate functions. She asks that you present the information in both PivotTable and PivotChart format. Refer to Figures 5.42 and 5.43 for help.

a. Open a05p1property. Click the File Tab, click Save Database As, and then type a05p1property_RobinSquires. Click Save.
b. Make a copy of City Listings query, and then name the copy Pivot City Listings.
c. Open the Agents table, and the replace Your Name with first (Robin) and last (Squires). Close the Agents table.
d. Open the Pivot City Listings query, and then click the PivotTable View icon in the bottom-right of the Access window. Close the Navigation Pane.
e. Drag the City field from the PivotTable Field List onto the Drop Row Fields Here drop zone.
f. Drag the Subdivision field from the PivotTable Field List onto the Drop Row Fields Here drop zone, to the right of the City field.
g. Drag the LastName field from the PivotTable Field List onto the Drop Column Fields Here drop zone.
h. Drag the ListPrice field from the PivotTable Field List onto the Drop Totals or Details Fields Here drop zone.
i. Click the first ListPrice column heading. Click AutoCalc in the Tools group., and then select Sum from the list.
j. Close the PivotTable field List. Compare the PivotTable to Figure 5.42. Save the query.
k. Click the PivotChart View icon in the bottom-right of the Access window. Close the Chart Field List.
l. Click the LastName arrow, click the (All) check cox to clear it, ad then click Your Last Name to select it. Click OK to apply the filter. Compare your results to Figure 5.43.
m. Compact and repair the database.
n. Close the database. Close Access.

Purchase this Solution

Solution Summary

Your pivot table is set up. You can have all name or just Robin by changing the pull down menu on the pivot. The pdf is attached and shows what the report looks like. I don't have a comparison chart to review.

Solution provided by:
Education
  • BSc, University of Virginia
  • MSc, University of Virginia
  • PhD, Georgia State University
Recent Feedback
  • "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
  • "Thank, this is more clear to me now."
  • "Awesome job! "
  • "ty"
  • "Great Analysis, thank you so much"
Purchase this Solution


Free BrainMass Quizzes
Lean your Process

This quiz will help you understand the basic concepts of Lean.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.