ACC5317/Class Home Page
Manipulating Data with with ACL
Syllabus Link
Lessons
Webliography
Communications between Students and Instructor


SESSION GOAL:  After completing this session, you should be able to manipulate a dataset in ACL.

  • Read ACL for Windows Workbook, Chapter 4, through page 180. (See assignment below for Norwood Office Supplies before you start reading this chapter).
  • Continue working with the Norwood Office Supplies, Inc. Case. Prepare answers to the following and turn in for grading before 9:40 AM on July 24. You should turn in a print out of the LOG FILE to support your answers. This is an individual assignment.
    • Which customers have back orders or open orders? Be sure to include their full name and address. (You will need to use the JOIN command to do this.)
    • Prepare an aging of the accounts receivable balances. Comment on your findings.
    • Stratify the Accounts Receivable balances. Comment on your findings.