I am new to using access and am wondering if i can get some assist.

I have curently developed invoices, purchase, and quote templates for our small buisness.
These templates have been developed using excel.

What i am wanting to do now... if able.. is develop a database of stock id, stock descrip, cost price, selling price etc..

Am i able to develop such a data base and import it into my excel template, as this template has the setup that i want to use... Or am i able to do all of the above in access alone?

I was hoping hat by doing so when i come to enter the data, i would not have to enter all the ammounts, just the stock id would bring up the follwing information

If possible.. i know that answer may be long and drawn out but any help would be much appreciated....:D

Thanking you
Tasha

Yes, you can do all that with Access using a table and a form. The table would contain the raw data, the form contains raw data + formulated data eg: RetailPrice = CostPrice + Tax

Raw data is entered in the form, the calculation are done by code after the last field of raw data has been filled.

Dave

okie dokie.. thanks for that..
seems i have quite a mission on my hands....

I would suggest that you search the web for access tutorials. There are many that explain in fairly good detail the development of databases.

good luck

Dave

Also search this forum for topics such as "Inventory" and "Stock Levels" - plus other key phrases like that - because I know we have beat that topic to death more than once.