1. Create a query called CustServerdAfter to show the customer information for all customers who received service after 12/15/2007.

2. Create a query called TechsHiredAfter that shows the technician name (first and last) and the technician number for those technicians hired after January 1, 2005.

3. Create a query called TotalNumPartsUsed that shows that the sum of the qty field in the service-parts-detail table. The field produced by this query should be called total number parts used.

4. Create a query called TechsDuring that shows the service call numbers for service calls during the weeks 12/4/16 through 12/18/16, inclusive in which technicians with tech number 4 or 17 were the technician.

5. Create a query GerrysCusts that shows all customer names serviced by the technician, Gerry Robinson.

6. Create a query called TotalPricePartsUsed that shows the total amount charged for parts for all of the service calls. You need to join service-parts-detail and parts tables and create a calculated query field that multiplies qty and price. The field produced by this query should be called the total parts price charged.

7. Create a query called TotalLaborChargePerCall that shows the price of labor charged for each call as a calculated field, along with the call-num from the service-labor-detail table.

8. Create a query called TechsHelpingCustomers that shows the technician names and customer names where the named technician had a call to help the named customer. Query 1 will find all customers who received service after 12/15/2007.

9. Create a query called PartsUsed that shows the technician name, part number, part description, and the number of that part used by the technician on any service call.

10. Create a query called PartMargin that shows the total difference for each customer (by name) between the cost of the parts used in the customer service and the price charged to the customer (the margin).

Use the summation and group by feature to get a single margin total for each customer. Youll have to include the customer, service-call, service-parts-detail, and parts tables, although you will only display information from customer and parts. Create a small database in Microsoft Access from scratch and how to extract information from that database. Youll submit your Microsoft Access file as your response to this lab. Designing queries to retrieved information from the database.