This case offers learning experiences for following a business process diagram (BPD) and querying a relational database with the Query-By-Example (QBE) interface in Microsoft Access. The business process depicts (1) recording sales of new cars from dealers and sale returns when buyers return purchases and (2) recording sales and returns by the car manufacturer. From the BPD, learners make inferences about revenue recognition to develop hypotheses for why the dealers’ and the manufacturers’ sales counts sometimes disagree. They test the hypotheses by querying to isolate discrepancies between the two versions of sales data. For business processes, practice and quiz questions prompt learners to follow the process and identify mismatches between text explaining a process and a BPD representation of it. For querying, practice and quiz questions prompt learners to exercise the thinking required to perform the querying, including configuring joins, aggregating data, setting criteria, using built-in functions, developing expressions, and verifying query correctness. No prior experience with BPDs or querying is required, although learners with prior business process and/or query skill can be assigned the case without some or all of the scaffolding resources, including a detailed querying script with screenshots.

Developing Business Process and Query Skills for Solving Business Problems.

[Annual Meeting Website](https://aaahq.org/Meetings/2020/Annual-Meeting)

[Benefits for Presenters](https://aaahq.org/Meetings/2020/Annual-Meeting/Presenter-Benefits)

 AAA 2020 Virtual Annual Meeting and Conference on Teaching and Learning

The American Accounting Association is the largest community of accountants in academia. Founded in 1916, we have a rich and reputable history built on leading-edge research and publications. The diversity of our membership creates a fertile environment for collaboration and innovation. Collectively, we shape the future of accounting through teaching, research and a powerful network, ensuring our position as thought leaders in accounting.