ClientID Is the Primary Key Field in the Clients Table

question 43

Multiple Choice

ClientID is the primary key field in the Clients table, which is related to the Projects table through its ClientID foreign key field. In Access, what option should you select to update the ClientID field values in the Projects table if the ClientID field values change in the Clients table?

• A)Entity Integrity
• B)Cascade Update Related Fields
• C)Cascade Delete Related Records
• D)Validation Rule Property

---

Definitions:

Uncollectible Accounts Receivables

Accounts receivable that a company does not expect to collect and must write off as a loss because the debtor is unable to pay the owed amount.

Merchandise

Goods that are bought and sold in business; the commodities or items that a business trades in.

Journal Entry

A record in the books of accounts that represents a single financial transaction, documented in chronological order and showing the debits and credits for each transaction.

Terms N/30

Payment terms indicating that an invoice must be paid within 30 days of the invoice date.