What happened to Pivot Table view in Access 2013?

Anonymous
2013-03-31T17:57:35+00:00

I cannot see this feature in Access 2013...was it really discontinued?

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

127 answers

Sort by: Most helpful
  1. ScottGem 68,840 Reputation points Volunteer Moderator
    2015-04-22T01:34:27+00:00

    The only way it becomes a contradiction is if you don't read what I actually have said instead of what you want to think I said. That Access is  a tool for a small business developer is undeniable. That doesn't mean that Microsoft planned it that way, Yes, Access was designed from the beginning to be an end user/small workgroup tool. That it has become what it has is mostly inadvertent, not planned.

    And no, those things don't support your argument. Migration to SQL Server was improved with SSMA so the Upsizing wizard became unnecessary. Net Gain! Pivot tables are a net loss, but the ability to do Pivot tables was not taken away just moved. Granted it makes doing them more cumbersome, but its not a complete loss. As for the security feature, MS is moving away from Jet and towards SQL Server, has been for a while. ADPs were a flawed attempt at that, SQL Server clearly has a much more powerful security model. It was removed for the same reason other features were removed. MS has a limited amount of resources and has to prioritize what it can support. I don't understand how you can say that is not consistent with Access as a Developer platform. Doing so shows a lack of understanding of what Access is. The Jet engine is just one part  of Access. It is actually it's weakest part. But the fact is that it is an interchangeable part. One can develop a full application in Access with UI, reporting and workflow processing and then plug in almost any database engine.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2015-04-22T00:08:42+00:00

    ADP was not an alternative to ODBC it was an alternative to having a full JET based front end. Why remove the option unless it was to reduce developer options? What you describe as "quirky" with disdain was actually a pretty handy feature. Now, if you want to secure an Access database you have to upsize to SQL Server. Again... not consistent with Microsoft promoting Access as a developer platform.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2015-04-21T23:58:33+00:00

    You seem to be contradicting yourself, Scott. You say you doubt Microsoft ever were interested in the small-time business developer in one sentence and then in the next assure everyone that Access still is such a tool. In previous posts you've claimed Microsoft only ever intended it as an end user product.

    There has been a net loss of developer features in the box since 2003. Sharepoint integration is poor and, in any case merely confirms my opinion that they are moving in an IBMesque way. Data macros are the exception but the loss of the security feature, pivot tables, and even the upsizing wizard supports my argument.

    Was this answer helpful?

    0 comments No comments
  4. ScottGem 68,840 Reputation points Volunteer Moderator
    2015-04-21T15:42:59+00:00

    Microsoft are still interested in the end user consumer market but not the small-time business developer.

    If the trend carries on like this, they will no doubt do away with Access completely. Three versions on the trot now have dumbed down the product.

    The first sentence is different from what you originally stated. I'm not sure if MS was ever really interested in the small time developer. 

    I also strongly disagree with your statements that Access WAS " (up to 2003) an excellent small business development tool.". I think it remains an excellent small business development tool. You refer to the Runtime version. Well its now free whereas, in 2003, you had to purchase a Developer's Edition. The "sophisticated security model" was quirky, cumbersome and disdained by myself and many other professional developers I know of. I know people bemoan the loss of ADP, but ODBC remains a more than viable way to use Access as a front end to SQL Server and other databases. The Upsizing Wizard was replaced by SSMA which, according to what I hear is better and more recommended. And yes I also bemoan the loss of Pivot tables and dbf support. 

    And what "trend" are you referring to? You cite things that have been removed but don't talk about what has been added like linking to Sharepoint lists, Web apps, data macros, and other features. So this trend you refer to is one-sided and, in no way indicates a trend towards dropping Access. 

    The reason I responded to post here is because I see a lot of one-sided inaccurate hogwash being posted. And felt the need to present a different, more factual viewpoint.

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2015-04-21T12:53:12+00:00

    Windows 8, like the Mobile platform, is geared to the end user, not the small business developer, Scott. Microsoft are still interested in the end user consumer market but not the small-time business developer.

    Access was (up to 2003) an excellent small business development tool. (Runtime version, sophisticated security model,  ADP thin client SQL front end, Upsizing Wizard and, of course, Pivot Table support.)

    If the trend carries on like this, they will no doubt do away with Access completely. Three versions on the trot now have dumbed down the product.

    Was this answer helpful?

    0 comments No comments