DataBase - Creating Database for Invoices

Asked By AccessUserNeedingHelp on 13-May-10 01:50 PM
How do I create a database for the use of invoices? I am not sure how to
start. Step by step would be good or at least a brief overview.

I am trying to basically enter information in for an invoice and for access
to save the customer information on a table and to record the invoice on a
form to be printed and saved.

If anyone has a clue what to do, help is greatly appreciated! I need to
create this database for my job.

Thanks!


cram replied to AccessUserNeedingHelp on 13-May-10 02:11 PM
All depends on what you want to do: editing your own invoices or keeping
track of the invoices you receive.
In case of creating your own invoices, this wil depends on the local
(eventually legal) "needs".
Some indications: begin with creating some tables: one for your
customers/furnishers, one with current tax-levels, one products-table, one
with details of your "sales" (productnumber, quantity, ....) and decide what
kind of information you need at the end.
The lay-out of your invoice is only the final work.

You can find some indication the example NorthWind dbase which comes with
Access

Cram



--
cram
Mark Andrews replied to AccessUserNeedingHelp on 13-May-10 05:00 PM
I have two CRM templates that both do Invoicing.  I do charge a small fee
for the source code.
The 2007 version is a much simpler design overall, but on the Invoicing they
work pretty close to the same.

You could download the demo and steal the tables if you are not interested
in the code.

I designed the Invoice functionality to be similar to how Quicken does
Invoices.

Might help you out,
Mark Andrews
RPT Software
http://www.rptsoftware.com
http://www.donationmanagementsoftware.com
GP George replied to AccessUserNeedingHelp on 14-May-10 08:37 PM
What you are probably looking for is called "QuickBooks" and, although it is
not free, it is very inexpensive compared to trying to build yet another
Access-based application from scratch. MS also offers templates for a lot of
similar applications. Look here:
http://office.microsoft.com/en-us/access/HA012341591033.aspx for 2003 and
here for 2007:
http://office.microsoft.com/en-us/templates/CT101428241033.aspx

Also, the Northwind sample database is a pretty good place to start.
http://support.microsoft.com/kb/824265

hth

George
Gregory M Robinson replied to GP George on 15-May-10 11:20 AM
Gregory M Robinson replied to GP George on 15-May-10 11:21 AM