This is one of a set of articles about Access SQL. This article describes the basic use of SQL to select data, and uses examples to illustrate SQL syntax. In this article What is SQL? Basic …

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.

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.

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.

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 …

You can create and modify tables, constraints, indexes and relationships in Access by writing data-definition queries in SQL view. This article explains data-definition queries and how to …

The SELECT statement Instructs the Microsoft Access database engine to return information from the database as a set of records.

Remarks You can use a subquery instead of an expression in the field list of a SELECT statement or in a WHERE or HAVING clause. In a subquery, you use a SELECT statement to provide a …

In addition to the standard steps you take to manage access to your network and resources, like firewall settings, you can use SQL Server security features to help you control data access:

Note: There are important differences between Access SQL and SQL Server TSQL, especially with syntax, function names, and function arguments. For more information, see Comparing …