The set of video tutorials on Access Services for SharePoint 2010 on SharePoint-Videos dot com includes instruction on creating data macros (which serve as workflows for SharePoint Server 2010) associated with specific tables in an Access Database. The audience for this video instruction is clearly SharePoint and/or Access administrators, developers and architects.
If viewers intend to approach this training video as a course, then be sure to build all of the tables referenced by this (and other video tutorials in this set) prior to embarking on this set of courses. Bruce Herz builds a “Lookup and Relationship” field from data stored in a “Neighbors” table which we did not have at the ready as we stepped through each of his instructions. Having all of the tables in place will ensure prompt completion of this training.
This video is particularly useful. The “before” macro that Bruce produces, which checks a table to ensure that an authorized user exists, provides an important safeguard against unauthorized use of the reservation process that is effected through the Access database built throughout this training series. While the training is geared to technical staff, it is useful for business users to grasp the purpose of the macro as a means of establishing value for the training. In fact Visual Basic for Applications (VBA) code cannot be used with Access Services for SharePoint Server 2010; therefore, macros like this “before” macro provide an important function that would, perhaps, require a much higher skill level (at, potentially, a much higher cost) should an application written with Visual Studio be required to deliver this same procedure.
As we proceed through the steps required to build the macro, we do remark on the importance of including comments along with each step. Certainly our developer audience will be familiar with the rationale for including comments, but the information will be useful for business users who choose to study this video. All of the steps are taken with reference to the “Neighbors” table already alluded to above; therefore, and to reiterate, it would be most helpful to have the table in place prior to starting the training.
For trained individuals with a high level of familiarity with building macros with visual tools this training can be highly useful. By reviewing this presentation an appropriately trained individual can embark, right away, on accomodating the needs of business users in an otherwise “foreign” area. If you would like to learn further about how best to plan for the needs of business users with regards to working with video training content for SharePoint, please do not hesitate to contact us. Call us at (630) 786-7026, or Contact Us to further a discussion about this offer. Of course we are happy to speak about your SharePoint development plans, as well.
As ever, use this link to place an order for an annual subscription to SharePoint-Videos instructional content
© Rehmani Consulting Inc, all rights reserved