[Solved]Create New Query Design View Based Tblathlete Tblleve Tables Add Levelname Field Tbllevel Q37288440

Create a new query in Design View that is based on the tblAthlete and tblLeve tables. Add the LevelName field from the tblLevel table to the query design. Add the FirstName and LastName fields from the tblAthlete table. Add the MonthlyFee field from the tblLevel table. Save the query with the name qryAnnualDuesByAthlete, run the query, ana then complete the following tasks: In Design View, add a calculated field named AnnualDues to the query a. esign in the fifth column of the design grid that determines the total annual cost of skating dues for each athlete. The expression should multiply the monthly fee amount by 12 months. Set the Caption property Annual Dues for the calculated field. b. Save and run the query. Resize the Annual Dues column to best fit the data it contains. c. Add the Total row to the query datasheet, and then use a function to calculate the average monthly fee and the total annual dues. Show transcribed image text Create a new query in Design View that is based on the tblAthlete and tblLeve tables. Add the LevelName field from the tblLevel table to the query design. Add the FirstName and LastName fields from the tblAthlete table. Add the MonthlyFee field from the tblLevel table. Save the query with the name qryAnnualDuesByAthlete, run the query, ana then complete the following tasks: In Design View, add a calculated field named AnnualDues to the query a. esign in the fifth column of the design grid that determines the total annual cost of skating dues for each athlete. The expression should multiply the monthly fee amount by 12 months. Set the Caption property Annual Dues for the calculated field. b. Save and run the query. Resize the Annual Dues column to best fit the data it contains. c. Add the Total row to the query datasheet, and then use a function to calculate the average monthly fee and the total annual dues.

Expert Answer

---

Answer to Create a new query in Design View that is based on the tblAthlete and tblLeve tables. Add the LevelName field from the t… . . .