We cross checked our SharePoint-Videos tutorial, Publishing Web Applications to SharePoint Access Services to point out any anomalies that a business user may encounter should he/she apply the instruction to an Office 365 E3 SharePoint instance or to a comparable SharePoint Online instance offered by another cloud services provider.
Bruce Herz opens this video tutorial on publishing an Access Database to SharePoint Server 2010, Enterprise with Access Services by summing the procedures that he has demonstrated through the first 4 videos of this 1 video set. He notes that a no-code approach has been used to create tables, macros, queries and even navigation objects.
The next step is to test the compatibility of the database with the standards applicable to web databases. He notes that the “default start up web display form” must be set. His instructions to click on the file tab, options, and then current database are entirely consistent with our test system, which runs Access 2010 per the Office Professional update included with our Office 365 E3 plan. Our “display form” and “web display form” were populated with the same label, “Main”. This label differs from the “NavigationFormMain” label that Bruce demonstrates. However the complete consistency between the names for the two type of forms is actually the point, rather than the literal label itself.
Bruce then demonstrates how to publish the database. The first step is to run an automated compatibility test with the “Compatibility Checker” feature of Access 2010. This worked for our test system precisely as Bruce demonstrates in the video. Once the database has passed the compatibility test, Bruce shows how a URL can be selected with on premise SharePoint Server 2010, enterprise. We were not offered that option through our Office 365 E3 Plan account, which makes sense when one considers that the URL is predefined by Office 365 for the user; therefore, we do not think this difference materially effects the usefulness of the training presented.
The remainder of this video appears to us to be entirely consistent, regardless of whether or not one uses a SharePoint Online, SaaS option, or on premise. What may be disconcerting for a business user is that the database components differ from the database which is uploaded to SharePoint and the database that has been put together through the first 4 videos. However, the intended audience are administrators, developers and architects; therefore, these differences should not be consequential. Further, these SharePoint users can certainly provide end users with a better orientation to the differences prior to the end user proceeding on this training.
If you would like to learn further about this set of video tutorials and the subscriptions that we offer for groups of users, then please do not hesitate to contact us. Please contact 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