Lab Overview
Scenario/Summary
Part A:You have been asked to create a database model using MS Visio Database Model Diagram Template. The purpose of this Lab is to provide experience designing with limited instructions a simple database based on a list of data requirements and associated business rules.
Upon completing this Lab you will be able to
Part B:The Lab begins with a simple example of query development using Access; then evolves to more complex queries which the student should perform after completing the first exercise. Create a query using the wizard with query-design view or with SQL statements. The Northwind (NWind) database will be used again in this Lab.
Upon completing this lab you should be able to
Deliverables
Part A:YourNameLab4A.vsdx (Visio Diagram)
Part B:YourName_Lab4B_Finital.accdb (Access Database)
Required Software
Microsoft Office: Word 2013 Visio 2013 and Access 2013
Options for accessing the software:
Lab Steps
STEP 1: Complete the Week 4a and 4b Labs
Download and complete theWeek 4a Lab Instructions(Links to an external site.)Links to an external site..
Download and complete theWeek 4b Lab Instructions(Links to an external site.)Links to an external site..