Inventory and ordering control

[Emily]

I have already entered info into a table: Stock Number, Brand, Item,
Description, Units in stock, Units on Order, Vintage, and 5 different
priceing guides.

The end result that I want to have is to be able to fill out an
invoice(maybe with dropboxes), when the invoice is filled out I want the
inventory to update. I also want to be able to search the inventory. Not
all the items that I listed will need to be on each invoice, such as all of
the priceing info.

How on earth do I do this, I am haveing a hard time finding a template that
will work.

 

[mscertified]

You can probably do most of what you want (in an unsophisticated way) by
using the wizards. Just create a form based on your table.
I don't know your data but it sounds like the 'pricing guides' should be in
a separate table linked to your stock table.
You can't really expect to develop a sophicticated application in Access
without some training. It's a complex product that takes months to get
familiar with and years to master.

-Dorian