| |
Create Simple 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 to select students whose last name is "Jones".
Create Simple 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 Simple 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 Simple Query
Step 4
A dialog box will open asking which table to include in the query.
Create Simple Query
Step 5
Select the table to include in the query.
Select StudentInformation. Select Add.
The table will be displayed in the Query window. (See below.)
Create Simple 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 Simple Query
Step 7
Now you will select the remaining fields to place in the query.
Drag the StudentInformation/Street to the second column.
Drag StudentInformation/City, StudentInformation/State, StudentInformation/Zip to the next 3 columns.
Create Simple Query
Step 8
Select the last name of "Jones".
In the Criteria area type the last name you are retrieving.
Create Simple Query
Step 9
Save the query.
Give the Query a name, such as StudentLastName.
Create Simple Query
Step 10
To view information, double-click on the Query in the Queries Tab of the Access database window.
Create Simple 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.
|