Steve Is Working in a Database That Holds Patient Data

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.

Correct Answer:

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Access For Free