Join Gini von Courter for an in-depth discussion in this video Creating a query, part of Creating Access Web Apps in SharePoint 2013.
- Just as with Microsoft Access 2013,…we have the ability to create queries to use…in our web app, so if you have two or more…related tables and want to be able to display data…from them or if you want to take a table and…create a query to filter it in a particular fashion,…you can do that as well.…You will find queries under Advanced,…very first item at the top.…So I'm going to choose Query, and it'll open up…the query builder.…If you're relatively new to queries, or even if you're not,…if you're experienced with them, I would like to recommend…Adam Wilbert's Access 2013: Queries in Depth course,…which is a really deep dive into how we create queries.…
But we choose one or more tables, and then we can…also choose to have particular…fields of data that we're showing.…So if I wanted, for example, to have my projects table,…and I can simply click Add.…And then Related Issues.…If I decide, no, I don't want Related Issues,…I'm going to remove that.…Then what you can do is you can select the table right here.…Just hit the Delete key.…
- 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.