Microsoft Office Tutorials and References
In Depth Information
MAKING SEVEN PRACTICE QUERIES
3. Create a query that sums the number of hours worked by U.S. citizens and the number of hours
worked by non-U.S. citizens. In other words, create two sums, grouped on citizenship. The
heading for total hours worked should be Total Hours Worked. Before creating your query, use
the table shown in Figure B-53 to work out your QBE grid on paper.
Field
Table
Total
Sort
Show
Criteria
Or:
FIGURE B-53
QBE grid template
Your output should resemble that in Figure B-54.
FIGURE B-54
Number 3 query output
4. Create a query that shows the wages owed to hourly workers for Week 1. The heading for the
wages owed should be Total Owed. The output headings should be Last Name, Employee ID,
Week #, and Total Owed. Before creating your query, use the table shown in Figure B-55 to work
out your QBE grid on paper.
Field
Table
Sort
Show
Criteria
Or:
FIGURE B-55
QBE grid template
If your name was Joe Brady, your output would look like that in Figure B-56.
FIGURE B-56
Number 4 query output
 
Search JabSto ::




Custom Search