Which of the following are the ways to create a join between two tables in Microsoft Access 2010?

Which of the following are the ways to create a join between two tables in Microsoft Access 2010?
Each correct answer represents a complete solution. Choose all that apply.

A.
Select two tables for the query that have a field in common.

B.
Use the Object Dependencies pane available on the Relationships group.

C.
Modify the default join behavior.

D.
Create relationships between the tables while designing the database.

Explanation:
Following are the three ways to create a join between two tables in Microsoft Access 2010:
1.Create relationships between the tables while designing the database.
2.Select two tables for the query that have a field in common. This field has the same name and data
in both tables.

3.Modify the default join behavior.
Answer B is incorrect. The Object Dependencies pane is available on the Relationships group in the
Database Tools tab. It demonstrates the interactions or dependencies of all database objects. It
helps in preventing record sources from being accidentally deleted. It also displays how other
objects are affected by the design change whenever any change is made in the design of an object.