Lab3_Assignment_S12_v1_guideline

Lab3_Assignment_S12_v1_guideline - IE 332 Spring 2012 1 IE...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: IE 332 Spring 2012 1 IE 332 Computing in Industrial Engineering Lab 3: Database 1 Guideline This is a solution guide; in certain cases it may not show the complete details, and in certain cases there can be other answers which are also correct. 1. How many products do Northwind Traders have? Explain how you find the information and provide a screen shot as well. a. Example Use the query count to know the total number of products for the company. <Query> Query in given on the Product table, using the Total function. <Result> This will return a single number for the total count. IE 332 Spring 2012 2 b. Room for Improvement As Access has user friendly table features similar to a spreadsheet, simple aspects can be known without using query. When looking for the number of products, it is possible to look at the largest product ID to find out the answer. However, since it is an autonumber field, numbers are assigned in sequential order and if a record is erased that product ID will not be reassigned. This means that if a record is deleted, they may get the wrong answer. IE 332...
View Full Document

This note was uploaded on 02/22/2012 for the course IE 332 taught by Professor Staff during the Spring '08 term at Purdue University-West Lafayette.

Page1 / 9

Lab3_Assignment_S12_v1_guideline - IE 332 Spring 2012 1 IE...

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

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