Creating A Query Access 2013

A query provides a powerful mechanism for filtering and sort­ing data. It can also be used to bring together data from several tables or other queries in a single presentation. 

Like a table, a query can be opened to display data in the design interface without showing the results in the browser. To display the results in the browser, you need to create a view that uses the query. 

In Section 7, “Modifying data using queries,” we describe how you can create action queries that modify data in a desktop database—for example, updating a set of rows. These action queries are not available in a Web App. 

Create a query:

1. Click Advanced on the Home tab of the ribbon. 
2. Select Query. 
3. From the Show Table Dialog box, select one or more queries or tables from the Show Table dialog box by double-clicking each table. 
   
4. Click Close when you have finished making selections. 
5. Add the fields from the source data into the query grid by double-clicking each field listed in the table. 
6. Click Save. 
   
7. Type a name for the query, and click OK to save it. 
8. Click View. 
9. Select Datasheet View to test the query. 

SEE ALSO: For a detailed explanation of how to construct select queries, see Section 6, “Selecting data using queries.”