1. Change the design of the Customer table to speed up searches by email by specifiying that the E-mail Address column is indexed. Also set the default value in Web Page column to https://www.dom.edu. (2 points)
2. Change the design of the "Customers Query". Add columns Web Page and E-mail Address to the Query. Also, order the results of the query by [Last Name]. (3 points)
3.Create a new query called MGMT607Total using the table [Purchase Order Details] as input. Produce a grand total. This will be a single number that is the sum of Quantity * [Unit Cost]. The total should be 77921. (3 points)
4. Create a new query called MGMT607CatTotal using the query [Product Sales by Category] as input. Produce a total line for each category. You will need to GROUP BY Category and sum the Amount Column. Show only Category and the total Amount for each Category. (3 points)
5. Create a new report using the report wizard called MGMT607EmpByCity. Use the Employees table as input. Show last name and email address and City on the report. Tell the wizard to group by City. (3 points)