Web Reporting with Access 2013 Web Apps on Office 365

We are happy to report that our Remote Desktop hosting can be configured to connect to Office 365 to use Access to report on your Access 2013 web apps.  Our Remote Desktop hosting allows you to use the power of Office 365 as your backend and then you can use our HTML5 PowerRDP technology to get around Office 365’s inability to render Access 2013 reports in the web browser.  This is a great way to get more out of your Office 365 subscription with MS Access 2013.  If you already have a $29/month Access 2013 Pro or Office Pro plan, you should be able to follow the quick tutorial below to start building web reports for Access 2013 web apps.

Step 1: Open your Access Web App in MS Access 2013

reporting-office365-msaccess13-1

Login to Office 365 and Navigate to your Access Web App.  Click the customize in Access button to download the Access 2013 .accdw file and open it in Access 2013.

Step 2: Report on your Access Data

report-on-my-data-office365-msaccess13

Navigate to the Info tab of your Access 2013 web app file (accdw) and select the “Report on my Data” button to create an Access frontend that can report on your Office 365 / SharePoint 2013 backend.

Step 3: Create Reports in your Access Frontend

reporting-office365-msaccess13-2

Now that you are using linked tables to connect to Office 365 and your SharePoint 2013 Access Web App, you can take advantage of all the features of the full version of the Access 2013 desktop client.  Create and design your reports, forms and queries.  Remember to close and save all reports and save your Access frontend file on the Remote Desktop.

Step 4: Reporting now works on Office 365

reporting-office365-msaccess13-3

Now your reports are connected to Office 365 and accessible from any machine, tablet, device and web browser via our Remote Desktop hosting!

This entry was posted in Access 2013, Office 365, Tips & Tricks and tagged , , . Bookmark the permalink.

Leave a Reply