Find Out About The Join Property In An Access Query

If you've used table relationships in Access and created queries to show data from more than one table, then the join property can be a very useful way to control what data is displayed in the query. This article recaps how to create a one to many relationship and then summarises how to use the join property in an Access query, and describes the two basic kinds of join properties, an inner join and outer join. The join property is only used in Access queries which are based on related tables.

The full article appears here:
http://www.microsofttraining.net/article-1713-join-property-in-access-query.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com