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.

Question

Quizplus · Accepted Answer

Using the Form tool in Access to create a form when there are established table relationships, Access can automatically analyze these relationships and add a subform to display related records, such as showing Doctor table records related to a Patient record through a foreign key.

Steve Is Working in a Database That Holds Patient Data