Free E-Books

The same query
in Design view is shown in Figure 14-2. As you can easily see, the Access Query Designer hides
much of the complexity of the underlying SQL statement.
Behind the scenes, as you add tables and choose fields in the Access Query Designer, Access composes
a SQL statement that is stored within the database file. Anything you can do in the Query
Designer can be expressed using the Access SQL syntax. Opening a query actually instructs Access
to retrieve the SQL statement and compose the query view you see in the Query Designer.
You can make changes to the query using either the Design window or the SQL window. As you
work with the query, you can alternate between view modes using the View drop-down in the
Access ribbon. The changes you make in either view are immediately reflected in the alternative
view.
472
Programming Microsoft Access Part II
FIGURE 14-2
The same query in Design view
If you are proficient in creating SQL queries on your own, you can even create a new
query directly in the SQL window.


Pages:
969 970 971 972 973 974 975 976 977 978 979 980 981 982 983 984 985 986 987 988 989 990 991 992 993