Accounting Database

Accounting Database Design & T-SQL Reporting

By Derek Liew

Learn the powerful knowledge of using queries (sql) to generate conventional profit and loss, balance sheet, cash flow or even bank reconciliation on the fly. There are no other technical books that provide the equilibrium knowledge of both accounting and sql programming needed in developing an in house customized business or accounting application. The chapters in the book are concise and practical. You will discover realistic tables required in a relational database structure, that stores important transactional information for your payables, receivables, assets, banking and journals. You will learn normalization concepts to building accounting tables, and identifying redundant fields in third phase of the normalization process. .

Why is this book Important?

If you are the person who ask questions like, "What type of programming language is needed in order to develop my own accounting software or system", or "How to design tables for an accounting system", then you are looking at the right website. This book will widen up your knowledge in designing normalized accounting tables, to integrating them as a whole, thru referential keys. If you have been looking for answer for these two question within your social community or software development forum, just download a copy of the ebook format from the author's official website and go straight to the relevant chapters to find the solutions to your problems.

The tips and coding presented in each chapters is included for each sub modules, covering payable, receivable, cash management, inventory, asset management and general ledger. The author also encourage his reader to download the DES 1.2 software from his official wbesite (accountingdes.com) to try out the interface for each of the sub modules, in order to validate the integrity and effectiveness of the designed accounting database. User or readers should ensure they have SQL Server 2000 or SQL Express as the default DBMS before testing any of the examples documented in the book. If the user or reader has any queries to the book, the author welcome you to write in at request@accountingdes.com.

Accounting IN SQL for Newbies

By Derek Liew

This book was written as a continuation chapters from the accounting database design ebook. It is written in appreciation of the readers who has bought a copy of his first ebook. The first few chapters will touches on the user interface in capturing invoices, applying collections and payments, to setting off VAT Input and Output. The remaining chapters will show you the coding exercise of writing conditional stored procedures and creating back-end entry automation thru the use of triggers. You will learn how to write triggers to monitor event and to control information flow from table to multiple tables. You will also learn how to code in SQL Server, and test your written sql script from your SQL Server Analyzer.

Why is this book Written In The First Place?

There are many programming books in the world, and some are well written. However, there is no single book written that covers specifically on sql programming for an accounting system. There are some books available from the book store with similarlly titled as "Accounting Information System", but these books only covers the theoritical concepts and industry best practices and standards. None of these books, dwell much on the coding parts, which is essentially what a programmer, developer or a professional software architect should learn in order to write proper sql script for a practical accounting system in a real industrialized world.

Readers is encouraged to download the author's DES 1.2 accounting software package from his official wbesite at accountingdes.com to try out the examples layout in the individual chapters. Only when the reader manually tested the script themselves, will then only they discover the applicability and practicability of the written scripts. The author challenge you as the reader to post challenging question as to the applicability of the coding material contained in this book. If you have any further queries pertaining to any of the chapters, we encourage you to send your personal request to request@accountingdes.com.

Smashwords Book Marketing Guide

By Mark Coker

This popular book marketing primer shares easy-to-implement advice on how to market books at Smashwords and major ebook retailers. It starts with an overview of how Smashwords helps promote an author's ebook, and then provides 41 simple do-it-yourself marketing tips. The book is useful to all authors, even those who don't yet publish on Smashwords.

About Mark Coker

Mark Coker, is the founder of Smashwords. His mission is simple: we want to create the world's single best ebook publishing and distribution platform for our indie authors, publishers, literary agents and retailers.

I'm co-author with my wife of Boob Tube, a novel that explores the wild and wacky world of Hollywood celebrity. I also wrote the Smashwords Book Marketing Guide (how to market any book for free), the Smashwords Style Guide (how to format, produce and publish an ebook) and The 10-Minute PR Checklist (helps entrepreneurs and business managers think more strategically about public relations. It's not written for authors, though some authors find it valuable.).

When I'm not writing or working on Smashwords, I enjoy gardening, traveling and hiking tall mountains, the tallest of which has been Mt. Kilimanjaro.