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

Regards,

SID
infiniti7181Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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.,
0
Dale FyeOwner, Developing Solutions LLCCommented:
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Rey Obrero (Capricorn1)Commented:
;-)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.