Help please

[tinkz]

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....

Thanking you
Tasha

 

[dcobau]

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

 

[tinkz]

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

 

[dcobau]

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

 

[The_Doc_Man]

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.