Hi
I hope you could help me out.
I was actually trying to maintain my inventory in access.
i want to maintain material in & out so that at month end i can generate a report & also see what are the stocks left out with me. This would be better if there is a userfriendly form so that i can enter in the form & the materail gets added in the Table.
I dont know from where to start & how to start please suggest.
hopping your early response..
Regards
Manoj
Hi Manoj,
It is fine to use Access for this purpose. First you have to create a table and put fields in it.
1- Open your database
2- Under Objects go to tables
3- Click on New button
4- Choose Design view
5- In the Field Name put the fields you want to be in your database. For example: ProductName, ProductCode, ProductPrice. Try not to put spaces in the name of the fileds. You may start each word with capital letter.
6- In the Data Type assign the type of the field
7- Then go to forms and create a new form based on that table
For any other help, don't hesitate to ask,
Abolos