Select Queries

Diving Line


If you need to print this page out, type your name in the box below.

Your Name : 


Information

Select Queries can be used to select and display data that match a set of criteria.

For example, if you need the names and addresses of everyone who lives in Leicester, you can create a query that searches for city = Leicester and then selects all the names and addresses for people who live in Leicester.

To create a Select Query, click on the Create tab.  In the Queries group, click on Query Design.

Databases


You will need to device what database tables you need to use in your query.  

Select the table to want to use use and click Databases.

Click on the Database button when you have added the table.

Databases


Your query will look like this ...

Database


Next, you need to add the different fields into your query.  Think carefully about this and only add the fields you need to use.  Double click on each field name to add it into your query.  Each field will appear at the bottom of the screen.

Databases

Click on the Run command Databases to run the query and see the results.  The query will select and display the data for the fields you selected.

Databases


PrintIT  Print out this Page

Next  Saving a Query


Last modified: Monday, 7 December 2020, 2:59 PM