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.

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.

updates all the students' credits all at once, not each one individually.

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

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!

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....

See Project 03-01 Assignment Spring 2015.docx Please Help me on this homework i am having some trouble answering it. Product SAP ERP GBI Release 6.04 Level Undergraduate Graduate Focus...

please I need this completed asap. If you need the username and password to log-in let me know \fInstructions City of Bingham Computerized Cumulative Problem For use with McGraw-Hill/Irwin Accounting...

I need Chapter 5 and Chapter 6 solutions to the "City of Bingham" continuous accounting problem from the 16e "Accounting for governmental & nonprofit entities" book. Instructions are posted...

At the year end, an analysis by the city?s finance department determined the following constraints on resources in the general fund. Prepare the appropriate journal entry in the general fund to...

i need all Journal entries for chapter 4 only see the file Instructions City of Bingham Computerized Cumulative Problem For use with McGraw-Hill/Irwin Accounting for Governmental & Nonprofit Entities...

1) Read the "Cybersecurity: the three-headed Janus" case posted under Module 2. Provide a summary of the vulnerabilities of Randcom's current information systems. Make sure to address each...

CASE EXAMPLE Google: who drives the strategy? Phyl Johnson, Strategy Explorers From an idea to a verb in less than 15 years: 'to Google - to search the Internet' If you are in need of the answer to a...

Before accepting a large shipment of bolts, the director of an elevator construction project checks the tensile strength of a simple random sample consisting of 20 bolts. She is concerned that the...

Write a paper about Sec rules on crowd funding "KICKSTARTER"

4. You are the manager of a monopoly that sells a product to two groups of consumers in different parts of the country. Analysts at your firm have determined that group 1s elasticity of demand is 3,...

Questions Q1. Write a Python program to retrieve the first and last colors from the following list: color_list = ["red", "green", "white", "blue", "black") Q2. Given the following dictionary,...