access accounts database (1 Viewer)

John thomas

Registered User.
Local time
Today, 00:19
Joined
Sep 4, 2012
Messages
206
Hi all
im looking to put together an accounts database for my small business. I cant find much on the web for this subject
Im looking at the tables and what i need .
I know I am going to need a chart of accounts Table
and also a table with the clases of account eg sales outgoings ect

i want my sales table to have account 4000to 4999
how would i structure my table for that do i start with access auto number and then a field for the accounts numbers

also are there any tutorials for accounts databases
all help very much appreciated
 

June7

AWF VIP
Local time
Yesterday, 23:19
Joined
Mar 9, 2014
Messages
5,424
You don't have to use autonumber field as PK for chart of accounts table. Just have a number field for the numeric account number and a text field for account name.

Are you trying to build a double-entry accounting app? Recommend would be better to buy off-the-shelf, like QuickBooks.
 

Mark_

Longboard on the internet
Local time
Today, 00:19
Joined
Sep 12, 2017
Messages
2,111
@ OP,

What is your personal/business fiscal liability for this system?

I'll second June7's suggestion. Better to get an existing system that does what you need rather than try to reinvent the wheel.

This becomes much more important if you have liability and you are not POSITIVE you know what you are doing.
 

Users who are viewing this thread

Top Bottom