iYogi

Computer Problems? Call Toll Free @ 1 877 316 9417
Troubleshoot all your computer problems with certified tech experts, Call Today!
http://support.iyogi.com

Question

How to create a query using Query Wizard in Microsoft® Access

Reason
Microsoft Access 2007 Query Wizard allows you to create queries without applying ‘Structured Query Language’ (SQL), which is generally used to retrieve data from a database. With the Query Wizard, you can rapidly perform queries and derive relevant data.

The solution to the problem

Follow the instructions to create a query using Query Wizard in Microsoft Access:

  1. 1

    Open the desired database.

  2. 2

    Click the ‘Query’ tab.

  3. 3

    Click ‘New’.

  4. 4

    Click ‘Query Wizard’.

  5. 5

    Select the type of query to create.

  6. 6

    Click ‘OK’.

  7. 7

    Select the desired options from each screen.

  8. 8

    Click ‘Next’ to move to the next screen.

  9. 9

    Click ‘Finish’ to view the query in ‘Datasheet’ view.

Footnotes:

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.

Leave a Reply

*