Steve Is Working in a Database That Holds Patient Data

question 13

Multiple Choice

Steve is working in a database that holds patient data for a medical center. A patient's identification number serves as a primary key in the Patient table. A patient's identification number serves as a foreign key in the Doctor table. Steve wants to create a Form that displays Doctor table records with foreign key values that match the primary key value in the Patient table. How should Steve proceed?

• A) Use the Form tool to create the form and Access will analyze the table relationships Steve created in the database, and automatically add a subform to his form.
• B) Use the Form tool to create the form and Access will analyze the table relationships Steve created in the database, and automatically add a Split form to his form.
• C) Use the Form tool to create the form and Access will analyze the table relationships Steve created in the database, and automatically add a Multi-items form to his form.
• D) Steve can only create a form that displays one record source at a time.

---

Definitions:

Creditors

Individuals or institutions to whom money is owed by a debtor for goods, services, or loans provided.

Investors

Persons or organizations that invest funds anticipating financial gains in return.

Balance Sheet

A financial statement that presents a company's assets, liabilities, and equity at a specific point in time, providing a snapshot of its financial condition.

Stockholders' Equity

Stockholders' equity represents the ownership interest of shareholders in a company, calculated as total assets minus total liabilities.