Accounting Automation and Insight at the Speed of Thought

Modern organizations are inundated with data, and they often struggle to organize it in an efficient and effective manner in order to get the most value from the data. The context of this case is, thus, situated in current business practice. Students are given large data files that were extracted from an enterprise system. They must use Microsoft Access and Excel to summarize and organize the data to create a dynamic profit and loss statement. Basic skills in Excel and general accounting knowledge are assumed, while Access knowledge is not assumed. The Teaching Notes provide solutions and are organized to allow instructors to provide minimal guidance or fully annotated directions.