What Type of Query Should You Create If You Want

question 6

Multiple Choice

What type of query should you create if you want to change a manager's name from "Jones" to "Ames" for all selected records?

• A) Update
• B) Select with self join
• C) Is Null
• D) Append

---

Definitions:

Permanent Accounts

Accounts that carry their ending balances over to the next accounting period. Examples include assets, liabilities, and equity accounts.

Post-closing Trial Balance

A listing of all active general ledger accounts with their balances after closing entries are made, serving as a check to ensure debits equal credits before beginning a new accounting period.

Income Statement

A report that outlines a company's financial results for a certain period, including income and expenditures, to reveal a net gain or deficit.

Balance Sheet

A report detailing a corporation's assets, liabilities, and the equity of its shareholders at a particular moment.