Choose whether you want to open the query in Datasheet view or modify the query in Design view, and then select Finish. For more info, see Get started with queries or Create a simple select query.

Queries help retrieve information from your Access database. Here's how to create a simple select query.

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 …

Query criteria help you zero in on specific items in an Access database. If an item matches all the criteria you enter, it appears in the query results. To add criteria to an Access query, open the 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 …

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 …

You use update queries in Access databases to add, change, or delete the information in an existing record. You can think of update queries as a powerful form of the Find and Replace dialog box.

Learn how to create a query in Access that uses multiple tables as its data source.

You can use a query to supply data to a form or report in Access. You can use a query when you create the form or report, or you can change an existing form or report by setting its Record Source property.

To effectively understand union queries, you should first be familiar with designing basic select queries in Access. To learn more about designing select queries, see Create a simple select query.