To Excel users:

I am trying to develop a database to organize our department's research articles and book chapters. I would like to organize this with the following fields/columns: author, citation (of article), publication - month and year (together).

There are some articles in which 2+ people in the dept have collaborated. I have to be able to quickly count/sum how many unique articles the department has written. A design that would allow me to collapse articles under either the month and year, or by author (not just filter) would be a plus.

Is this best to complete in Excel, or in Access? I've read a bit about Pivot Tables - would I use one here? Any advice would be greatly appreciated!