The Query Design Tool and SQL View
Another straightforward query tool that is simple to use is
referred to as Query Design. The Query Design tool, shown in
Figure 2-2, enables the user to create queries by selecting table
and column names and specifying conditions on the data you
want to retrieve. The Query Design tool is a little more power-
ful because of the extra added feature of being able to set
conditions on data. It also contains an SQL view that displays
the SQL script from the queries created in Query Design.
SQL view is useful because you can use it to examine and
learn SQL script so that you can eventually create your own
customized queries. Microsoft Access makes it easy for you to
switch back and forth between Query Design and SQL view by
simply clicking the View button to choose which tool you want.
Figure 2-2 points out the View button.
19
3
Structured Query Language and Microsoft Access
Figure 2-1. Query Wizard
|
|