Case 19-3 Linda has recently started her job as a nursing supervisor at Hankons Cancer Treatment Centre. As part of the job, she has to look into the database of all the currently admitted patients and their ongoing treatment status.
Linda uses forms in Microsoft Access 2016 to display data from two or more related tables at the same time. This offers a complete picture of the information in the patient database. If Linda has to create a form based on two tables labeled Patient Identity and Patient Illness, the two tables should have _____.
A)a defined relationship
B)a secondary table within the primary table
C)matching data entries
D)unique records that are not used in any other table

Question

Quizplus · Accepted Answer

A defined relationship between tables is necessary in Microsoft Access to create forms that display data from two or more related tables. This relationship ensures that the data displayed in the form is correctly associated between the tables.

Case 19-3 Linda Has Recently Started Her Job as a Nursing