This preview shows pages 1–3. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full 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.
- Spring '08
- Industrial Engineering