How to create a query using Query Wizard in Microsoft® Access
Follow the instructions to create a query using Query Wizard in Microsoft Access:
Open the desired database.
Click the ‘Query’ tab.
Click ‘Query Wizard’.
Select the type of query to create.
Select the desired options from each screen.
Click ‘Next’ to move to the next screen.
Click ‘Finish’ to view the query in ‘Datasheet’ view.
With the Query Wizard, you can specify fields from more than one data source and calculate averages, counts, maximums, minimums and sums. To create query, you just need to click ‘Query Wizard’ under the ‘New’ tab.
- How to use a Visual Basic for Applications variable as a criterion in a query in Microsoft Access 2000