How to Use the Access 2007 Query Wizard
The Access 2007 query wizard allows you to create queries without using Structured Query Language (SQL), the language normally used to retrieve data from a database. You may specify fields from more than one data source and the query wizard also is able to calculate averages, counts, maximums, minimums and sums. The following steps will show how to use the Access 2007 query wizard.
Other People Are Reading
Instructions
-
-
1
Start Access 2007 and open an Access 2007 database or project. The Database window appears automatically and displays shortcuts for opening database objects and creating new objects.
-
2
Look under the "Objects" panel on the upper left side of the Database window and click on the line item labeled "Queries." Now click on the item labeled "New" in the tool bar of the Database window to bring up the "New Query" dialog box.
-
-
3
Create a query using one of the query wizards displayed in the "New Query" dialog box. For example, for most queries we would select the "Simple Query Wizard" and click on the "OK" button.
-
4
Follow the prompts given in the "Query Wizard" dialog boxes. The last dialog box will provide the option of running the query or viewing the query structure in "Design" view.
-
5
Use "Design" view to fine-tune the query or use the query wizard to rewrite the query from scratch. This is frequently done with complex queries or large databases where the query structure used by the query wizard does not provide optimum performance.
-
1
