Access 2000 doesn't have pivot table capability (though Access 2003 does).
Access' crosstab query function approximates a pivot table, though it is much
less robust and capable than a true pivot table.

As for training for pivot tables, I'm not really sure that's necessary.
Once you've created a pivot table you pretty much understand how to create
them in the future. This site gives some good information about pivot
tables: http://www.cpearson.com/excel/pivots.htm

As with anything else in Excel the best way to learn is to read an
introduction, find yourself some data, and start to manipulate.

Dave
--
Brevity is the soul of wit.


"GinaS." wrote:

I am starting a job where I will be using Pivot Tables extensively through
Excel and Access through Office 2000. The employer offers minimal background
and training, but I would like to be able to see it in a different framework.
Any thoughts or suggestions for training sites I can cruise online?