“Query” with multiple tables

The power of “Access” is the ability to analyze information from multiple tables.

“Relationships” between these “Tables” and “Queries” allows us to do so.

In this example, I use three related “Tables”: “Students”, “Results” and “Subjects” that I’ve created.
The table “Results” is the table that includes the “Relationship” between the different “Tables”.

The purpose of this “Query” is to view the results of each student for each subject.

Select the “Create” tab in the “Ribbon” and click the “Query Design” button.
In the “Show Table”, I add the above tables to the “Query” window.
You can see the various fields in these tables in the image below.

In the “Students” table, I double-click “Last Name” and “First Name ” fields.
In the “Results” table, I double-click the “Score” and “Grade” fields.
And from the “Subjects” table, I double-click the “Subject” field.

This aside:
When a field from the table is inserted in the grid has been installed, you can see the position of this field in the grid.

1. o select the column (place mouse pointer above the top of the column)
2. When it changes in a downward pointing arrow, click the mouse pointer (the color of the column becomes black)
3. Drag it to the desired position in the grid. The position in the grid is represented by a thick black line.

This is what I currently have.

When I click the “Run” button in the “Ribbon”, the result is displayed.

Save the query under an appropriate name, by clicking the “Save” button in the “Ribbon”.

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats