Select Query is a type of query that is used to retrieve data from one or more columns of a table. Moreover, a Select Query can be used to retrieve data in more complex ways by using Top Values or Unique Values or Unique Records property. In addition, you can use a Select Query to make the calculation on the fields of a table.
Sometimes you may want to retrieve all data from a table or other times you may want to retrieve data from only one field of a table. For instance, you want to retrieve data from the CusName field of TblCustomer. To do so, follow the steps below:
- Click Create tab
- Click Query Design
- In the Show Table dialog box, in Tables tab, Double-click TblCustomer
- Click Close
- Double-click or drag and drop the CusName field into the query design grid as the figure below:
- Click View to see the result
In some cases, you may want to retrieve the data from many columns of a table, to review or to make a calculation. For example, you want to retrieve data from the CusID, CusName, and Phone fields of TblCustomer. To do so, follow the steps of retrieving data from one column of a table. You need to double-click or drag and drop additional fields(CusID, Phone) into query design grid.
This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages: