Relational database in Microsoft Access

How to create a simple relational database

This video explains how to create a link between Microsoft Access tables to facilitate the first steps in a relational database. The video also explains how to view and edit the join properties feature and run queries based on different join options.

The content of this video is covered on the Microsoft Access course, to see the course outline click here. If you wish to complete an online course in your own time, click here.

All our courses offer after course support via email and video, which is the format shown below. To book a course email or call 01670 732139. Courses can be delivered onsite using our laptops or at our training venue in Gateshead.

Linking Tables

Before you can link tables you must create a primary key and a foreign key to use as links. Once that has been achieved, select the Database tools options from the ribbon and drag the tables you require on to the screen. Once the tables are on the screen you should see the primary key and the foreign key. Drag from one to the other, it does not matter which way round you do it. You will now see the Edit Relationship box. Make sure you select the Enforce Referential Integrity option, this will stop orphan records being created. Also check that the relationship is what you require, One to Many, One to One or Many to Many relationship. In the video example there is a One to Many link in use.

Join Types

Once you have created your links you can now create a query based on your related tables. When you run a query where data comes from more than one table, you will only see records that appear in both related tables. However, if you change the join type to 2 or 3 to create either an outer or inner join, then the data displayed will include none related records as well.

Leave a Reply

You must be logged in to post a comment.


“Steve delivered a number of Microsoft Office Training Sessions to a range of employees across Newcastle College. The service provided by Steve is second to none. I have no hesitations in recommending him to other employers.”

Christine Jackman
Learning Manager(North) - Winner of Training Programme of the Year NECCA

“I studied with Steve when we completed our CiPD CTP together. During the course I found Steve to be very personable and also very professional.  Steve was first on my list of suppliers. Steve was very competitively priced and very accommodating.”

Simon Snowdon
European Training Manager at HP Enterprise Services

“Steve’s background in IT training clearly provided him with great organisational and managerial skills which he put to good use at Second Chance Enterprises. His ability to see the long term strategy as well as manage the day to day management is one of his biggest strengths.”

Chriss Graham
Project Coordinator at Daisy Group

“The course was really thorough and Steve was very knowledgeable and explained things very well. I’ve not used Microsoft Project before but now I feel very confident that I’ll be able to use it for what I need to do in my job”.

Craig Forster
Estimator, John F Hunt Regeneration Ltd