Join Gini von Courter for an in-depth discussion in this video How to report on web app data, part of Creating Access Web Apps in SharePoint 2013.
- Everything we've been creating is all about views.…This is a totally form-based application.…So, what if I wanted reports?…How would I create them?…If you need to create reports,…what you'll do, is you'll actually create another database…that connects to the same data source right here.…So, I was here in Access.…I go to File and I would choose Report on my Data…and what you're going to create…is another database that will be connected.…
If necessary, this will also…enable a read-only connection…and open a firewall to your database…because all you'll be using it for is reporting.…So, if you are the person in your organization…who needs to start working on reports,…and you're thinking wow, I really like this web app,…but I need to have some printed reports…and I don't have a good way to do that…with what I have, yes you do.…You'll just create a desktop database…that connects to exactly the same data.…So, as you and the other people on your team…or in your area are working with the data…and making changes, your reports are…
- Creating a new app
- Building tables from different sources
- Creating relationships between tables
- Working with views
- Using macros for automation
- Saving your app in an app package
Skill Level Intermediate
Q: The "Using the If macro action" movie seems to end in the middle of troubleshooting. What am I missing?
Q: This course was updated on 08/25/2017. What changed?
A: New videos were added that cover changes for Access Web Apps and migrating Access Web App data to SharePoint Online.