Problem
This problem requires the use of ACL software, which is included in the CD attached to the text. Information about installing and using ACL and solving this problem can be found in Appendix, pages 830-834. You should real all of the reference material preceding instructions about "Quick Sort" before locating the appropriate command to answer question a through f. For this problem, use the file labeled "Payroll" in the "Payroll Analysis" subfolder under table in Sample_Project. The suggested command or other source of information needed to solve the problem requirement is include at the end of each question.
A. Determine the number of payroll transaction in the file. (Read the bottom of the Payroll file screen)
B. Determine the largest and smallest payroll transaction (gross pay) for the month of September (Quick Sort)
C. Determine gross pay for September (Total)
D. Determine and print gross pay by department (Summarize)
E. Recalculate net pay for each payroll transaction for September and compare it to the amount include in the file (Filter)
F. Determine if there are nay gaps or duplicates in the check (cheque) numbers. If there are gaps or duplicates, what is your concern? (Gaps and Duplicates)