Relational database programs, such as Microsoft Office Access, use SQL to work with data. Unlike many computer languages, SQL is not difficult to read and understand, even for a novice.

This guide gives you a smooth start to your SQL Server journey, helps preserve Access front-end solutions you created, and hopefully motivates you to use Access for future database solutions.

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.

For example, if you enter Like “C*” in an SQL query, the query returns all field values beginning with the letter C. In a parameter query, you can prompt the user for a pattern to search for.

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.

ADO is straightforward to learn and enables client applications to access and manipulate data from a variety of sources, including Access and SQL Server. Its primary benefits are ease of …

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.

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 …

For more information about the new Monaco SQL editor, see Microsoft MVP Colin Riddington's detailed article New Monaco SQL Editor on his Access Forever developer blog.

The Like criteria or operator is used in an Access query to find data that matches a specific pattern. For example, in a sample database, we have a "Customers" table, like the one below, …