MS Access Select Query


Select Query

 

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.

 

select query, ms access

 

select query, ms access

 

Click on Query Design.

 

select query, ms access

 

In the Tables tab, on the Show Table dialog, double-click the Contacts table and then close the dialog box.

 

select query, ms access

 

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.

 

select query, ms access

 

Now click on the Design tab, and then click on the Run option.

 

select query, ms access

 

The query runs and displays data only in the fields that are specified in the query.