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 aboveEnsure 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
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
This will move all the available fields over to the other column, as
per the following Pop-Up Box
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.