What happened to Pivot Table view in Access 2013?

Renehubard,

Sorry but no I don't know of any other software that I would put in the same league as Access (and with Pivot tables).

I'm on the same situation. I just purchased Access 2013 assuming it would have Pivot Table View which I use constantly at work. I never thought that an upgrade would rid itself of important features... Disappointing. Any idea of other DB software out there that has a similar feature and that is compatible with Access?

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.

Sorry Tom, those are lame after the fact rationalizations produced as excuses by management and the PR department for bad design decisions.

Having Pivot TAbles in both Access and Excel exposed the feature to more users, hopefully leading to more use of the tool.

If those "rules" were truly being applied to all extraneous features in the Office suite, then there would be little reason to include the extensive PHOTO/Image editing features that were added in Office 2007 (and extended since then) to Word, Excel and PowerPoint (and maybe to other Office apps that I don't use). They would have been limited to PowerPoint and users would have been told to copy and paste from PowerPoint into Word and Excel...

If all that manpower has been "poured" into the web apps, why have we seen so little change (I admit there has been some) to their feature sets?

I've got some stat's used to rationalize the draconian imposition of the ribbon gooey

"in Word 2003 and earlier MS Stats show only 13% of commands/ features are actively used..."

on that basis 87% of the features could be eliminated !  That would certainly simplify the programs. <grin>

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?