What happened to Pivot Table view in Access 2013?

Ah, but you are creative enough to smoothly export your data to Excel switch to it for pivoting, just like MSFT expects that you will.

Certainly, but having to switch programs to do this is just silly.  Frankly, I don't understand the purpose of a database access program if not to extract data into reports, tables and graphs.  I mean, that's why you access a database.

A spreadsheet is NOT a database, no matter how much you want it to be.  There are many who try to use Excel as a database, but it simply isn't.  It's a great, great program, but Access is made for this.

Our instructor showed us how to create and manipulate pivot tables and pivot charts in Access 2010 and I was blown away at how easy it was to manipulate with the graphical interface.  I'm very disappointed that all of the students with Access 2010 will be able to do this and I won't.  The instructor has made it optional because of this fact, but I'd still love to be able to delve into it.  It's a wonderful, powerful way to manipulate data, especially if you're dealing with a huge data set.

I'm in a class of 40, and only one of MANY such classes around the U.S. and the globe.  Everyone in the entire class was disappointed that the lab computers had 2013 and weren't able to do this.  I have no doubt whatsoever that there are classes and small businesses all over the world who are equally disappointed.

Obviously bigger companies using Big Data are using Minitab, the insanely priced JMP or some similar program, but smaller companies can't be paying $15,000 (JMP)or even $1,400 (Minitab) for their database programs.  Access was the alternative.  Losing that functionality was a bigger deal than you think, and if surveys to customers revealed that they weren't using that functionality, it simply means they weren't aware of it or didn't know how to use it.  The pivot tables and charts in Access were a beautiful thing.

Even if the Access Pivot Table and Pivot Chart function was merely a link to open that feature in Excel, it should be there and it should be seamless.

Yes, it was discontinued, see...

http://technet.microsoft.com/en-us/library/cc178954(v=office.15).aspx

Our company is just upgrading to Office 2013 and I am among the early testers...

Discontinued pivot tables and pivot charts are a big loss - luckily I have the older version at home that I can keep on using - perhaps I need to look for another option for Access database. Any suggstions?

What is the purpose of having database if you can do everything with Excel - I doubt Excel can't deal with such huge amount of lines?

Maybe I should have been more clear:

* Because a superior version exists in another MSFT tool (Excel) and maintaining both seems wasteful

* Because even maintaining a feature throughout the versions requires manpower which we like to pour into the web features

* Because data from the Customer Experience program tells us few people use it.

There are several other features cut from A2013 that fall in this category. I understand you don't like it, but there is a rationale, and there is a path forward.

Tom, I don't want to rely on Excel.  I have perfectly good systems in Access 2007 that product fantastic pivot charts dynamically and I don't want to change that in any way. 

As another developer put it, the good facility was there, why not keep it.

Mark

Ah, but you are creative enough to smoothly export your data to Excel switch to it for pivoting, just like MSFT expects that you will.