Home > Administrative Offices > Information Technology > Helpdesk > Step by Step Tutorials > Microsoft Office 2007 Tutorials > Creating and Running a Query
Creating and running a Query
Step 1:
Click the Create tab. Then, click the Query Design button.
Step 2:
A Show Table window should appear. Double-click on the name of each table you wish to draw data from. You may also click on the Queries tab and double-click on each query you wish to draw data from. When you are done, click the
Step 3:
Each table or query you double-clicked will be added to the query as a separate sub-window. Double-click on the fields that you wish to use for the query.
Step 4:
They will appear in the bottom window of the query. Check or uncheck the Show checkbox for each field based on whether you want them to be visible in the query results. Also, type in the criteria you wish to use to filter the data. For example, the query shown below will display the First Name, Last Name, and Phone Number for users with a Workstation number above 2000.
Step 5:
Once you have added all the fields you wish, click the X button. Make sure you are clicking the lower button. Otherwise, you will exit Access altogether.
Step 6:
When you are prompted to save the changes, click the Yes button.
Step 7:
Double-click the name of the query to run the query.
Congratulations!
You have successfully created and run a query!
If you have problems when trying these instructions, or if you have other questions, please contact the Information Technology Helpdesk at 229-245-4357 or send an e-mail to helpdesk@valdosta.edu.