Accounting with Ms Access

Hello all I have been working on a database for are small retail Tile company (we do everything by
pen and paper now). I have been able to setup a working Orders/Invoice table and forms, CreditMemo
table and forms, and PurchaseOrder table and forms all based on the Northwind Sample Database.
"Thanks to all the help here". I have been searching for a sample database with accounting. With
A/R, A/P, Billing Statements and so on. I am not a programmer or accountant so the chance of me
doing something wrong is pretty good. I am hoping that someone has a add-in MsAccess database for
sale that would link to my tables and do the accounting process. I have looked at Ms Accounting 2008
and QuickBooks 2008 no way to link the tables to the programs I can see. Any help or suggestions
welcome.

Thank in Advance
Thomas
Remove .NOSPAM

PS.
Happy New Year
And Best of Wishes for You and Yours in the New Year

Tony Toews has a page about Access-based accounting systems at
http://www.granite.ab.ca/accsacct.htm

I'm not sure about MS Accounting 2008, but I'm pretty sure that there are
ODBC drivers available for QuickBooks. If you have the appropriate ODBC
drivers loaded, you'll be able to get at the data from Access.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Thomas" wrote in message
et...
Hello all I have been working on a database for are small retail Tile
company (we do everything by pen and paper now). I have been able to setup
a working Orders/Invoice table and forms, CreditMemo table and forms, and
PurchaseOrder table and forms all based on the Northwind Sample Database.
"Thanks to all the help here". I have been searching for a sample database
with accounting. With A/R, A/P, Billing Statements and so on. I am not a
programmer or accountant so the chance of me doing something wrong is
pretty good. I am hoping that someone has a add-in MsAccess database for
sale that would link to my tables and do the accounting process. I have
looked at Ms Accounting 2008 and QuickBooks 2008 no way to link the tables
to the programs I can see. Any help or suggestions welcome.

Thank in Advance
Thomas
Remove .NOSPAM

PS.
Happy New Year
And Best of Wishes for You and Yours in the New Year

I have successfully integrated Access databases with People's Choice
Accounting which is written in Access:

http://www.peoples-choice.com/
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Thomas" wrote in message
et...
Hello all I have been working on a database for are small retail Tile
company (we do everything by pen and paper now). I have been able to setup
a working Orders/Invoice table and forms, CreditMemo table and forms, and
PurchaseOrder table and forms all based on the Northwind Sample Database.
"Thanks to all the help here". I have been searching for a sample database
with accounting. With A/R, A/P, Billing Statements and so on. I am not a
programmer or accountant so the chance of me doing something wrong is
pretty good. I am hoping that someone has a add-in MsAccess database for
sale that would link to my tables and do the accounting process. I have
looked at Ms Accounting 2008 and QuickBooks 2008 no way to link the tables
to the programs I can see. Any help or suggestions welcome.

Thank in Advance
Thomas
Remove .NOSPAM

PS.
Happy New Year
And Best of Wishes for You and Yours in the New Year