Chapter 29. Article 2 Understanding SQL

Underlying every query in Microsoft Access 2010 is the Structured Query Language (SQL) database command language. Although you can design most queries using the simple Access 2010 design grid (or the view, function, or stored procedure designer in an Access project file), Access stores every query you design as an SQL command. When you use one of the designers, Access creates the SQL for you. However, for advanced types of queries that use the results of a second query as a comparison condition, you need to know SQL to define the second query (called a subquery). Also, you cannot use the design grid to construct all types of queries available in the product; you must use ...

Get Microsoft® Access® 2010 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.