A family of Microsoft relational database management systems designed for ease of use.
Nicely put Algis. I couldn't agree more. There's a market and a huge opportunity that Microsoft is not seeing of and sooner or later someone else will.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I cannot see this feature in Access 2013...was it really discontinued?
A family of Microsoft relational database management systems designed for ease of use.
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.
Nicely put Algis. I couldn't agree more. There's a market and a huge opportunity that Microsoft is not seeing of and sooner or later someone else will.
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more
Unofficially, the answer is simple. It is a way of extracting more money from customers.
That actually makes no sense. Most people buy Access as a part of Office Pro. So they already have Excel. If anything this might decrease revenue as more people might skip Pro and go with Standard.
You can see that we, the Access development community are disappointed and getting very nervous. There appears to be no future for Access and that makes me very nervous.
I had to comment on this. Mark, Access is not and has never been designed for the developer community. It is being targeted towards the Knowledge Worker. That Access has proven to be a tool for developers has knocked MS for a loop. They want developers to use Visual Studio.
Also, a new version doesn't necessarily mean improved in every feature. The fact is that Pivot tables are not easily understood by the knowledge worker. And while developers have made great use of them to make attractive apps for end users, developers are not the target market. So, resources have been diverted to other enhancements and some features have been deprecated.
It is not that difficult, to automate opening an Excel sheet from Access to use Pivots there.
"maintaining both seems wasteful"
similar to now having to develop/maintain our applications in MS Access with the related pivot tables/forms in MS Excel? MS just moved the burden to the users instead of the Microsoft developers, I guess. very disappointing!