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.

NOTE: I am looking for an update query that updates all the students' credits all at once, not each one individually.

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

"Orders" Table

***EDIT*** Sorry, I don't know how I left out the orders table.

Relationships

I am not sure if this is how I should have the relationships set up so please let me know if I should do it a different way.

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