The author is an avid researcher and developer of accounting application. The knowledge of this author covers database design, stored procedures, triggers,vb programming and more than 10 years experience in accounting field. With all his invaluable experience and research knowledge, is where the author has found the inspiration to write a book on accounting database design.
How did you get started as a writer?
The idea of writing a book, was not something I had in mind. It started as a coincidence. I have been working as an Accountant for many years. Back then, the computer software, accounting software in particular was revolutionalizing the way accountants work. As I started learning the user manual, which we all do, before we start to operate a machine, I realised there is this sense of curiosity of understanding the mechanism of the accounting software I was using. That, literally drives me to find out books that touches on Accounting Information System. Unfortunately, it is dissapointing to find most of these books, does not actually explain the mechanism of the functionality of a real accounting system. Most of these books only covers the theoritical concept of it, and not the technical aspect of it. That triggers my instinct to document all these knowledge and experience in a form of a book.
Tell us about your book? What sets it apart from the rest of the Accounting Information Book available today?
If you are looking for one that teaches on real database design and sql programming, then this might be the one you have been searching for. I given the title : Accounting Database Design, instead of the conventional term of Accounting Information System, as I think it is only logical to use the conventional term, if you are literally talking about accounting system concept and theory. I incorporate the word design, because, the ingredient of this book, contains some technical guidance on creating tables for accounting modules, technical know how on entity relationship (linking your tables as an integrated system) and also some good lesson on sql programming. Sql in short, stands for structured query languange is a server-side scripting, that you need to master in order to create those financial reports (profit and loss, balance sheet, cash flow) that every Accountant or business manager would need.
Master the power of writing SQL for an accounting system. You will learn how to develop various modular graphical user interface with strong business logic control, how to create accounting tables and how to write powerful SQL statement involving the use of joins, subqueries, cursors, constraints, stored procedures and triggers in building a complete functional accountingdes software.
Learn how to write SQL for an accounting system. You will learn how to develop various modular graphical user interface with strong business logic control, how to create accounting tables and how to write powerful SQL statement involving the use of joins, subqueries, cursors, advanced data filtering, constraints, stored procedures and triggers in building a complete functional accounting system.
This book will walk you thru Step-by-step,employing real-life business processes and bookkeeping techniques in developing real-world
database engine for an accounting system that are robust and scalable.The author discuss the type of accounting modules,table design and
normalization concept.Reader is invited to download a free accounting software from accountingdes.com to test out the database.