Modeling and Designing Accounting Systems: Using Access to Build a Database
January 2006, ©2007
Written as a supplement, the text begins with simple, easy to understand examples of data modeling using the resource-event-agent (REA) approach to model business processes. The text then provides step-by-step instructions explaining how to convert REA diagrams into database structures. Hands-on exercises are subsequently used to help students become familiar with using Microsoft Access to implement a database.
In the final three chapters of the text, students model and design a portion of the accounting information system for a single company, Tragg’s Custom Surfboards, using the REA approach.
Chapter 2. Data Models and Relational Databases.
Chapter 3. Using Access to Implement a Rational Databases.
Chapter 4. Sales/Collection Business Process.
Chapter 5. Acquisition/Payment Business Process.
Chapter 6. Human Resource Business Process.
Laura R. Ingraham is an Associate Professor of Accounting Information Systems at San Jose State University. She holds both a Ph.D. in Business Administration and a Bachelor of Science in Accounting from Arizona State University. Prior to arriving at San Jose State, Dr. Ingraham served as an Assistant Professor at CSU San Marcos and at North Carolina State University State University, where she developed several distance education courses. Dr. Ingraham is the co-author of four textbooks and has written more than a dozen research papers on information systems, e-commerce, taxation, and accounting topics. Her work has been published in Expert Systems and Emerging Technologies, Strategic Finance, Tax Notes, Journal of State Taxation, etc. Dr. Ingraham's current teaching responsibilities include Accounting Information Systems, Advanced AIS and Risk Management, and Issues in E-Business. She has also taught in the areas of taxation and introductory financial and managerial accounting. Dr. Ingraham is the recipient of the 2005 San Jose State University College of Business Outstanding Undergraduate Instructor Award.
The Sales/Collection Process
The Acquisition/Payment Process
The Human Resources/Payroll Process
Uses REA diagrams to model business processes.
Provides a systemic approach to convert data models into database structures.
The approach is software-independent, but utilizes Microsoft Access 2003 to implement the data models throughout the text.
Multiple-choice questions and additional problems at the end of each chapter reinforce text concepts.
Includes a CD-ROM containing the additional data and forms you will need to complete each chapter.
- Wiley E-Texts are powered by VitalSource and accessed via the VitalSource Bookshelf reader, available online and via a downloadable app.
- Wiley E-Texts are accessible online and offline, and can be read on a variety of devices, including smartphones and tablets.
- Wiley E-Texts are non-returnable and non-refundable.
- Wiley E-Texts are protected by DRM. For specific DRM policies, please refer to our FAQ.
- WileyPLUS registration codes are NOT included with any Wiley E-Text. For informationon WileyPLUS, click here .
- To learn more about Wiley E-Texts, please refer to our FAQ.
- E-books are offered as e-Pubs or PDFs. To download and read them, users must install Adobe Digital Editions (ADE) on their PC.
- E-books have DRM protection on them, which means only the person who purchases and downloads the e-book can access it.
- E-books are non-returnable and non-refundable.
- To learn more about our e-books, please refer to our FAQ.