Database Help Needed....

[JimJam]

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

 

[tina]

you need to 1) learn the basics of relational design principles, and then 2)
learn the basics of using the software. for more information, see
http://home.att.net/~california.db/tips.html, beginning with tips 1 and 2.

hth

 

[John Vinson]

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

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]