- If this was a desktop database that we were creating,…we would be going to a relationships window…to view the relationships between these five tables.…That's not how it works here.…But if you understand how tables are related broadly,…you're not gonna have any problem…figuring out how to work with the relationships here either.…But you do have to keep a model of them in your head.…What we have are three main tables,…Issues, Customers, and Employees…and then two tables that are related.…
The Issues table is really the core here.…And I'd like to be able to open it in design view.…Now, in the Navigation Pane…I can actually choose Design View directly.…I can also choose Open.…If I'm using the Navigation here within the app,…then I won't have a choice for Design View.…I will have a choice for Edit Table,…and Edit Table is the same as choosing Design View.…I'm going to turn off the Navigation Pane…to win some space back,…right-click, and choose Edit Table,…which, again, looks just like Design View looks…when we're in a desktop database in Access.…
AuthorGini von Courter
- 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.
SharePoint 2013 for Site Champions and Power Userswith Mark Abdelnour2h 57m Intermediate
1. Creating a Simple Access App
2. Working with Views
3. Automating and Packaging
Next steps1m 35s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.