How to create a relationship in access?

Creating a relationship in MS Access can be done in more than one way, but the most popular way is by using the Relationships screen. In MS Access 2010, to open the Relationships screen go to the Database Tools tab and then click the Relationships button on the ribbon.

On opening the Relationships screen Access will show you the Show Table window. In this window you can select the tables that you want to create relationships for. You can add more tables to the Relationships screen later by dragging them onto the screen from the list on the left.

In order to create a one-to-many relationship select and drag the primary key of a table over a field in another table and release the mouse button. This will open the Edit Relationships panel, which allows you to set the properties of the relationship.