Using Queries in Access
Access allows you to analyze data in the form of queries. You can create queries in Access by using either the Query Wizard or the Design View.
Creating Queries with the Wizard
To create a query with the wizard, click on the Query Wizard button in the Create tab.
The first part of the wizard will ask you what type of query you would like to create. Select the appropriate one then click OK.
The next part of the wizard will ask you what table and what fields you want to use in your query.
In the Tables/Queries box, you can choose which table to query by clicking on the dropdown arrow and choosing the table. You can select which fields to use by highlighting the field and then clicking the “>” button. Your fields should be seen in the box on the right side.
To select all of the fields, click on the “>>” button. If you want to remove your list, click on the “<<” button or click on the “<” button if it’s just one item. Now, click Next.
In the next box, type a title in the first text box. You can choose to open or modify the query’s design. Just click on the radio button next to your choice. When you are done, click Finish.
This is what your query might look like:
Creating A Query in Design View
To create a query in the Design View, click on the Query Design button in the Create tab.
When creating a query in Design View, you can choose which tables or queries to query. The first step is to choose which table or query you want to query.
Then, click the Add button. You should see the tables in the Queries box. Once you have added your tables or queries, click Close.
As you can see, the tables/queries you chose and their appropriate fields appear in the top of the box. There are two ways you can choose which fields you want in your query. You can either double-click on one of the fields in the top box or you can use the drop down menu in the Field box to select the field.
When you use the asterisk (*), the query results automatically include any fields that are added to the underlying table or query after the query is created and automatically exclude fields that are deleted.
Running a Query
To run a query, you must have the query open in the Design View. Click the Run button on the Design tab.