Question: 1 . Use design view to create a query that lists members who are either required to have physical exams or have monthly fees greater

1. Use design view to create a query that lists members who are either required to have physical exams or have monthly fees greater than $40. Add both tables to the design grid. In the query results, display the FirstName and LastName fields from the Member table, and the ProgramType, MonthlyFee, and PhysicalRequired fields from the Program table. Sort the records in descending order by LastName. Select records only for members required to take a physical or have monthly fees greater than $40(both conditions need to be set in design view). Save the query as Physicals or High Fees. Run the query to confirm accuracy of the resulting datasheet, then save and close the query.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!