Access SQL: basic concepts, vocabulary, and syntax
Learn how to retrieve data from an Access database by using Structured Query Language, or SQL
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.
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.
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 …
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.
Create a simple select query - Microsoft Support
Queries help retrieve information from your Access database. Here's how to create a simple select query.
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 …
Use a union query to combine multiple queries into a single result
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 paste the …
Use wildcards in queries and parameters in Access
ANSI-89 describes the traditional Access SQL syntax, which is the default for Access databases. The wildcard characters conform to the Microsoft Visual Basic® for Applications (VBA) …
Access SQL: FROM clause - Microsoft Support
This is one of a set of articles about Access SQL. This article describes how to write a FROM clause, and uses examples to illustrate various techniques that you can use in a FROM clause.