Need help with Books that are capable to create accounting system on MS Access

[Steve Juanda]

Ladies and Gentlemen

How are you doing?

I wonder whether anyone out know good books that teach on how to create
program on MS Access to do the following tasks: (One book per subject is
OK)

1. Create Full Blown Accounting System
a. Track Expenses.
- By Department.
b. Track Sales.
- Credit Sales and Cash Sales.
- By Department

2. Create Inventory System.
a. tracking SKU and its quantity.
b. Tracking Purchases + sales. Thus automatically deduct
or added it from and into inventory.

Currently my team has been developing the tools to keep track of our
expenses and budget. Until now it seem been going pretty well. (Well,
some set backs once a while) :-). However, we would like to compare our
program on what is out there on the market/ "from the pro like you."
and see in what aspect we could develop and improve on our program.
Along with it, we are trying to get the ideas on how to program a full
blown inventory and accounting system.

Thank you for your time and attention. If you have any question, email
me at juan...@msmailhub.oulan.ou.edu

Thank you for your time and have a nice day

Steve

[Mark Wagner]

see your other posting re: account numbers

this same concept applies to lookup the department, salesman#, or
anything from other tables. I would store all the transactions in a
single table with relationships to the other tables. I would create an
expense transaction table and a sales transaction table. the difficulty
I see is in making the inventory transaction table be updated
simultaneously with the sales entries...but my gut tells me it shouldn't
be too hard. I'll think on it and report back if I come up with
anything. best of luck.

Mark Wagner,CPA
mcwa...@gte.net

[dcar...@gmail.com]

Hi Steve,

I do not know of any books that teaches on developing accounting system in MS Access, but i would recommend one ebook that shows you how to create and design a proper accounting database in MS SQL Server. If you are still keen, you may download a copy from accountingdes.com

[John W. Vinson]

On Fri, 16 Aug 2013 08:01:12 -0700 (PDT), dcar...@gmail.com wrote:

> I do not know of any books that teaches on developing accounting system in MS Access, but i would recommend one ebook that shows you how to create and design a proper accounting database in MS SQL Server. If you are still keen, you may download a copy from accountingdes.com

The message to which you replied is *SIXTEEN YEARS OLD* - posted in 1997. Are
you perhaps just spamming to get your business out on (a now defunct)
newsgroup?
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

[Access Developer]

And, just by-the-by, a newsgroup where the strongest advice on accounting
systems has always been: "There are so many good, proven, (and trivially
inexpensive compared to creating your own) accounting systems, most of which
can exchage/share data with Microsoft Access, that you should only consider
writing your own accounting system if the need is _compelling_ because of
differences from 'Generally Accepted Accounting Principles (GAAP)' in the
way you do business."

John, you ought to appreciate a definition I once heard: "Generally Accepted
Accounting Principles (GAAP) are any that don't get you put in jail."

I'm a-guessin' that I wouldn't want to waste much time looking into the
recommendation of a possible spammer who thought we are too dumb to see the
long gap between question and answer, who thought no one would give the
traditional advice, and who doesn't frequent this newsgroup enough to know
it is a "zombie" newsgroup.

--
Larry Linson
Microsoft Office Access MVP
Co-Author, Microsoft Access Small Business Solutions, Wiley 2010

"John W. Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message
news:kpms091ptgaldaj0o...@4ax.com...

[John W. Vinson]

On Fri, 16 Aug 2013 15:39:18 -0500, "Access Developer" <accd...@gmail.com>
wrote:

>John, you ought to appreciate a definition I once heard: "Generally Accepted
>Accounting Principles (GAAP) are any that don't get you put in jail."

Well, I have no taste for accounting!

I do remember the joke about the businessman who was interviewing a
mathematician, an engineer and an accountant. He asked each of them, "How much
is two plus two?"

The mathematician asked "In what base? What number field?"
The engineer grabbed his calculator and replied "3.9999999999."
The accounant went to the door, looked to see if anyione was listening, and
whispered "How much do you WANT it to be?"

[cimi...@gmail.com]

Pada Isnin, 18 Ogos 1997 3:00:00 ptg UTC+8, Steve Juanda menulis:

Pada Isnin, 18 Ogos 1997 3:00:00 ptg UTC+8, Steve Juanda menulis:

[cimi...@gmail.com]

Phaiada Isnin, 18 Ogos 1997 3:00:00 ptg UTC+8, Steve Juanda menulis:

hai gomputer saya telah di block untuk internet sila bantu untuk mengayasinya

my computer has block for internet pless give me are susgestion

[cimi...@gmail.com]

[Access Developer]

<cimi...@gmail.com> wrote

> my computer has block for internet
> pless give me are susgestion

How strange that a computer with a "block for internet" is able to access a
newsgroup that is *only* accessible via the Internet. Also how strange that
the first quoted post appears to be dated "1997".

Suggestions: Take a look at commercially-available accounting packages, such
as QuickBooks and Peachtree Accounting. They are very capable, customizable,
and trivially inexpensive compare to developing your own.

--
Larry Linson
Microsoft Office Access MVP
Co-Author, Microsoft Access Small Business Solutions, Wiley 2010

<cimi...@gmail.com> wrote in message
news:151a5e3a-fff5-4fef...@googlegroups.com...

[suhaimi yan]