Ms Access 2010 tutorial:select query


Select query

III. Select Query

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.

III.1. Retrieve Data from one Column 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:

Microsoft Access 2010 retrieve data from a field

- Click View to see the result

Microsoft Access 2010 result retrieve a field-data 

III.2. Retrieve Data from multiple Columns of a Table

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.

Microsoft Access 2010 retrieve data from multiple fields 




Comments




This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.