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 …

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.

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.

Use criteria in an Access query to find specific information from your desktop database.

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 …

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 …

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

To create a form from a table or query in your database, in the Navigation Pane, click the table or query that contains the data for your form, and on the Create tab, click Form.

Training: For quick searches and questions, create a basic query in Microsoft Access to find the data you need and get your answers. Watch how in this online training video.