Create a query, form, or report in Access - Microsoft Support
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 …
Use parameters to ask for input when running a query - Microsoft …
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 …
Introduction to queries - Microsoft Support
An Access query is very versatile and can pull information from various tables and assemble it for display in a form or report.
Create a simple select query - Microsoft Support
Queries help retrieve information from your Access database. Here's how to create a simple select query.
Examples of query criteria - Microsoft Support
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 …
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 …
Create and run an update query - Microsoft Support
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 …
Create a query based on multiple tables - Microsoft Support
Learn how to create a query in Access that uses multiple tables as its data source.
Use a union query to combine multiple queries into a single result
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 …
Nest a query inside another query or in an expression by using a ...
Sometimes you may want to use the results of a query as a field in another query, or as a criterion for a query field. For example, suppose that you want to see the interval between orders for …