| |
Create 3-Table Join Query
 Step 1
A query is the selection and/or joining of information from one or more tables.
In this case we are going to create a query we can use to display a student's name, school, and grade.
Create 3-Table Join Query
Step 2
Access 2000 - Select the Queries Selection from the menu at the left of the Access Database window.
Access 97 - Click on the Queries Tab at the top of the Access Database window.
Create 3-Table Join Query
Step 3
Access 2000 - Select Create Query in Design View.
Access 97 Select New / Design View / OK.
The Create Query Dialog Box will appear if you are using Access 97.
Create 3-Table Join Query
Step 4
A dialog box will open asking which tables to include in the query.
Create 3-Table Join Query
Step 5
A. Select StudentGrades. Select Add.
Select the next tables to include in the query.
B. Select StudentInformation. Select Add.
C. Select SchoolTable. Select Add.
D. Click Close.
Three tables will be displayed.
Both tables will be displayed in the Query window. (See below.)
Create 3-Table Join Query
Step 6
Now you will select the fields to place in the query.
Click on the StudentLastName field in the StudentGrade table.
Drag the selected item (StudentInformation/StudentLastName) to the first column.
Create 3-Table Join Query
Step 7
Now you will select the remaining fields to place in the query.
Drag the StudentInformation/StudentFirstName to the second column.
Drag the SchoolTable/SchoolName to the next column.
Drag the StudentGrade/Grades to the next column.
Notice the fields listed in the Design Query Dialog Box.
Create 3-Table Join Query
Step 8
Link the three tables together in the Query.
Using Drag and Drop, connect StudentLastName in the StudentInformation and StudentGrade tables.
Connect StudentFirstName in the StudentInformation and StudentGrade tables.
Connect SchoolID in the StudentInformation and SchoolTable tables.
Create 3-Table Join Query
Step 9
Three lines joining the tables will appear.
Create 3-Table Join Query
Step 10
Save the query. Give the Query a name, such as, StudentSchoolGrade.
Create 3-Table Join Query
Step 11
To view information, double-click on the Query, in the Queries Tab of the Access database window.
Click on StudentSchoolGrade and the information displayed should look similar to example shown below.
Create 3-Table Join Query
Step 12
Close Access
Note: Your database is automatically updated and saved as you exit out of Access.
Never shut Access down before saving.
Always exit out to save your work.
|