• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 515
  • Last Modified:

Employee Utilization - Excel or Access better

Dear Team ,

I would like to create contents such as employee name , task given dates , task number etc and would like to filter in future utilization of each per month .

I know in excel i can use dashboards , but is it possible to make in Access , that report in access will provide as dashboard results .

kindly advise. i am new into this . IF accesss is recommended then i would straight away to start working on it


  • 2
1 Solution
Rey Obrero (Capricorn1)Commented:
i'll suggest that you do this project in Access.
1. it is easy to produce report
2. you can also export information to excel
3. it will be easier to maintain/update etc.,
Dale FyeCommented:
I'd agree with Rey, but then, we are both Access developers, so we are partial to Access.

Realistically, what you need is a database for this task, not a spreadsheet.  If you are good with Excel and are familiar with VBA (coding) in Excel macros, then you should be able to pickup on Access VBA relatively easily.

However, Access is a database, not a flat file like Excel, so you must pay close attention to your initial table design (you will need multiple tables) or you will end up kicking yourself as you get further into the project.

A good place to start would be to identify exactly what you want to do (requirements).
a.  Add/Edit employee information
b.  Add/Edit tasks
c.  Assign employees to tasks.  
     1.  Do you need to record who the task lead is?  
     2.  Do you need to record the dates that the employee is assigned to the task?
     3.  Could the employee be assigned to the task multiple times, non-continuous?
     4.  Can employees be assigned to multiple tasks at the same time?
d.  Record employee hours worked per task/per day
e.  Generate reports by employee, by task, or by time period.  There could be a bunch of different reports involved.

Once you have your list of things you want to be able to accomplish, then you can start figuring out what tables you will need and how to organize the data in those tables.  I would recommend that you complete this before you start actually designing your application, and run it by us here as another question to see what the experts think of the data structure you have come up with.  Make sure that when you do this, you include the list of requirements.
Rey Obrero (Capricorn1)Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now