Using the Query Wizard simplifies the process.
We’re using the Northwind (legacy) sample database in this example.
Find it in the templates area of Access; search forNorthwind.
From theCreatetab at the top of Access, selectQuery Wizardin the Queries group.
The New Query window will open.
Select a query pop in.
For our purposes, we’ll chooseSimple Query Wizard.
choose the appropriate table from the pull-down menu.
These are the valid data sources for your new query.
Double-hit the fields you wish to appear in the query results.
In this example, we’ll chooseProduct Name,List Price,andTarget Level.
Notice that there are three other icons offered.
The»icon will select all available fields.
Optionally, repeat steps 4 and 5 to add information from additional tables, and then selectNextto continue.
In our example, we’re pulling information from a single table.
you could combine information from multiple tables and easily show relationships.
All you have to do is choose the fields.
This works because the Northwind database has predefined relationships between tables.
If you’re creating a new database, you’ll need to establish these relationships yourself.
Choose the pop in of results you would like to produce.
Give your query a title.
Select something descriptive that will help you recognize this query later.
We’ll call this queryProduct Supplier Listing.
You’ll be presented with the query results shown in the illustration above.
It contains a list of our company products, desired target inventory levels, and list prices.
Notice that the tab presenting the results contains the name of your query.
You’ve successfully created your first query using Microsoft Access!
Now you’re armed with a powerful tool to apply to your database needs.
