Question: Create a parameter query based on tblEmployee, tblMember, and tblMemberLessons so that when an employee s last name is entered, it will determine what members

Create a parameter query based on tblEmployee, tblMember, and tblMemberLessons so that when an employees last name is entered, it will determine what members have lessons scheduled with the employee. The query results should display FirstName and LastName from tblEmployee, FirstName and LastName from tblMember, and ScheduledDate and Fee from tblMemberLessons, in that order. The prompt should read [Enter the Employees Last Name]. Run the query, enter a Schilling when prompted, and then save as qryParameter. 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 Databases Questions!