Creating+a+Query

This page is designed to help you create queries.

=__To create a query__:= 6. Depending on what you are asked for, you may need to //sort//, //total//, //show/hide//, or //modify// your information. 7. Once you've entered in all of you information, save your work. 8. Finally, click the "Run" button under the "Results" group on the "Design" tab. Knowing how to create queries can help you organize your data efficently and help you complete your work quickly.
 * 1) Go to the "Create" tab.
 * 2) In the "Other" group, click on the "Query Design" button.
 * 3) Select the tables that your query needs to be based on and click "Add."
 * 4) Once you've chosen the tables you need to work with, click "Close."
 * 5) Now, from the tables you've chosen, you need to choose the information you've been asked to display. To do this, find the information that you need to display and double click on each one; another option would be to click on the information and drag it down to "Field:"
 * If you're asked to sort your information, you would go to "Sort:" under the required field value and select "//Ascending//" or "//Descending//," depending on what is asked.
 * If you're asked to perform a certain mathematical function (sum, min, max, avg, etc.), you first click the "Totals" button in the "Show/Hide" group on the design tab. Next, under "Totals:" you select the function that you want the computer to perform, from the drop down menu.[[image:http://i13.photobucket.com/albums/a290/oHhsoOseduCtive/pic62.jpg caption="external image pic62.jpg"]]
 * If you're asked to show or hide certain fields, simply click on the box with the check mark in the "Show:" section, under the field you want to hide. When the check mark is visible, that field's information will be shown.[[image:http://i13.photobucket.com/albums/a290/oHhsoOseduCtive/pic63.jpg caption="external image pic63.jpg"]]
 * To modify your query results so that specific information is displayed, choose the field in which you need specific information. Next click in the "Criteria:" section under the field you chose. Next, type in the specific information that you want displayed.[[image:http://i13.photobucket.com/albums/a290/oHhsoOseduCtive/pic64.jpg caption="external image pic64.jpg"]]