The Patients table and the Visits table have a one-to-many relationship, with the Patients table being the parent table.Which of the following would you use the Find Unmatched Records Wizard to find?
A) Orphan records in the Visits table
B) Records in the Patients table that have no related records in the Visits table
C) Duplicate records in the Visits table
D) Statistics for groups of records in the Visits table

Question

Quizplus · Accepted Answer

The Find Unmatched Records Wizard would be used to find records in the Patients table that have no related records in the Visits table, or "orphan" records. This is because the Patients table is the parent table in the one-to-many relationship with the Visits table, and it is important to ensure that all patients have recorded visits. The other options listed are not relevant to the Find Unmatched Records Wizard.

The Patients Table and the Visits Table Have a One-To-Many