Microsoft Office Tutorials and References
In Depth Information
ASSIGNMENT 2: CREATING THE DATABASE, QUERIES, AND REPORTS
November Hours query
Create a query called November LA Tax, using the November Hours query and an additional table as input. Assume
that all guards earn $20 per hour, and that guards who live in Los Angeles have an additional one percent tax on
their income. Include both of these assumptions in the query, using an IF statement to calculate the tax for
Los Angeles residents. List headings for the Employee Last Name, Employee First Name, Pay, and City Tax.
Your data will differ, but your output should resemble that in Figure 5-10. Note that only a portion of the output
is showing in the figure.
November LA Tax query