Microsoft Office Tutorials and References
In Depth Information
MAKING SEVEN PRACTICE QUERIES
Field
Table
Sort
Show
Criteria
Or:
FIGURE B-49
QBE grid template
Your output should resemble that in Figure B-50.
FIGURE B-50
Number 1 query output
2. Create a query that shows the last name, first name, date hired, and state for employees who
live in Delaware or were hired after 12/31/99. The primary sort (ascending) is on last name, and
the secondary sort (ascending) is on first name. The Primary Sort field must be to the left of the
Secondary Sort field in the query setup. Before creating your query, use the table shown in
Figure B-51 to work out your QBE grid on paper.
Field
Table
Sort
Show
Criteria
Or:
FIGURE B-51
QBE grid template
If your name was Joe Brady, your output would look like that in Figure B-52.
FIGURE B-52
Number 2 query output
 
Search JabSto ::




Custom Search