Lab3_Assignment_S12_v10

Lab3_Assignment_S12_v10 - 2. Which products of Northwind...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
IE 332 Spring 2012 1 IE 332 Computing in Industrial Engineering Lab 3: Database 1 Last name: First name: Lab Session: Tasks The goal of this lab is to learn the basics of Microsoft Office Access 2007. First, please visit the following website and follow the instruction. Out of the five modules, you should finish the first two in the red circle (“Database Basics” and “Working with Tables”). http://inpics.net/tutorials/access2007/basics.html Second, download an access file 1 (Nwind.zip) from the following location and unzip the file , and answer the subsequent questions: BlackBoard >Lab Notes>Nwind.zip 1 The access file was obtained from http://www.microsoft.com/downloads
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
IE 332 Spring 2012 2 1. How many products do Northwind Traders have? Explain how you find the information and provide a screen shot as well.
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 2. Which products of Northwind Traders cost more than $20 per unit? Explain how you find the information and provide a screen shot as well. 3. Which one is the best-seller product (in terms of quantity of sales)? Explain how you find the information and provide a screen shot as well. 4. What is the SQL query for Question 3? 5. Describe the different data types contained in the employees table. Explain how you find the information and provide a screen shot as well. Submission a) Answer all of the questions and save this MS Word file as lab03_[session #]_[your Purdue Career Account].doc (e.g., lab03_A_kim731.doc) and submit it to BlackBoard. b) If you cannot complete the assignment during the lab, save whatever you have completed and submit it to BlackBoard before you leave....
View Full Document

Page1 / 2

Lab3_Assignment_S12_v10 - 2. Which products of Northwind...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online