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.

Overview

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.

Objectives

The objectives of this Hands-On Lab are to acquaint the reader with 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.

• Understand the benefit of starting from templates
• Learn basic data design modifications for Web databases
• Develop an understanding of Web form modification and creation
• Learn how to use Navigation forms
• Learn how to use the new macro editing environment

System Requirements

You must have the following items to complete this lab:

• Microsoft Access 2010

Online Resources

Additional Online Resources:

• Microsoft Access Team Blog
  • https://blogs.msdn.com/access
• Access 2010 Intro Series Blog posts
  • https://blogs.msdn.com/access/archive/tags/2010+Intro+Series/default.aspx
• Access 2010 Macro Designer
  • https://blogs.msdn.com/access/archive/2009/07/28/meet-the-access-2010-macro-designer.aspx
• Access 2010 Data Macros
  • https://blogs.msdn.com/access/archive/2009/08/13/access-2010-data-macros-similar-to-triggers.aspx
• Tutorial: Publish an Access 2007 Database to the Web
  • https://channel9.msdn.com/shows/Access/Tutorial-Publish-a-Access-2007-database-to-the-web/
• The Access Show on Channel 9
  • https://channel9.msdn.com/shows/Access/

Setup

There is no special setup for this lab.

Exercises

This Hands-On Lab comprises the following exercises:

1. Modifying the table structure of a Web Database
2. Web Database Form Modification
3. Web Database Form Creation and Navigation
4. Creating a Data Macro
5. Publish a Database to the Web (Optional)

Estimated time to complete this lab: 60 minutes.

Starting Materials

This Hands-On Lab has no starting materials.

• Exercises 1-5. There are no starting materials for these exercises.
  Note:

  See the Completed Files folder for a completed example of the Job Applicant database.