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:

Credits Table

Student ID Number of Credits
B-17 24
F-59 30

Orders Table

Student ID Book ID
B-17 101
B-17 102
F-59 101
F-59 105

Books Table

Book ID Book Title Credits
101 English I 3
102 Accounting 5
105 Calculus 5

Explanation / Answer

The query for the updating the students tableare as follows

UPDATE Credits
SET Number_Of_Credit= 24
WHERE StudentID ="B-17";

UPDATE Credits
SET Number_Of_Credit= 30
WHERE StudentID ="F-59";

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

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