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.