LESSON 5: Query Tutorial

A query is a SQL SELECT statement created with the Query painter and saved with a name so that it can be used repeatedly to define data requirements. A SQL SELECT statement is the way you tell the DBMS exactly which rows and columns to retrieve.

Queries save time because you can use them to define all your data retrieval needs. For example, you can specify the columns and rows to select, as well as the sorting requirements. Then you specify the query as the data source whenever you create forms and reports that use the data the query is intended to retrieve.

How long does this tutorial take?

About 15 minutes.