#Exp19_Access_Ch03_HOEAssessment_Property_Sales #Property_Sales #Property #Sales #HOEAssessment #HOEAssessment_Property_Sales #Ch03_HOEAssessment_Property_Sales #Exp19_Access_Ch03 #Ch03 #Exp19 #PropertySales #Exp19_Access #Exp19 #Access_Ch03_HOEAssessment_Property_Sales



Contact Me For Your Assignments and Courses

WhatsApp: +923096000718
Email :myitlabexpert@gmail.com
WhatsApp Direct Link: [ Ссылка ]



#Exp19_Access_Ch03_HOEAssessment - Property Sales 1.0
#Exp19 Access Ch03 HOEAssessment Property Sales 1.0
#Exp19_Access_Ch03_HOEAssessment_Property_Sales
#Exp19AccessCh03HOEAssessmentPropertySales
#Access Chapter 3 Hands-on Exercise Assessment - Property Sales




Project Description:
In the following project, using data on homes for sale that Amy and Zac acquired, you are able to target properties that meet specific criteria. As you examine the data, you discover other ways to analyze the properties. You create several queries and present your results to the two investors for their comments. You also create several totals queries to evaluate the property lists.



Start Access. Open the downloaded Access file named Exp19_Access_Ch03_HOEAssessment_Property_Sales. Grader has automatically added your last name to the beginning of the filename. Click Enable Content on the Security Warning message bar.
Now that you have opened the database, you begin your analysis by creating a query using the Properties and Agents tables from the Property database. The Properties table contains all the properties the investors will evaluate; the Agents table contains a list of real estate agents who represent the properties’ sellers. In this exercise, you will add requested fields and only show properties that have not been sold. You will then build an expression to calculate the price per square foot for each property.

Use Query Design to create a new query. The Show Table dialog box opens so you can specify the table(s) and/or queries to include in the query design. Add the Agents table then the Properties table. Close the Show Table dialog box.

Add the FirstName and LastName fields from the Agents table to the query. Add the ListPrice, SqFeet, and Sold fields from the Properties table to the query. Run the query and view the 23 properties that display in the query results.
Switch back to Design view and add No in the Criteria row of the Sold field. Sort the query in Ascending order by the ListPrice field. Run the query and view the 17 unsold properties in order from least expensive to most expensive.

Save the query as Price Per Square Foot.



Switch to Design view. In the Field row of the first blank column of the query design grid, right-click and select Zoom. Add PricePerSqFt: xListPrice/xSqFeet and click OK. Access inserts square brackets around the fields for you. Be sure that you added the extra x’s to the field names. You are intentionally misspelling the field names to see how Access will respond.

Run the query. In the first Enter Parameter Value dialog box, enter 200000 and click OK. Access does not recognize xListPrice in the tables defined for this query in the first record. When Access does not recognize a field name, it will ask you to supply a value.

Another Enter Parameter Value dialog box displays, asking that you supply a value for xSqFeet. Again, this error occurs because the tables defined for this query do not contain an xSqFeet field. Type 1000 in the second parameter box and press ENTER. The query has the necessary information to run and returns the results in Datasheet view. Examine the results of the calculation for Wrong Price Per Sq Ft. All of the records show 200 because you entered the values 200000 and 1000, respectively, into the parameter boxes. The two values are treated as constants and give the same results for all records.

Return to Design view and display the Zoom window. Correct the errors in the PricePerSqFt field by changing the formula to PricePerSqFt: [ListPrice]/[SqFeet] and click OK.

Run the query and adjust column widths as necessary. The new calculated field, PricePerSqFt, is displayed. The new field divides the values in the ListPrice field by the values in the SqFeet field.

Save and close the query.



#Exp19_Access_Ch03_ML2 - Investment Properties 1.2
#Exp19_Access_Ch03_ML2_Investment_Properties
#Exp19_Access_Ch03_HOEAssessment - Property Sales 1.0
#Exp19_Access_Ch03_HOEAssessment_Property_Sales
#Exp19_Access_Ch03_Cap - Brilton Madley Games 1.0
#Exp19_Access_Ch03_Cap_Brilton_Madley_Games
#Exp19_Access_Ch03_ML1 - Small Business Loans 1.0
#Exp19_Access_Ch03_ML1_Small_Business_Loans
#Exp19_Access_Ch03_CapAssessment - Retirement Accounts 1.1
#Exp19_Access_Ch03_CapAssessment_Retirement_Accounts
#Exp19_Access_App_CapAssessment - Student Loans 1.0
#Exp19_Access_Ch03_CapAssessment_Student_Loans

свернуть