Microsoft Office Tutorials and References
In Depth Information
MAKING SEVEN PRACTICE QUERIES
5. Create a query that shows the last name, employee ID, hours worked, and overtime amount
owed for hourly employees who earned overtime during Week 2. Overtime is paid at 1.5 times
the normal hourly rate for all hours worked over 40. Note that the amount shown in the query
should be just the overtime portion of the wages paid. Also, this is not a Totals query
amounts
should be shown for individual workers. Before creating your query, use the table shown in
Figure B-57 to work out your QBE grid on paper.
Field
Table
Sort
Show
Criteria
Or:
FIGURE B-57
QBE grid template
If your name was Joe Brady, your output would look like that in Figure B-58.
FIGURE B-58
Number 5 query output
6. Create a Parameter query that shows the hours employees have worked. Have the Parameter
query prompt for the week number. The output headings should be Last Name, First Name,
Week #, and Hours. This query is for nonsalaried workers only. Before creating your query, use
the table shown in Figure B-59 to work out your QBE grid on paper.
Field
Table
Sort
Show
Criteria
Or:
FIGURE B-59
QBE grid template
Run the query and enter 2 when prompted for the Week #. Your output should look like that in
Figure B-60.
FIGURE B-60
Number 6 query output
 
Search JabSto ::




Custom Search