77-885 · Question #109
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.
The correct answer is A. Select two tables for the query that have a field in common. C. Modify the default join behavior. D. Create relationships between the tables while designing the database. 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…
Question
Options
- ASelect two tables for the query that have a field in common.
- BUse the Object Dependencies pane available on the Relationships group.
- CModify the default join behavior.
- DCreate relationships between the tables while designing the database.
How the community answered
(17 responses)- A82% (14)
- B18% (3)
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
Topics
Community Discussion
6
Costin D.May 22, 2026The correct answers are A, C, and D. Access will automatically detect a join when you drag two tables into the query designer that share a matching field, and it will draw the join line for you without any extra steps. You can also set up the relationship ahead of time in the Relationships window under Database Tools, which is the cleaner, more intentional approach and the one that enforces referential integrity across the whole database. Modifying the default join behavior, meaning right-clicking the join line to switch between inner, left outer, or right outer joins, absolutely counts as a valid way to define how the join works between those two tables. B is the trap here, the Object Dependencies pane tells you what objects rely on other objects, it has nothing to do with creating or managing joins.
Bao N.Jun 1, 2026B is the trap here and it trips people up because it sounds official enough to seem right, but Object Dependencies just shows you which objects rely on other objects, it has nothing to do with creating a join. The three real paths are A, C, and D. A works because Access will auto-detect a join when two tables share a matching field name and data type in the query design grid. D is the more permanent route through the Relationships window, and C covers the case where you already have a join line but need to change it from the default inner join to a left or right outer join, which Access treats as a separate join configuration. My only gripe with the wording on C is that "modify" sounds like it assumes a join already exists, but the exam writers count it as a creation method because you end up with a join type that would not otherwise be there.
Ingrid P.Jun 10, 2026B is the trap, Object Dependencies is not a join method. A, C, D.
Orla P.May 27, 2026What does Object Dependencies actually do, compared to the Relationships window?
Samuel O.Jun 7, 2026A, C, D are right, B is made up, there is no such pane.
Ingrid P.Jun 8, 2026B trips a lot of people because the distractor pane names sound plausible, so worth making a card for exactly what panes do exist in that interface and drilling it until the wrong ones stop feeling right.