1 Start Access . Open the downloaded Access file 0 namedexploring _ a03 _ grader _ h3 . accdb .
2 Create a new query in Design view using all three
10 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 .
3 Add criteria to the query to ensure that the DateSold 8 field is not empty .
4 Format the SalePrice field as Currency . Save the query 8 asSales Report .
5 Create a calculated field in the first empty field
9 namedDaysOnMarket that will calculate the number of days each sold property was on the market when it sold . Add a caption of Days on Market .