It’s just the nature of shipping software in a services world with Office 365—when we hear your feedback, we can respond with new features that fill your needs. In the case of Access 2013 web apps, one of the most frequent feature requests we heard from customers was the need for an easier way to view their web app data in Excel. Currently, the process for viewing your Access web app data within Excel involves many steps.
We’re proud to announce that a new feature called, “Download in Excel” is available to all of our Access 2013 Office 365 customers, which makes this process much simpler. The changes are on the server side which means you do not need to update your Access client program at all. This update is available for customers using Office 365 with Access Services so look for this feature soon within your web apps and try it out.How does the Download in Excel feature work?
When viewing any datasheet views in your browser for your Access web app on Office 365, you’ll see the new Download in Excel button on the right side of the Action Bar, as shown in the following screenshot:
When you click the Download in Excel button, you are prompted to either open or save the spreadsheet. If you choose to open the spreadsheet, Excel downloads a copy of the data from the datasheet view and then immediately displays it within the familiar Excel interface, as shown in the following example:
Once you have the data in Excel, you can utilize the rich set of Excel features to perform different tasks such as:
Currently, you can download up to 10,000 records from a datasheet into Excel. If you do not want to show this option for specific datasheet views, you can hide the Action Bar for that view, which will hide the Download in Excel button.
We hope you enjoy this new Download in Excel feature within Access web apps for SharePoint, which opens up more scenarios for your custom web apps built on top of Office 365. Give it a try and let us know what you think!
The post Introducing a new feature in Access 2013 web apps—Download in Excel appeared first on Office Blogs.
When we announced Microsoft Ignite last month, we told you it will bring together the best of our past events for Exchange, SharePoint, Lync and Project—and then take it to the next level, based on what our customers and partners have asked for.
Now we are asking for your feedback so we can deliver on that promise. What do you want to see at Microsoft Ignite? Help us provide you with better content by taking this quick online anonymous survey on the sessions you want to see; Call for Topics.
We’re holding a series of TweetJams on Twitter so we can hear more about what you want to see at the event. Join us at one of the times below.Date Products Hashtag Add to calendar Monday, November 24th 9 a.m. PT @SharePoint @yammer #ignitejam ical link Tuesday, December 2nd 9 a.m. PT @MSFTExchange #ignitejam ical link Wednesday, December 3rd 3 p.m. PT @Office 365_tech #ignitejam ical link Tuesday, December 9th 9 a.m. PT @Project #ignitejam ical link
Here are general questions we’d like your feedback on during the TweetJam. Have other questions you think we should ask? Tweet them to @office365_tech.
If you haven’t already, register now for Microsoft Ignite. Early bird discount expires on December 11th.
This morning on The Official Microsoft Blog, we revealed more details about our enterprise technology conference in May—Microsoft Ignite. If you attended the SharePoint Conference, Exchange Conference, Lync Conference or Project Conference, this is the conference for you. And, if you’re interested in or already using Office 365, this is the conference for you. Register now to reserve your spot and we will see you in Chicago on May 4, 2015.
Join the YamJam:
We are committed to making Microsoft Ignite an incredible and valuable event for all of us who are passionate about Office, Exchange, SharePoint, Lync, Project and Visio. We want your feedback to help shape plans for this event. Join us for a YamJam on the Office 365 Technical Network on Tuesday, October 21st 9:00 a.m. – 10:00 a.m. PDT to ask questions about the event and to provide feedback on what you want to see there. For those unfamiliar with a YamJam, it is similar to a “TweetJam” on Twitter or an “Ask Me Anything (AMA)” on Reddit, except it takes place on Yammer.
How to participate:
Are you a developer or user of Microsoft Access or know someone who is? Interested in expanding your knowledge about the new web capabilities in Access 2013 or how to improve Access desktop applications? There are two upcoming events that you might consider attending to gain knowledge on Microsoft Access and Access Services from seasoned professionals.
J Street Technology is organizing another one-day conference on Access.
Join us Thursday, November 6th in Redmond, WA for another Access Day event. The conference will be held on Microsoft’s main campus this year.
This upcoming Access Day event will once again feature internationally-respected presenters, including Access MVPs, book authors, professional Access developers, and even a member of the Access development team at Microsoft.
Access Day will include sessions by Luke Chung, Andy Tabisz, Tim Getsch, Jeff Conrad and Armen Stein and will cover a mix of Access desktop techniques and new Access web app development. The intended audience is Access developers and advanced users who want to learn ways to make their applications more powerful and develop Access solutions for the web using Office 365.
Here’s what people said about previous Access Day events:
“Access Day has provided a welcoming environment for professionals to meet and get acquainted with peers…”
“The presentations focused on real-world solutions and scenarios and reminded me how much I like Access.”
“I really enjoyed the great mix of topics and the enthusiasm of each presenter was excellent.”
Check out Access Day 2014 to register and to learn more information and schedule details.
This one-day seminar will include sessions presented by Armen Stein, Adrian Bell, Julian Kirkness and Paul Christie.Great database design
Presenter: Armen Stein—J Street Technology
All Access Projects should start with great database structures—do yours? Armen will present the database design techniques and naming conventions that J Street Technology uses in their projects. Slides and documents will be available to attendees.Case study: useful procedures of NeoPa
Presenter: Adrian Bell—Microsoft Access MVP
Adrian will be sharing code and concepts about how to develop in a way that is consistent and therefore more maintainable. Procedures that cover many areas we all need to work within and around will be discussed. Examples that will be shown include string manipulation, SQL specific string manipulation, process optimization, security (passwords), progress display, basic tools for working with files and more.Web Apps–from idea to App store
Presenter: Julian Kirkness—Microsoft Access MVP
Julian has an impressive record, he was the first person worldwide to put up an Access-based web app in the Office Online store. As such, he is well placed to describe how Office Online—and Access web apps—can benefit you, both as a user and as a developer.The non-Access parts of Office Online
Presenter: Paul Christie
We have been given some excellent information about using the Access Web App but what about the rest of Office? There are Web Apps for Excel, PowerPoint and Word. Paul will quickly run through what can be done with PowerPoint and Word and then focus on the Excel Web App. He will look at the Table functionality that came in with Excel 2007 and what limitations there are when using some of these facilities in the Web App.Access form techniques
Presenter: Armen Stein—J Street Technology
Armen will demonstrate ways to make your Access forms more powerful and easier to use and navigate. Techniques will include alternatives to tabs, daisy-chaining forms and custom navigation buttons. Slides and documents will be available to attendees.
Visit the UK Access User Group site to book your spot now for the UK Access User Group Fall 2014 National Seminar and for seminar details.