Access supports pivot tables as well! Create the underlying table or query, and save it. In the View pull-down menu, select Pivot Table View and have fun with the design. The available fields are in a box on the right of the screen, and you only need to drag-and-drop to get them in the correct places.
Admittedly, Excel's pivot table is a bit more versatile. So if you want to export the underlying data into Excel, and write an Excel keyboard macro to create the pivot table there (so you can do it as a periodic report, for example), go right ahead. Use the DoCmd.OutputTo... statement to export it and open Excel in one step (not including running the macro, of course).