how to create acuratefinancial records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

natalie - 27 Feb 2007 12:58 GMT

I have been asked to creat databases for a car seller he wants me to
basically input sales (price in/out etc)
input staff wages expenses etc
then calculate the P&L for this as wekk as be able to pull up VAT for
selected quarter

any ideas would be much appreciated
thanks

Reply to this Message

Jeff Boyce - 27 Feb 2007 15:06 GMT

Natalie

This sounds very much like ... a spreadsheet! Is there a reason you've
chosen to use a database?

Signature

Regards

Jeff Boyce
Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

> I have been asked to creat databases for a car seller he wants me to
> basically input sales (price in/out etc)
[quoted text clipped - 4 lines]
> any ideas would be much appreciated
> thanks

Reply to this Message

John W. Vinson - 27 Feb 2007 19:35 GMT

>I have been asked to creat databases for a car seller he wants me to
>basically input sales (price in/out etc)
[quoted text clipped - 4 lines]
>any ideas would be much appreciated
>thanks

I'd really recommend purchasing some good business accounting software
for this purpose. It would be a HUGE project in Access, especially if
you need to manage employee taxes and benefits, etc (which you do!).

This is exactly the purpose for which programs like Quickbooks,
Peachtree, and so on were written. They have many years of experience
with the ins and outs of such accounting; duplicating their
functionality in a home-grown system would be like your car seller
building cars himself starting from sand and iron ore.

John W. Vinson [MVP]

Reply to this Message