Create a query, form, or report in Access - Microsoft Support
Create a select query. Create a query to focus on specific data. Select Create > Query Wizard .
Introduction to queries - Microsoft Support
You can use a make-table query to create a new table from data that is stored in other tables. For example, suppose that you want to send data for Chicago orders to a Chicago business partner who uses Access to prepare reports.
Create a simple select query - Microsoft Support
To run a select query, you open it in Datasheet view. If you save the query, you can reuse it whenever you need, for example, as a data source for a form, report, or another query. Use the Query Wizard to create a select query. You can use the Query Wizard to …
Video: Get started with queries - Microsoft Support
Training: Use queries in Access to answer questions based on data, to easily make bulk updates, or to delete information from the database. Watch how in this video.
Examples of query criteria - Microsoft Support
A query criterion is an expression that Access compares to query field values to determine whether to include the record that contains each value. For example, = "Chicago" is an expression that Access can compare to values in a text field in a query.
Run a query - Microsoft Support
A query is a set of instructions that you can use for working with data. You run a query to perform these instructions. In addition to returning results — which can be sorted, grouped, or filtered — a query can also create, copy, delete, or change data.
Access SQL: basic concepts, vocabulary, and syntax
Understanding how SQL works can help you create better queries, and can make it easier for you to understand how to fix a query that is not returning the results that you want. This is one of a set of articles about Access SQL.
Use a union query to combine multiple queries into a single result
Create a union query by creating and combining select queries. Even though you can create a union query by directly writing the SQL syntax in the SQL view, you might find it easier to build it in parts with select queries. You can then copy and …
Use parameters to ask for input when running a query
To make a query in Access databases ask for criteria when you run it, create a parameter query. This allows you to use the same query over and over without having to constantly open it in Design view to edit the criteria.
Create a make table query - Microsoft Support
The information in this article explains how to create and run a make table query in Access. You use a make table query when you need to copy the data in a table, archive data, or perhaps save query results as a table.