Microsoft Office Tutorials and References
In Depth Information
• Click 5 in the Return box menu
to specify that the query results
should contain the ﬁ rst ﬁ ve rows.
Could I have typed the 5? What
about other numbers that do not
appear in the list?
Yes, you could have typed the 5.
For numbers not appearing in the
list, you must type the number.
• View the query results
• Close the query by clicking the
Close ‘Query1’ button.
only ﬁ rst ﬁ ve
records are included
• When asked if you want to save
your changes, click the No button.
Do I need to close the query
before creating my next query?
Not necessarily. When you use a
top-values query, however, it is
important to change the value in
the Return box back to All. If you
do not change the Return value
back to All, the previous value will
remain in effect. Consequently,
you may very well not get all the
records you should in the next
query. A good practice whenever
you use a top-values query is to
close the query as soon as you are
done. That way, you will begin
your next query from scratch, which guarantees that the value is set back to All.
In designing a query, you need to determine whether more than one table is required. If
the question being asked involves data from both the Client and Recruiter tables, for
example, both tables are required for the query. Such a query may require listing the
number and name of each client along with the number and name of the client’s recruiter.
The client’s name is in the Client table, whereas the recruiter’s name is in the Recruiter
table. Thus, this query cannot be completed using a single table; both the Client and
Recruiter tables are required. You need to join the tables; that is, to ﬁ nd records in the