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.

OR

 

OR