Question: Create a query that updates students ’ credits to account for the book

Question

Question: Create a query that updates students ’ credits to account for the books they ’ ve ordered and received. Click theRun button to test the query. When prompted to change the records, answer “ Yes. ” Save the query as Credit Update.

I need to do this in Microsoft Access and I cannot for the life of me figure it out. Here are my tables:

"Students Table"

"Credits" Table

"Books" Table

Student IC | Last Name B-17 F-59 L-29 M-62 May P-91 Q-13 S-63 Z-30 | First Name Address City State Zip Cell Phone Telephone Email Address 19101 215-876-3376 215-877-4673 abrew@yahoo.com 19111 215-765-1263 215-877-2342 gf59@gmail.com 19101 569-001-0989 215-234-8876mrl@yahoo.com 19111 215-887-3829 215-998-3928 belle@comcast.net 19101 215-342-9087 215-887-9238 jp82@comcast.net 19125 569-984-3894 215-987-3427 quinn45@gmail.com 19111 235-121-4736 215-763-3342 patti1@gmail.com 19125 215-776-4536 215-675-0091 zeconj@comcast.net 9 Pleasant Way Philadelphia PA Brewster Freeny Lopez Angela Maria Allie Jane Samantha 59 W. Central Ave Philadelphia 89 Orchard 54 Oak Ave 1700 E. Lincoln Ave Philadelphia 58 W. Central Ave Philadelphia PA Philadelphia PA Philadelphia PA PA PA Pettyjon Quinn Zecon Joyce

Explanation / Answer

Please refer the Below Query

Replace respective values with in "<>" in below query

Plese comment if you need any furthur support

UPDATE Credits c set c."Number of Credits" = c."Number of Credits" + (select b.Credits from Books b where b."Book ID" = <replace with book id issued>) where c."Student ID" = <replace student id to whom book is issued>

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.