Using the Simple Query Wizard

To create a query using the Simple Query Wizard:

1. Click Queries in the Objects bar to open the Queries window.
2. Double click Create query by using wizard.
3. Click the Tables/Queries box drop-down arrow.
4. Click the table or query that you want to select data from.
5. Add the field or fields in the order that you want them to display.
6. Click the Tables/Queries box drop-down arrow again.
7. Click the next table or query you want to select data from.
8. Add the field or fields you want to display.
9. When you have added all the fields you want, click Next.
10. Give the query a meaningful title.
11. Click Finish to view the query in Datasheet view.

Begin the Simple Query Wizard by double-clicking Create query by using wizard in the queries window. Select the first table from which you want to display data. Select the fields that you want to display. Select the second table from which you want to display data. Add the fields you want to display from this table. Continue selecting fields from different tables or queries until you have all the data you want to display. Click Next. Give the query a meaningful name, or accept the suggested name. Click Finish to view the query results.