1. Open the CustomersWithoutHomes query in Design View and perform the following tasks:
   1. Change the join property for the relationship between the Customers and Homeowners tables to select ALL records from the Customers table and only those records from the Homeowners table where the joined fields are equal.
   2. Add the Is Null criteria for the PolicyNumber field and add an Ascending sort order on the LastName field. Save the changes to the query. Open the query in Datasheet View and confirm that there are 21 records in the query result. Close the query, saving if necessary.
2. Open the UniqueStates query in Design View. Modify the query to list all states only once. Save the changes to the query. Open the query in Datasheet View and confirm that there are 15 records in the query result. Close the query, saving if necessary.
3. Create a crosstab query based on the MidAtlantic table with the following options:
   1. Use only data from the MidAtlantic table in the crosstab.
   2. Use the State field for the row headings.
   3. Use the City field for the column headings.
   4. Use a Count of the CustomerID field as the calculated value for each row and column intersection, and include row sums in the crosstab query.
   5. Save the query using State-City Crosstabas the name. View the query, then save and close it.