Which is easier to use for this project?

[SIRSTEVE]

I currently have a spreadsheet that lists the following fields.

· User Name
· Date
· Number of Request
· Total Time
· Total Time Per Request
With these fields I would like to create a database that will give me an
average of the number of request received, times the total time spent on each
request, ending with the total time per request.

Also, I would like to be able to run reports that will allow me to see the
totals and averages by user, date, and by group.

Which one of your programs would be easy to use to create this project.
Excel or Access.

If you could let me know this information as soon as you can, I would
greatly appreciate it. Thanks.

 

[Tom van Stiphout]

On Sun, 4 Apr 2010 05:36:01 -0700, SIRSTEVE

Excel has a grouping feature, and an Avg function. Why not stay there?

Access can do this too, but Access is not Excel on steroids. From a
relational database design perspective this data is not relational and
contains calculated values, so you're already two strikes behind.

-Tom.
Microsoft Access MVP

 

[ryguy7272]

Definitely keep it in Excel. Look here for some ideas of how to manage your
data:

http://www.contextures.com/xladvfilter01.html
http://www.contextures.com/xladvfilter02.html

http://peltiertech.com/Excel/Pivots/pivottables.htm
http://www.cpearson.com/excel/pivots.htm