How to Link Tables in MS Access
- George Apostolov
This guide is an interactive LiveDemo. Create interactive demos of your own product: Interactive demo software · Interactive customer onboarding guides · Start free
How to Link Tables in MS Access: step-by-step guide
Open the Access database where you want to link the tables. Go to the 'External Data' tab in the ribbon.
Click 'New Data Source', select 'From Database' and click on the 'Access' button.
If you choose 'Access', click 'Browse' to locate the source Access database.
When prompted, choose the 'Link' option. This ensures the data remains in the original location, and you interact with it in your current database.
Click 'OK'.
A dialog box will appear listing available tables or sheets. Select the table you want to link. Click 'OK' to confirm.
The linked tables will appear in the 'Navigation Pane' with a small arrow icon, indicating they are linked.
Quick answer: To link tables in MS Access, open your database, navigate to the External Data tab, select New Data Source, and choose From Database and Access. Browse to locate the source database, select the Link option, click OK, choose the desired table from the dialog box, and click OK.
About this tutorial
Connect external data by linking tables within the app, keeping original files intact while managing them directly from your navigation pane. This guide shows how to link Tables in MS Access in 7 steps, starting with "Open the Access database where you want to link the tables. Go to the 'External Data' t..." and finishing with "The linked tables will appear in the 'Navigation Pane' with a small arrow icon, indicat...". The interactive demo above is a click-through copy of the real product interface, so you can rehearse each step before doing it in your own account.
Frequently asked questions
How many steps does it take to link Tables in MS Access?
7 steps. Each one is listed in order above, and the demo highlights exactly where to click.
Can I try it without changing my own account?
Yes. Clicking through the demo doesn't touch your data or settings. Once you know the flow, repeat it in your own workspace.
Create your first interactive demo in minutes
No credit card required • Start building today





