Microsoft Access Joins – The Benefits Of Using The Outer Join

Microsoft Access Joins – The Benefits Of Using The Outer Join

One of the strengths to running reports is the ability to control Microsoft Access joins and in this case using an ‘Outer Join’ or a Left or Right join you now have the extra scope to find non matching records across two or more tables in an Access database.

Here’s a a three minute demonstration of how to set an Access join (Outer join).

Microsoft Access Joins – The Benefits Of Using The Outer Join

access joinsIn this video, a useful mention for Access joins is to apply the ‘Is Null‘ criteria to filter out matching records and leaving you with non-matching records as the case with customers to order relationship yet to place their first order.

 

To learn more about the different types of Access joins and their properties, I have written an eBook called Understanding Access Database Relationships and is a must read for your database knowledge and design plans.

This entry was posted in Database Theory, MS Access, Queries and tagged , , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Confirm you are human.