Page 1 of 31
D. Deliverables Section Part B Step 4 Part C Step 6 E. Lab Steps Preparation 1. Get the Database from Doc Sharing: a. Download Lab1_Nwind.accdb file from your course Doc Sharing panel (Labs view), and Save the file to your local drive b. Download Lab1C_Questions.docx from your course Doc Sharing panel, 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 iLab tab in Course Home. 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 iLab tab in Course Home. Deliverable YourName_Lab1.vsd (Visio Diagram) YourName_Lab1C_Questions.docx Points
Page 2 of 31
Lab Part A: Become Familiar with MS Visio Step 1: Locate the Microsoft Office Applications a. If you are using Citrix, 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 Microsoft VISIO should open like the following screen. Notice that the highlighted diagram template is the Database Model and Diagram, in the recently used templates. You will not see this in your templates as you have not yet used this tool. You will need to click on the Software and Database category (circled in red below) in the Template Categories area.
Figure 1- a
Page 3 of 31
b. From the Templates Categories, click to select the Software and Database category. See the next screen capture. The Database Model Diagram template is selected.
Figure 1-b Figure a
Page 4 of 31
c. Under Choose a Template, double-click the Database Model Diagram to select this template set, opening the template as follows: (An alternate method is to select the Database Model Diagram Template, and then click the Create button to open the new file.)
Figure 1- c
Page 5 of 31
Step 3: Set Visio Database Options for Crow’s Foot Notation a. Change VISIO settings to use Crow’s Foot notation for the model diagrams. NOTE: This notation will most closely match the models used in your textbook. From the Database ribbon, select Modeling Preferences.
Page 6 of 31
Page 7 of 31
b. Once you click on Modeling Preferences, the following dialog box should appear with the Logical Diagram default settings as shown below. These settings suit our purposes. If your...