Query Pulling Data From Multiple Tables Access

When creating a query based on many tables its important to only add in the tables that are needed in the query design. Add in too many or too few will result in incorrect dynasets. What's important is that there is a clear relational linkage between the tables. This should represent a chain of relationships between a table on one side of the design view that snakes it's way through other tables to the table on the opposite side of the relationships.
The view that you see in the design view of Access 2013 is similar to the relationships view. It is through these relationships that query is able recognise which records to return and which records to filter.

[danielblyth]

Finally a video that gets straight to the point, thankyou!

[muhammadmuhammad]

Thanks pleased help me I want design and create database with table following the table 1 I'd 2 admission number 3 Name 4 courses 5 gender 6 age 7 adress