Access Services is a new feature built into SharePoint Server 2010 Enterprise Edition that supports close integration with Access 2010. By combining the power of SharePoint 2010 and Access 2010, the end user enjoys a fully integrated business solution that has never been available before, all without having to write any code. Access 2010 enables users to quickly develop Web based applications using the easy to use Access 2010 development design surface to create interactive and dynamic web databases, forms, reports, queries and macros.
This course explains the key benefits and architecture of this new level of integration, and it provides the technical details of how to build a complete custom web application using the many built-in tools available within Access 2010. Once published to a SharePoint site, learn how to enhance the completed application with other SharePoint built-in features such as document libraries and many other capabilities.
Target Audiences: SharePoint Site Administrators, Power Users, Developers, IT Professionals
Role Description:
|
 Content Author: Bruce Herz |
| SP 304 – Build and Manage Web Compatible Databases with Access 2010 and Access Services | |||
|---|---|---|---|
| Level: Advanced Available on dvd Approx Time: 2 hrs | |||
| Title | Abstract | Duration (mm:ss) | |
| Introduction to Access Services | In this video, you will get an overview of Access Services using SharePoint 2010 and Access 2010. You will learn how and why the new Access Web Databases can be integrated with SharePoint 2010 to create Web compatible Applications. | 8:15 | |
| How to Create Web Database Tables | Create a new Web Database Table manually and by using two new features call Data Type Parts and Application Parts. You will be introduced to some of the key differences between Access 2010 Rich Client and Web Databases design environment. | 10:00 | |
| Modify Tables and Validation | Learn techniques in modifying tables in layout view and when and how to create Calculated Fields, Lookup Wizard and Field Validation. | 10:39 | |
| Introduction to Data Macros using Before Events | This is an introduction to the new Data Macro feature which replaces the need to write Visual Basic for Applications (VBA) code. Learn common techniques, such as, trigger actions when a record is added, changed, wherever the change is made within the application. | 6:14 | |
| After Event Data Macros | After Event Data Macros have additional actions available to execute more complex data operations. | 9:39 | |
| Using Named Data Macros | Named Data Macros offers the flexibility to build some very complex business solutions without having to write any VBA code. | 12:08 | |
| Building Custom Web Database Forms | In this session, you will learn several methods of creating forms that are bound directly to a data source, such as a table or query. | 13:33 | |
| User Interface Macros and Controls | Forms are the primary interface between the user and your Web Application. In this video some of the most common controls will be used when creating custom forms compatible with a Web Database. | 12:19 | |
| Navigation Control in Access 2010 | This session explores a new type of control in Access 2010 called Navigation Control. This set of controls are used to build Navigation Forms that provide the end user with an easy to use intuitive interface to navigate to the various forms and reports within the web application. | 12:42 | |
| Building Custom Reports | Reports are the main way to review or print data from your web database. They provide the end user with great flexibility to view, print and export data using only a Web Browser. | 11:34 | |
| Publishing Web Applications to SharePoint Access Services | Publishing a Web Application to an Access Services SharePoint site is a one click step. Or is it? Learn about the process of publishing and some hints on what to do if things don’t happen as expected. | 11:27 | |
| Leveraging SharePoint when using Access Services | SharePoint has a number of built-in rich features that are enhanced when incorporated into an Access Services Web Application. | 12:58 | |
