MSAADA: inventory and sales database for cosmetic shop

wanandugu za weekend.
naomba mnisaidie kitu hiki. nataka kuwa na simple database or excel sheet ambayo nitakuwa naweka kumbukumbu ya manununuzi na mauzo ya cosmetic produts.
parameters zinazohusiana na manunuzi ni hizi:
[TABLE="width: 315"]
[TR]
[TD]

• date of purchase of products

[/TD]
[/TR]
[TR]
[TD]

• name of products purchased

[/TD]
[/TR]
[TR]
[TD]

• quantity per product purchased

[/TD]
[/TR]
[TR]
[TD]

• purchase price per product

[/TD]
[/TR]
[TR]
[TD]

• total quantity of inventory on hand per product

[/TD]
[/TR]
[TR]
[TD]

• remarks per product purchased

[/TD]
[/TR]
[/TABLE]

parameters zinazohusiana na mauzo ni hizi:
[TABLE="width: 315"]
[TR]
[TD]
[TABLE="width: 319"]
[TR]
[TD]

• date of product sale

[/TD]
[/TR]
[TR]
[TD]

• name of products sold

[/TD]
[/TR]
[TR]
[TD]

• quantity per product sold

[/TD]
[/TR]
[TR]
[TD]

• selling price per product

[/TD]
[/TR]
[TR]
[TD]

• customer details per product sold

[/TD]
[/TR]
[TR]
[TD]

• customer details (name, email, phone, location)

[/TD]
[/TR]
[TR]
[TD]

• remarks per product sold

jamani naombeni msaada nifanyeje kupata simple database or excel sheet ya kuweza ku-track transactions information.
ahsante[/TD]
[/TR]
[/TABLE]

[/TD]
[/TR]
[TR]
[TD]
[/TD]
[/TR]
[TR]
[TD]
[/TD]
[/TR]
[TR]
[TD]
[/TD]
[/TR]
[TR]
[TD]
[/TD]
[/TR]
[TR]
[TD]
[/TD]
[/TR]
[/TABLE]

exel spreadsheet itafanya hiyo kazi, kwa kuwa ni simple tu ya kuweka records exel inafaa.

urahisi kivipi, nipe template kama unayo

urahisi ni kwamba inachukua data tu na kuziweka,complicated ni kwamba itakuwa inafanya processing na computation s yenyewe ya hizo data,like kutafuta average, total, balance, profit,iwe inakupa update bidhaa inapokuwa imeisha,kuita specific record from documents,nk,nitakutengenezea tempelate uangalie. Unaposema inventory system ya kutrack data haiwezi ikawa simple, nafkiri umenipata.

jifunze kudesign db, then jifunze kuandika Query za SQL na kama unahitaji system yako iwe user friendly, then tumia Visual Basic 2008 for GUI programming!

nisipngependa kuanza kujifunza jinsi ya kutengeneza database nachohitaji ni jinsi ya kutumia. ningefurahi kupata mtu wa kunisaidia kuni-designia, then tunaelewana

kanyagio said:

nisipngependa kuanza kujifunza jinsi ya kutengeneza database nachohitaji ni jinsi ya kutumia. ningefurahi kupata mtu wa kunisaidia kuni-designia, then tunaelewana

Click to expand...

I can make a good application for you to do that, but how much do you have in your pocket?

Simple! How much do you have?

Ninayo hiyo software. Ni pm namba yako nitakupigia au nipe email

mkuu ahsante sana, nashukuru sana ... na-PM sasa

iMind said:

Ninayo hiyo software. Ni pm namba yako nitakupigia au nipe email

Click to expand...

tafuta tally erp9, zipo online kibao..kwenye torrents unapata full version free!!