You can use a
SELECT query if you want to review data from only a few fields in a table at a time, or review data from multiple tables, or perhaps look at the database on certain criteria. Let us now look at a simple example in which we will create a simple query that will retrieve information from the Contacts table.
Open Database and click on Create tab.
Click on Query Design.
In the Tables tab, on the Show Table dialog, double-click the Contacts table and then close the dialog box.
In the Contacts
table, double-click any of the fields you want to see as the result of the query. Add these fields to the query design grid as shown in the following screenshot.
Now click on the Design tab, and then click on the Run option.
The query runs and displays data only in the fields that are specified in the query.