How Can I Create Select Queries In MS Access?

There is a simple procedure to create a query in Microsoft Access which is easier than the typical way of writing these queries.  In Microsoft Access open the database that you want to create the queries for. Now click on a button "Queries" in the main database window.
Now select an option "create queries in design view".  

A "select query" window will appear. You will see a button names as "show table" on this window. Clicking this button will display another dialog box that will display all the tables in that database. Select those tables that you need in a query click Add button and close this dialog box.

Now select query window will show those selected tables in the upper part. The bottom part will consist of different options for creating a query by using these tables.These different options allow the user to set query qualifications. Format of resultant table, and fields of tables.

Select the required fields of the selected tables from a drop down list names as "Field:"
The selected fields of specified tables will be included in the query that we want to create.
Now you can define sorting order of the records in the table that will be a result of this query. Specify criteria of query and save this query with a name. Now after it you can use this query in your program by its name easily.