Question: how to create a relational database in access 2016?
Answer: Open the Relationship Dialog. Click Relationships from the Database Tools tab on the Ribbon. ... 
Select the Tables. Select both the Artists and Albums tables from the list and click Add . ... 
Create the Relationship. Click and drag the Albums. ... 
Edit the Relationship. ... 
The Relationship.