Access SQL: basic concepts, vocabulary, and syntax - Microsoft Support
Every query that you run uses SQL behind the scenes. 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 …
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 …
Nest a query inside another query or in an expression by using a ...
You can nest this query inside of your main query by using a subquery. You can write a subquery in an expression or in a Structured Query Language (SQL) statement in SQL view.
Access SQL: SELECT clause - Microsoft Support
This is one of a set of articles about Access SQL. This article describes how to write a SELECT clause, and uses examples to illustrate various techniques that you can use when you write them.
Use Microsoft Query to retrieve external data
You can use Microsoft Query to retrieve data from external sources. By using Microsoft Query to retrieve data from your corporate databases and files, you don't have to retype the data that you want to …
Access SQL: WHERE clause - Microsoft Support
This is one of a set of articles about Access SQL. This article describes how to write a WHERE clause, and uses examples to illustrate various techniques that you can use in a WHERE clause.
Create a pass-through query - Microsoft Support
You can use Access as a front-end application and then link to tables in a back-end server, such as SQL Server. By default, most queries run locally in the Access ACE database engine. In some cases, …
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 Design view …
GROUP BY Clause - Microsoft Support
The GROUP BY clause in Access combines records with identical values in the specified field list into a single record. A summary value is created for each record if you include an SQL aggregate function , …
ALL, DISTINCT, DISTINCTROW, TOP Predicates - Microsoft Support
Specifies records selected with SQL queries. Syntax SELECT [ALL | DISTINCT | DISTINCTROW | [TOP n [PERCENT]]] FROM table A SELECT statement containing these predicates has the following parts: