For years, Microsoft Access has enabled developers to create database applications that address a specific business need, task, or process. In Access 2010, applications are now modern-looking right out of the box – no customization necessary. Access, through Access Services in SharePoint 2010, is now on the web – developers can create and share databases online. The web is also integrated within Access with mashup-type web functionality within Access applications. To use this new functionality, developers need to be aware of the differences among web databases, client-only databases, and hybrid databases. This unit introduces the developer to these concepts and to the new Access 2010 and Access Services through SharePoint 2010 functionality.
Hands-On Labs
Building Solutions with Access 2010 Lab
The objectives of this Hands-On Lab are to acquaint you with the new developer related features of Access 2010 with a keen emphasis on understanding the differences between developing database objects that will work in a Web database versus objects that work only in a client database. This lab helps you understand the benefits of starting from templates, learn basic data design modification for Web databases, develop an understanding of Web form modification and creation, learn how to use navigation forms and learn how to use the new data macro editing environment.
Videos
Getting Started with Access 2010
In this video you will see how to get started faster with Access 2010 by using templates, application parts and the built-in quick start fields.
Better Design Tools with Access 2010
In Access 2010 the product group made significant investments around design tools. This video describes the ease of creating navigation forms, use of the Macro designer and the availability of Intellisense in the Access environment.
Access 2010 Web Databases
The ability to create Web databases and publish them to SharePoint 2010 via Access Services is an all new feature in Access 2010. Access databases need no longer be bound to the client, they can now have the reach of the Web. This video describes how to build Access Web databases.