How do you create a relationship between two tables in Access?

Creating a relationship between two tables in Access is accomplished through the 'Relationships' tool found in the Database Tools tab. This feature allows users to visually establish how two tables are connected by defining the primary and foreign keys. Through this interface, you can set rules for referential integrity, which helps maintain consistent and valid data across the tables.

When engaging with the Relationships tool, users can drag and drop fields between tables to create the necessary connections. This method ensures that the data from one table relates accurately to data in the other, resulting in a more structured database that can leverage these relationships for queries, forms, and reports.

The other options, such as creating a new query or using the Report Design tool, do not directly establish relationships between tables. Queries can use relationships to pull data but do not create them. Importing data from an external source also doesn’t establish relationships; it merely adds data to the tables, assuming that relationships have already been defined. Thus, the correct choice highlights the appropriate method for linking tables in Access effectively.