In Progress

Stock Database

I require a database setup (access is ok) to handle the following:-

On receiving stock :-

[url removed, login to view] Supplier

[url removed, login to view] Quantity delivered in Kilograms.

[url removed, login to view] "Estimated" Quality and value as follows :-

Grade 5% to 9.99% @ $X/Per % Value.

Grade 10% to 14.99% @ $X/Per % Value.

Grade 15% to 19.99% @ $X/Per % Value.

Grade 20% to 24.99% @ $X/Per % Value.

Grade 25% to 29.99% @ $X/Per % Value.

Grade 30% to 34.99% @ $X/Per % Value.

Grade 35% and over @ $X/Per % Value.

Tests are performed to determine actual quality.

Upon tests then to be able to input actual %Quality value and database to place it in correct category.

Example if originally thought to be 15%, but upon test result it turns out to be 14.99%, then it should be moved into the 10%-15% category.

Stock is then packaged into a container and labeled with a 11digit code for that batch, during packaging the stock is re-tested for quality, weight, and also moisture.

The database should allow for 2 test results of quality to be input and then average the results.

It should then using the same grading table as above place a value of the stock using the new test results.

It should calculate the moisture content and minus it from the net weight.

It should be able to print out reports of the above data for each batch received or packaged, or a list report of a number of batches.

..thats about it...feel free to ask questions if wht I need is not clear.

Skills: Visual Basic

See more: supplier quality, stock, stock content, in stock, grading, grade, calculate grade, basic free test, visual basic grade, calculate quantity, packaging report, database example, stock report, visual basic net average, net tests, quantity using, able calculate, access receiving database, free batch code, supplier list, code database access, free access stock database, batch free, average quality, need database list

About the Employer:
( 23 reviews ) Charlton, Australia

Project ID: #194947

Awarded to:

xamdam91

Looking forward to working with you.

$100 USD in 2 days
(54 Reviews)
6.1

18 freelancers are bidding on average $69 for this job

rajanlengde

I can do this, see PMB.

$75 USD in 10 days
(26 Reviews)
5.1
ltcandrew

Please see private message area for bid details. Thank you.

$55 USD in 1 day
(5 Reviews)
4.9
KellogITSolution

Hello Plz Check your PMB for my bid. Thanks

$40 USD in 1 day
(12 Reviews)
4.3
rajhansh

i can work with you. Please pm me if u are intrested.

$100 USD in 10 days
(13 Reviews)
4.1
darklord18

Dear sir,i can do the job at a very low price as money is not that important!I just want to do the job as a challenge!I will give the best of myself and provide what you have asked with quality and as fast as i can(may More

$30 USD in 5 days
(3 Reviews)
3.7
ajay192

Please see PMB for details.

$100 USD in 2 days
(3 Reviews)
3.6
gotu123

hello sir i am doing 2 projects in the VB which mostly depends on the database besides bidding on this project,it will be helpful to me if i can benifit your stock database project with my experience ,for more detali More

$75 USD in 15 days
(0 Reviews)
0.0
jiauls

we have 4+ yrs. experience in vb,access . so just wait for your possitive reply.

$60 USD in 10 days
(0 Reviews)
0.0
unixsam

we are looking forward to deal with you

$30 USD in 5 days
(0 Reviews)
0.0
arvindtonk

may i ?may i ?may i ?may i ?may i ?may i ?may i ?may i ?may i ?may i ?may i ?may i ?may i ?may i ?may i ?may i ?

$55 USD in 7 days
(0 Reviews)
0.0
Suddashil

i can do it. I am a [url removed, login to view]

$70 USD in 7 days
(0 Reviews)
0.0
tmitra

3+ yrs exp in Visual Basic. waiting for your reply.

$90 USD in 5 days
(0 Reviews)
0.0
pbarbas

Top quality work in 4 days.

$100 USD in 4 days
(0 Reviews)
0.0
gopalji123

sir, we can do it...waiting for your response.... thanks, Gopalji Enerjetics

$60 USD in 1 day
(0 Reviews)
0.0
jrnyk

Hi Sir, I have 5 years of experience in Oracle as back end and VB as front end. I can do this project in 5 days. waiting for a quick reply.

$70 USD in 5 days
(0 Reviews)
0.0
dbaSolutions

Dear Sir or Madam, Please check your PM for the details of our proposal. Best Regards

$60 USD in 2 days
(0 Reviews)
0.0
PwrComp

I can complete this project, as requested. See PM

$75 USD in 2 days
(0 Reviews)
0.0