Microsoft Support Number OR Call Toll-Free @ 1-844-478-2887

Thursday, January 5, 2012

Microsoft Access 2010 and SharePoint 2010

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.

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.

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.

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.

After Event Data Macros

After Event Data Macros have additional actions available to execute more complex data operations.

Using Named Data Macros

Named Data Macros offers the flexibility to build some very complex business solutions without having to write any VBA code.

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.

User Interface Macros & 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.


This session explores a new type of control in Access 2010, called a Navigation Control. These 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.

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.

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.

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.

No comments: