Using the Simple Query Wizard
Use the Simple Query Wizard to create a select query. A select query displays data from a table or tables, based on the fields that you select, but it does not sort or filter the data. For example, if you want a list of purchase orders showing the name of the employee, use a simple query that shows fields from both the Purchase Orders and the Employees tables.
To create a query using the Simple Query Wizard:
- Click Queries in the Objects bar to open the Queries window.
- Double click Create query by using wizard.
- Click the Tables/Queries box drop-down arrow. Click the table or query that you want to select data from.
- Add the field or fields in the order that you want them to display.
- Click the Tables/Queries box drop-down arrow again. Click the next table or query you want to select data from.
- Add the field or fields you want to display.
- When you have added all the fields you want, click Next.
- Give the query a meaningful title.
- Click Finish to view the query in Datasheet view.
By modifying the query in Design view, you can specify that the query display only records that meet certain criteria or that the query display records in a specific order.