BIS 245 Week 3 Lab

Week 3: Lab Overview – Instructions – Step by Step Step 1: View the Step-by-Step Video for the LabStep 2: Review the Scenario SummaryStep 3: Deliverables – Note the need to upload both a Visio file and an Access Database file.Step 4: Complete the SIMBook Chapter 2 TasksStep 5: Required Software – Ensure you have installed Microsoft Word Visio and Access …or…Step 6: Ensure you are able to access the CITRIX Virtual Environment and are able to open both Access and Visio files.Step 7: Download the “Week 3 Lab Instructions” fileStep 8: Download the “Lab 3 Database File”Step 9: Download the “Lab 3 Visio File”Step 10: Open and review the “Week 3 Lab Instructions”Step 11: Complete ALL steps carefully!Step 12: Be sure to add your name to the beginning of both file names before submitting them for grading. Scenario Summary You have been asked to extend the database you developed in Lab 2 to also include customer data to populate the tables in the database with sample data and to create some queries using this data to illustrate how the database can supply information that is useful to management. The purpose of this lab is to provide experience with modifying a database entering data into tables and creating simple queries. Using MS Visio you will add a customers entity to the ERD you created in Lab 2. Based on the modified ERD you will add the corresponding customers table to the MS Access database from Lab 2. You will then enter sample data into the tables in this database and create some basic queries to illustrate how data from the tables can be presented to satisfy managers information needs. Upon completing this lab you will be able to Deliverables Part A: YourNameLab3.vsdx (Visio diagram) Part B: YourNameLab3.accdb (Access database) Part C: Complete the tasks in SIMbook Chapter 2 Requirements: Complete Lab modify an existing MS Visio ERD to include new entities and relationships; modify an existing MS Access database to include new entities and relationships; enter data into tables in a MS Access database using datasheet view; and create and run simple queries in MS Access.