Join Gini von Courter for an in-depth discussion in this video Creating a simple data macro, part of Creating Access Web Apps in SharePoint 2013.
- Back in the data demo web app…that I used earlier I've added a table of months.…And this table is very similar to tables…that I've created in lots of databases…that allow us to take a look at two different ways…to look at a particular month or day…and they're system tables.…I don't want users to change them…and yet they need to have access to them.…In this case, I have four fields,…the name and abbreviation of the month,…the calendar number of the month,…and then the number of that month in our physical year…which begins in July.…
So, let's see how we can make sure that a user…can't insert or delete data from this table…because we don't want them to do that.…Let's return to Access.…You can see the view here but we're not…going to attach this to an event…that occurs in the user interface.…We're going to actually attach this…to an event of the table, a data event.…So, I'm going to open the table in design view…by choosing Edit Table.…Here are our fields and I'm going to click Design…on the ribbon and you'll see there are our three events…
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
Relational Database Fundamentalswith Adam Wilbert2h 40m Beginner
SharePoint 2013 for Site Champions and Power Userswith Mark Abdelnour2h 58m Intermediate
1. Creating a Simple Access App
2. Working with Views
3. Automating and Packaging
Next steps1m 24s
- 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.