How do I link two tables in Access?

Question

You do that by following these steps: Click the Database Tools tab on the Ribbon. . From the Relationships group, click the Relationships button. . For each pair of tables you want in the relationship, click the table and then click Add. . After you finish adding tables, click the Close button.

Can you link two tables together in MS Access?

You can create links to multiple tables in a single linking operation. A linked table is created for each source table. You cannot link to a table that is already a linked table in the source database.

How do you link tables in Access?

To link to a table from another Access database, select the EXTERNAL DATA tab in the toolbar at the top of the screen. Then click on the Access button in the Import & Link group. Next, click on the Browse button and find the Access file that contains the tables that you wish to link to.

How do you link two tables in Access Query?

Build a select query by using tables with a many-to-many relationship1On the Create tab, in the Queries group, click Query Design.2Double-click the two tables that contain the data you want to include in your query and also the junction table that links them, and then click Close.Create a query based on multiple tables - Microsoft Support

Expert · Answer