How to Define the Correct Join Type Between Microsoft Access Tables

Save
Next Video:
How to Delete a Relationship in Microsoft Access....5

In order to define the correct join type between two tables in Microsoft Access, it's necessary to look at the relationship view of the table structure. Learn about regular join operations in Microsoft Access with help from a computer programming teacher in this free video on Microsoft Access.

Part of the Video Series: Microsoft Access Tutorial
Promoted By Zergnet

Comments

Video Transcript

Hi my name is Chip Browne. I teach computer programming in Microsoft applications at Stevens Henagar College here in Utah. I also create practice tests for Microsoft Office specialist certification exams. Today we are going to learn how to define the correct join type between two tables using Microsoft Office Access 2007. Microsoft Access is a registered trademark of Microsoft Corporation. I'm not affiliated with Microsoft Access. To define the correct join type between two tables it is necessary to look at the relationship view of the table structure. Click on data base tables and then click on relationships in the show high group. Here is the display of the relationships view of our table structure. Each of the squares represents a table in the field in that table. The key icons represent the primary key. The relationships between the tables are represented by the dark black lines. If there is a 1 pointing here it would indicate that 1 and only 1 record would belong in this relationship and here represents many in this table. What that means is there is a 1 to many relationship. Many orders per customer, 1 customer per order. To define these relationships while you are defining them you will see a dialog that looks like this where the first field is the table on the right, the second is the table on the left and these are the fields of that join but here is where you define join type. You click here. You are given three options. The first option indicates a regular join operation where the records on the right table will be combined and joined with the records on the left table on the certain fields that are pointed to. If, however, we choose option 2 for a join type that means that all the records on the right table and only those records on the left table where the join fields are equal. Join number 3 is where all records on the left table and only those on the right table where the join fields are equal are displayed. These are called a right outer join when all the records from the right table are in the resultant query or a left outer join when all the records from the left table are in the resultant query. These are the ones, the different types of join types when you are defining relationships between tables. For more information and videos visit me Chip Browne, at chipbrowne.com.

Featured

Related Searches

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!