In order to retrieve data from two or more tables through a query, we must establish a _____ between tables.
Understand the Problem
The question is asking what must be established in order to retrieve data from two or more tables through a query, presenting multiple-choice options.
Answer
relationship
The final answer is relationship.
Answer for screen readers
The final answer is relationship.
More Information
To retrieve data from multiple tables, establishing a relationship usually involves matching data in key columns that serve as common identifiers in those tables.
Tips
A common mistake is confusing the establishment of a relationship with using specific SQL JOIN operations.
Sources
- Define relationships between tables in an Access database - learn.microsoft.com
- Relationships between tables in a Data Model - support.microsoft.com
AI-generated content may contain errors. Please verify critical information
Thank you for voting!
