Question: Create a query that will list EVERY book title and the date it was borrowed. Include all books in your result. Save as qry_p11_qry1. Create

Create a query that will list EVERY book title and the date it was borrowed. Include all books in your result. Save as qry_p11_qry1.

Create a query to list EVERY library member and the dates they borrowed books. Include all members. Save as qry_p11_qry2.

Create a query that will list book titles and call numbers that have never been borrowed. Save as qry_p11_qry3.

Create a query to list any members (name, ID) who have not borrowed a book. Save as qry_p11_qry4.

let me know where to enter the values to create a 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 Accounting Questions!