| |
Create 2-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 create letters for students’ concerning academic progress and grades.
Create 2-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 2-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 2-Table Join Query
Step 4
A dialog box will open asking which table to include in the query.
Create 2-Table Join Query
Step 5
A. Select StudentGrades. Select Add.
Select the next table to include in the query.
B. Select StudentInformation. Select Add.
C. Click Close.
Both tables will be displayed in the Query window. (See below.)
Create 2-Table Join Query
Step 6
Now you will select the fields to place in the query.
Click on the StudentName field in the StudentGrade table.
Drag the selected item (StudentGrade/StudentName) to the first column.
Create 2-Table Join Query
Step 7
Now you will select the remaining fields to place in the query.
Drag the StudentGrade/Grades to the second column.
Drag the StudentInformation/Street to the third column.
Drag StudentInformation/City, StudentInformation/State, StudentInformation/Zip to the next 3 columns.
Create 2-Table Join Query
Step 8
Link the two tables together in the Query.
Drag the field the 2 tables have in common (StudentName) from the StudentInformation table to the StudentName field in the StudentGrades table.
A line joining the two tables will appear.
Create 2-Table Join Query
Step 9
Save the query.
Give the Query a name, such as StudentInformationAndGrades.
Create 2-Table Join Query
Step 10
To view information, double-click on the Query in the Queries Tab of the Access database window.
Create 2-Table Join Query
Step 11
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.
|