If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Creating Database for Invoices
How do I create a database for the use of invoices? I'm 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! |
#2
|
|||
|
|||
Creating Database for Invoices
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 "AccessUserNeedingHelp" wrote: How do I create a database for the use of invoices? I'm 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! |
#3
|
|||
|
|||
Creating Database for Invoices
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 "AccessUserNeedingHelp" wrote in message ... How do I create a database for the use of invoices? I'm 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! |
#4
|
|||
|
|||
Creating Database for Invoices
What you are probably looking for is called "QuickBooks" and, although it's
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 he http://office.microsoft.com/en-us/ac...341591033.aspx for 2003 and here for 2007: http://office.microsoft.com/en-us/te...428241033.aspx Also, the Northwind sample database is a pretty good place to start. http://support.microsoft.com/kb/824265 hth George "AccessUserNeedingHelp" wrote in message ... How do I create a database for the use of invoices? I'm 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! |
#5
|
|||
|
|||
Creating Database for Invoices
"GP George" wrote in message ... What you are probably looking for is called "QuickBooks" and, although it's 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 he http://office.microsoft.com/en-us/ac...341591033.aspx for 2003 and here for 2007: http://office.microsoft.com/en-us/te...428241033.aspx Also, the Northwind sample database is a pretty good place to start. http://support.microsoft.com/kb/824265 hth George "AccessUserNeedingHelp" wrote in message ... How do I create a database for the use of invoices? I'm 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! |
#6
|
|||
|
|||
Creating Database for Invoices
"GP George" wrote in message ... What you are probably looking for is called "QuickBooks" and, although it's 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 he http://office.microsoft.com/en-us/ac...341591033.aspx for 2003 and here for 2007: http://office.microsoft.com/en-us/te...428241033.aspx Also, the Northwind sample database is a pretty good place to start. http://support.microsoft.com/kb/824265 hth George "AccessUserNeedingHelp" wrote in message ... How do I create a database for the use of invoices? I'm 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! |
Thread Tools | |
Display Modes | |
|
|