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
Use design view to create a query that lists members who are either required to have physical exams or have monthly fees greater than $ 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 $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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
