Using RealEstate_2003.mdb, create the following queries:
1. PricePerSqFt: [SalePrice]/[SqFeet]
a. verify query results using Excel
b. format as currency in query results
2. Demonstrate query error – incorrect field name spelling sqSfet/sqSfeet
3. Three tables query linking SubDivisionID – and SellingAgent to ID
4. Expression builder: Create new field qryPricePerSqFt: [SalePrice]/[SqFeet]
5. Change agent Angela Scott to your name
6. Calculate calculated sale PricePerBedroom—requires getting field from PropertiesTable
7. Shift-F2 = expands window
8. Edit expressions using expression builder
9. Function in query –
a. Buyer puts 10% down, therefore 90% to finance AmountFinanced:[SalePrice]*.9
b. Expression builder pmt([.065/12, 30*12,[AmountFinanced])
10. Date Math – how many days on market MarketDays:[DateSold]-[DateListed]
11. Commission: [SalePrice]*.07 – format as currency
12. Add Totals Button – GroupBy Sum of all sales, Average Days on Market, Sum of All Commissions
13. Compact and repair database
