I need to know the steps on how to make the table & then the query. I have Microsoft Access but I can't seem to figure out how to get there.

4.10 From the database created in the comprehensive problem, perform queries based on the tables and query grid shown in Table 4- 199 a. Which borrowers use Advent Appraisers? b. What is the average amount borrowed from National Mortgage? c. List all of the property appraisers. d. List all of the lenders. e. List the lenders that lent more than $100,000. f. Which borrower requested the largest mortgage? g. Which borrower requested the smallest mortgage? Query1 x Borrower Lender Appraiser Property Appraiser Number Property Appraiser Name * Lender Number Lender Name Lender Office Address Borrower Number Last Name First Name Current Address Requested Mortgage Amount Lender Number Property Appraiser Number 8] Field: Table: Sort: Show: Criteria: or