Edward Ferrara

Using ACL – Chapter 5 and 6

Chapter 5

1. Total the expenses for airfare, hotel stays, and rental cars separately. Submit your results as a professionally formatted table or readable screenshot.
2. Total the expenses for all British Airways flights.
3. Total all food-related services. How much money did the company spend on:
   1. Restaurants
   2. Fast-food
   3. Catering
   4. Provide the answer both separately and together.
4. Use MATCH() to find transactions billed to internal departments/ Internal departments have customer numbers that begin with 0.
5. Determine the percentage pf the total transaction amounts is billed to internal departments and what percentage is billed to external clients.

Chapter 6

6. Create a report that lists all acceptable transactions. The procedures will be the same as for the report that lists unacceptable transactions, except you will use the Acceptable_Codes list as the basis for comparison. Using Relations, create a view that displays the following information:

• Employee name
• Credit card number
• Department
• Acceptable transaction amount
• Transaction date
• Transaction code
• Transaction code description

7. Extract this view to a new table Acceptable_Trans_by_Emp_April, and export the new table to an Excel file. Remember that some transactions have neither acceptable nor unacceptable codes. These transactions require approval, but are not forbidden.
8. Create a table of transactions that are neither acceptable nor unacceptable. How many transactions are in this category?
9. Extract all of the transactions that exist in the approval-required category to another table. Refer to the Trans_April, Trans_April_Unacceptable, and Employees tables. What percentage of employees with credit cards made unacceptable transactions?
10. How would you use ACL to e-mail the results of your report? Describe in one or two sentences.

Sample Solution