do as fast as possible work should be in microsoft access

Working in teams of two, create queries for a small Computer Consulting Company. The database is called "Consulting.accdb" constant contract work Session woniesionid frame hourly cond hour Word work Description quedi gry customer lowed company tortas province country country Code countrycode pode The employees of the company are consultants. The company sells their services to a number of customers. Each consultant has an hourly billing rate that can vary by consultant over time, which is why each work session record carries the hourly rate in effect when the work was performed. Each work session is charged against a contract so customers can attribute costs to their internal projects. o Multiple consultants could be assigned to work on the same contract. o Work cannot be billed outside of a contract's start and end dates. Write the following queries: 1. List all work session records for consultants hired between January 1, 1984 and January 1, 1999. a. Show the consultant's full name (lastName, firstName), date worked and the contract's start & end dates. Format dates as 10 Jan 2022. 2. Create a query that calculates the totalChargeBefore Tax and the totalRetailTax for each work session record. Apply a 10% discount if the totalChargeBefore Tax is greater than $500. a. Show the consultant's full name, date worked (10 Jan 2022), hours worked, hourly rate (customers rate) at the time, and your calculated totals. b. Tax hint: the work session references the contract, which references the customer, which references the province, which holds the provincial tax rate. You may ignore the federal tax rate