You are working on a home computer with Microsoft Office 2010 installed on it. The computer has
two tables named Projects and ProjectDetails created in Microsoft Access 2010. Both tables are
connected with each other by a one-to-one relationship. You find that there is no need of
relationship between them. What will you do to completely remove the relationship between the
tables?
Each correct answer represents a part of the solution. Choose three.
A.
Click on each table and press the Delete key.
B.
Click on the line that connects both the tables and press the Delete key.
C.
Choose the tables from the Navigation Pane and click the Delete button.
D.
Open the Relationships window.
Explanation:
In order to completely remove the relationship between tables, you should take the following steps:
1.Open the Relationships window.
2.Click on the line that connects both the tables and press the Delete key.
3.Click on each table and press the Delete key.
Answer C is incorrect. It deletes the table that you choose in the Navigation Pane.
1.Open the Relationships window.
2.Click on the line that connects both the tables and press the Delete key.
3.Click on each table and press the Delete key.