Invoice & Inventory tracking

[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

 

[John Vinson]

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.

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.