Skip to main content

Modeling and Designing Accounting Systems: Using Access to Build a Database

Modeling and Designing Accounting Systems: Using Access to Build a Database

C. Janie Chang , Laura R. Ingraham

ISBN: 978-0-471-45087-0

Jan 2006

149 pages

Select type: Paperback

In Stock



Modeling and Designing Accounting Systems: Using Access to Develop a Database provides both a conceptual and practical approach to Accounting Information System data modeling and database design. 

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.

Related Resources

Buy Both and Save 25%!

This item: Modeling and Designing Accounting Systems: Using Access to Build a Database

Accounting Information Systems: Essential Concepts and Applications, 4th Edition (Hardcover $248.95)

Original Price:$338.90

Purchased together:$254.17

save $84.73

Cannot be combined with any other offers.

Chapter 1. Business Processes, Data Modeling and Information Systems.

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.


Step-by-step detailed instructions show how to model and design three essential processes of an accounting information system:
  1. The Sales/Collection Process
  2. The Acquisition/Payment Process
  3. 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.