Help / advice needed

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

Guest

Hi all,

Originally this question was submitted in the Excel user group but a
suggestion was to contact Access as well as this may be a better method to
get where i want to go!!

i am looking for some help and advice regarding how to set up several
different worksheets to interact.
Basically i wish to create the following:
1. a worksheet that will show total run time in hours & minutes of work
carried out sometimes stretching over more than one day through midnight.
2. an inventory of parts that can generate a stores order form each week of
spares required that have reached a minimum level.
3. a worksheet for defects that has an entry for spares used that will
interact with the inventory sheet.
4. a stores order / received sheet that is generated by the inventory and
when received will update the inventory levels.
5. a maintenance sheet that can interact with the inventory sheet when
spares are used,

Pretty easy i guess if you are familiar with excel / Access but as a
beginner it
looks like a very formidable task.

Can anyone point me in the right direction please?

Rgds
Kev
 
Access would be a better tool for what you want to do than Excel. There is
not real advantage to using Excel as the interactive tool here. All you
really need is Access. Setting it up and getting it working correctly, if
you have no Access experience will be a little intimidating, but if you are
eager to learn, you can do it. What is your experience level with:
Excel
VBA
Access
Any other relational database system

Please let us know so we can help get you going in the right direction.
 
Back
Top