Invoice & Inventory tracking

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This is new for me. I want to be able to type an invoice, and have the data in the description, price portion be included in a database of some sort at the same time. Is there a template or programming code I would use in Access 97 to accomplish this

Rather than tracking inventory, I'm trying to track what is sold, to whom, at what price, over the space of a year

Any suggestions would be appreciate
 
This is new for me. I want to be able to type an invoice, and have the data in the description, price portion be included in a database of some sort at the same time. Is there a template or programming code I would use in Access 97 to accomplish this.
Click to expand...

See the Northwind Sample Database on your installation CD. It does
exactly this.

Note also that Access is not a document-creation tool; it's a
relational database. Don't start the design with the finished product
("type in an invoice"); instead, analyze the data that is of
importance and create normalized tables to model this data: a table of
Customers, a table of Products (with prices and descriptions), a table
of Sales, and so on. The Invoice is simply a particular type of report
assembling data from these tables for display.
 
Back
Top