How to Create a Query to View Data in MS Access.

When you have Imported your ‘Table’, you will then need to design a query to help you search the DATA..

screenshot
 

In the column headed Objects, as above, click on ‘Queries’

screenshot

You should now have a Pop-Up Box as above

Ensure that the ‘Create query in Design view’ is highlighted as in ‘blue’ above

Click on New screenshot and you should now have the following screen

screenshot

Click on ‘Simple Query Wizard’

You should now have the next Screen..

screenshot

Click on OK….You should now have the following screen…
 

screenshot

1. TABLES/QUERIES

a. Where it says Tables/Queries…..
Ensure that the table you want to Create the query on is showing.

In the example above it shows the words Table: notts

If you have Imported more than one Table, click on the down arrow button to select the Table you wish to do a ‘Query’ on.

2. AVAILABLE FIELDS

Select the fields you wish to be able to ‘Search’ by.

In our example above we want them all.

You can either select them all or one at a time,

but as we want them all press screenshot
 This will move all the available fields over to the other column, as per the following Pop-Up Box

screenshot

 Click on Next>

You should now have the following screen:

screenshot

WHAT TITLE DO YOU WANT FOR YOUR QUERY?

You now have the option to give your Query a title.

Remember to name it something to do with the

Table you are doing the Query on.…I will call mine
Baptism Query

Type the ‘Title’ in.

Click on ‘Finish’

As soon as you click on ’Finish’ the table will open.

Close it using the screenshot at the top right hand corner of the Pop-Up ‘Table .

NOT the Access screenshot at the top of the page.

You should now be looking at the following screen,

screenshot

See the next page to learn how to use your query.