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.