Setting Data Environment[SQL-Sever]

Setting Data Environment - Exercise

Adding a data environment to the VirtualBookShelf.com application

Objective: Add a data environment and database connection to the virtualbook.mdb database.

Exercise scoring

This exercise is worth 3 points and is automatically scored. When you are finished, just click the Submit button to receive credit.

Background/overview

In this exercise you will setup the Data Environment and database connection to the virtualbook.mdb database. You must complete this exercise in order to complete exercises later in the course.

Download files

You will need the following file to do this exercise:

virtualbook.mdb

This is the database to which you will establish a connection in this exercise. Go to the Resources page and download the course project file. Store the virtualbook.mdb file in the VirtualBookShelf_Local directory.

Instructions

To get started follow the instructions below:

Begin by right-clicking the project name in the Project Explorer window.
Select "Add Data Connection".
Select the Machine Data Source tab and click to add the database.
Continue by following the steps described in the simulation you completed for this lesson.