How do you create a one-to-many relationship in Access?
What will be an ideal response?
A one-to-many relationship between two tables is created by:
a. Making sure that the two tables have a field in common, usually the primary key from the one-side table. That field is made the foreign key in the many-side table.
b. Using the Relationships window, you connect the primary key to the foreign key.
c. Populating the foreign key.
Computer Science & Information Technology
You might also like to view...
In the function =COUNTA(FirstName), FirstName is an example of a(n) ________ range
A) named B) column C) defined D) data
Computer Science & Information Technology
The Trust Center is a tool for users to add ________ that the user knows are secure to minimize security breaches within an Access database
A) user names B) Web addresses C) locations D) network paths
Computer Science & Information Technology