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..
In the column headed Objects, as above, click on ‘Queries’
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 
and you should now have the
following screen
Click on ‘Simple Query Wizard’
You should now have the next Screen..
Click on OK….You should now have
the following screen…
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 one at a time,
but as we want them all press 
This will move all the available fields over to the other column, as
per the
following Pop-Up Box
Click on Next>
You should now have the following screen
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 
at the top right hand
corner of the Pop-Up ‘Table .
NOT the Access at the top of the page.
You should now be looking at the following screen,
See the next page to learn how to use your query.