Share via

creating a database to track work orders and other information

Anonymous
2013-08-07T17:33:31+00:00

Okay I am very new to Access. I have created a data base in Excel for my bosses to see work orders that have been completed and to see how much profit they're making and how  much the job ended up totaling etc.

Well now they would like to be able to find specific info like pilot A planted rice in Airplane b how much did he make versus when he flew airplane a. Does that make sense? They want to be able to see jobs that only say Airplane A did during the day. Or whatever.

This seems like something a query would be good for? Or should I keep it in excel? I just need help deciding if Access is what I need or if I need to figure it out in Excel.

Thanks in advance!

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2013-08-07T19:39:29+00:00

    I would use Access (though I could be bias).  This should get you started...

    http://www.access-diva.com/dm5.html

    Was this answer helpful?

    0 comments
  2. ScottGem 68,810 Reputation points Volunteer Moderator
    2013-08-07T19:35:26+00:00

    Access is the better tool. And yes you would use queries and reports for such things.

    Was this answer helpful?

    0 comments