A. Lab #: BSBA BIS245A-1

B. Lab 1 of 7: Introduction to MS Visio and MS Access

C. Lab Overview—Scenario/Summary

COs:

1. Given a business situation in which managers require information from a database, determine, analyze, and classify that information so that reports can be designed to meet the requirements.

2. Given a situation containing entities, business rules, and data requirements, create the conceptual model of the database using a database modeling tool.

Scenario:

You have been asked to create two conceptual database models using MS Visio database notation template. The purpose of this lab is to have you gain familiarity with the various modeling tools needed to create a conceptual model (entity-relationship diagram or ERD) of a database. You will create two conceptual models.

You will then open an existing access database to explore database objects and to experiment with simple data manipulation using filters and sorts and to begin elementary work with relationships.

Upon completing this lab, you will be able to

1. relying on detailed instructions, create a simple conceptual model for a two-table database using MS Visio;

2. use experience gained in creating the first model to construct a similar conceptual model without the instructions; and

3. download an existing Microsoft Access database file. Open the database; find and identify different database objects in this database.

D. Deliverables

Section

Deliverable

Points

Part B Step 4

YourName_Lab1.vsdx (Visio Diagram)

Part C Step 8

YourName_Lab1C_ScreenPrints.docx

E. Lab Steps

Preparation

1. Download the database file.

a. Download Lab1_Nwind.accdb file from the Week 1 Lab page, and save the file to your local drive.

b. Create a new MS Word document named Lab1C_ScreenPrints.docx from the Week 1 Lab page, and save the file to your local drive.

2. Using Citrix for MS Visio and/or MS Access

a. If you are using the Citrix remote lab, follow the login instructions located in the lab area in Introduction and Resources.

b. You will have to upload the Lab1_NWind.accdb file to your Citrix drive. Follow the instructions for uploading files to Citrix, located in the lab area in the Introduction and Resources area.

Lab

Part A: Become Familiar With MS Visio

Step 1: Locate the Microsoft Office Applications

a. If you are using Cirtix, click on the Microsoft Office applications folder.

b. If you are using Visio on a local computer, select it from your program list. You may need to select Microsoft Office from your program menu, and then select Visio.

Step 2: Start Visio

a. Click on Microsoft Visio and it should open like the following screen. Notice that the list of diagrams is shown. At the upper left-hand side, there are two tab options: featured and categories. Click on the categories section, as shown circled in red below.

b. Select the database and software option from the categories listed, as seen below.