To
create an Access query, you use the Query Design window.
You specify a few data sources and fields, add a
criteria expression or two, and perhaps specify a sort
order. What you might not realize is that there's more
to working in this window than just creating a query.
Working efficiently in this environment can help you
maintain accuracy and database integrity.
Queries come with a few terms you might not associate
with their graphic counterparts. With that in mind, here
are a few environmental terms you might read in articles
and documentation:
-
Design view
-- This is the window you use to design a query. You
might also see this window called the
Query Design window
or the Query
Builder.
-
Datasheet view
-- This is the table-looking view of a query's
resulting recordset.
-
QBE grid
-- This is the lower pane in the Query Design
window's graphic interface. (QBE stands for
query by example.)
Use the bottom pane to specify the fields upon which
the query acts.
