Create a query from two tables

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.

1. From the Database Main Window, select the Queries Tab.



2. Select New.



3. Select Design View.



4. Click OK.







A dialog box will open asking which table to include in the query.


5. Select StudentGrades.
   Select Add.



6. Select StudentInformation.
   Select Add.



7. Click Close.

Both tables will be displayed in the Query window. (See below.)




Now you will select the fields to place in the query.
Click on the StudentName field in the StudentGrade table.


8. Drag the selected item (StudentGrade/StudentName) to the first column.
9. Drag the StudentGrade/Grades to the next column.
10. Drag the StudentInformation/Street to the next column.
11. Drag the StudentInformation/City to the next column.
12. Drag the StudentInformation/State to the next column.
13. Drag the StudentInformation/Zip to the next column.



14. Link the two tables together in the Query, by dragging the field they have in common (StudentName) from the StudentInformation table to the StudentName field in the StudentGrades table.



15. Click on Close.



16. Click Yes, you want to save your work.



17. Give the Query the name, such as, StudentInformationAndGrades.



18. 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.

Top of Page

Copyright 1997 - Technology Training Team

Please contact us at TechTrainTeam