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:

Vestibular Senses

The sensations generated by receptors in the semicircular canals of the inner ear that inform us about the head’s orientation and movements.

Olfaction

The sense of smell, which is the ability to detect and interpret airborne molecules.

Vestibular Receptors

Sensors located in the inner ear that provide the brain with information about motion, head position, and spatial orientation; critical for maintaining balance.

Inner Ear

The deepest part of the ear, containing the cochlea and vestibular system, responsible for hearing and balance.