Share
Explore BrainMass

Miles Real Estate Access Query List price by city subdivisio

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.

Attachments

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.

$2.19