Database Help Needed....

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have been trying to get a database sorted for a number of months. However,
I still feel that I am no further forward. I think that it is quite complex
(well it is for me) and really need someone to 'hold my hand' as it were.

I need to design a database to keep all of our stock records in (mainly ink
cartridges). We have a huge excel spreadsheet at the mo that works out all
our prices etc. However it is starting to get a bit slow. We want a one stop
solution where we create a product (cartridge) and then create the printer
and choose which cartridges fit etc. However, and I am not sure if Access can
do this, but we want to be able to set our cost price, then for it to use
lookup tables to calculate postage, weight, fulfilment cost etc and finally
generate a sales price.

I am not sure where to start, hence this plee for help. So if anyone has
some time and willing to help a newbie, please let me know.

Many thanks,

J
InkFuzion
 
Hi,

I have been trying to get a database sorted for a number of months. However,
I still feel that I am no further forward. I think that it is quite complex
(well it is for me) and really need someone to 'hold my hand' as it were.

I need to design a database to keep all of our stock records in (mainly ink
cartridges). We have a huge excel spreadsheet at the mo that works out all
our prices etc. However it is starting to get a bit slow. We want a one stop
solution where we create a product (cartridge) and then create the printer
and choose which cartridges fit etc. However, and I am not sure if Access can
do this, but we want to be able to set our cost price, then for it to use
lookup tables to calculate postage, weight, fulfilment cost etc and finally
generate a sales price.

I am not sure where to start, hence this plee for help. So if anyone has
some time and willing to help a newbie, please let me know.

Many thanks,

J
InkFuzion
Click to expand...

This is quite a substantial project, but a) Access can certainly do
it; b) you can do it incrementally, e.g. getting your stock and prices
in first, and adding the fancy stuff like price and shipping
calculations later.

One question: do you have budget for this? It may be more time- and
cost-effective to hire someone already skilled in Access, vs. spending
a lot of your own time.

If you do want to do it on your own, we can certainly help. As Tina
suggests, there's a lot to learn. Some additional resources that might
help are at:

Jeff Conrad's resources page:
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

John W. Vinson[MVP]
 
Back
Top