Microsoft Office Tutorials and References
In Depth Information
Creating a Query in Design View
Figure 1-2:
This simple
query asks
to see
three fields
from the
Products
table.
6. Click the View button (the first button on the Design and Home tabs)
to see the datasheet with the data selected by your query.
The datasheet shown in Figure 1-3 shows the three fields we put in the
design grid.
Book III
Chapter 1
Figure 1-3:
The
datasheet
shows the
data asked
for in Query
Design
view.
If you want to save the query, click the Save button on the toolbar. Give the
query a name that indicates the data it selects. Remember that the next time
you open the query in Datasheet view, you’ll see updated data; if any
records have been added, deleted, or modified, the query reflects those
changes. You may choose not to save the query if you won’t need it again.
Just close it and then click the No button when Access asks whether you
want to save it.
Search JabSto ::




Custom Search