Hello all,

I'm trying to help out a charity which refurbishes baby equipment (cots, prams etc) to give to the underpriveleged. The charity gives work to the long-term unemployed & to those with mental health issues &, needless to say, doesn't have too much time to spend with databases.

I am trying to help them to create a very basic stock management system so that their workers can feel more involved & that they can keep track of what has been brought in, checked & sold. however, I am not very good at this & would like someone to point me in the right direction. We've got MS Access on the Charity's machine & we'd like to create a simple access project to do what I've outlined below.

If anyone can give me a hand, I'd be grateful. I think it might take a guru about an hour but fear it'll take me a year.

Thanks

Jim

Stock Control

Items are brought into the workshop & registered
Items inspected & tested & then added to stock
Items sold

Identifying features

• Item type (eg Pushchair, highchair, pram, cot)
• Item code (shorthand for the name)
• Date received (date the item has been brought in & registered)
• Date added to stock
• Stock number (unique ID for that stock part)
• Date sold


What the database project needs to be able to do:

• Add item types & codes
• View item by stock number
• Register received item
• Add item to stock
• Register item & add it to stock at the same time
• Adjust stock levels



Reporting tasks for the project:

• Number of items of a particular type
• Number of items registered this week
• Number of items added to stock this week
• Number of items added to stock between two dates