Microsoft Access 2007 tutorial:select query

Select Query

III. Select Query

A Select query is used to retrieve data from one or more than one columns of a table. The Select query does not make changing data in the table. If you want to view data, consider the select query.

III.1. Retrieve data from one column

For instance, to retrieve data from a column named phone of TblCustomer table, a select query can be created by double-clicking the field phone as shown the picture below:

Microsoft Access 2007 Query Design Example

III.2. Retrieve data from multiple columns of a table

To retrieve data from multiple columns of a table, you can do as above example. However, you need to double-click or drag and drop the additional columns that you want to add.



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.