ITM309-Spring2011-Assignment4-Access

ITM309-Spring2011-Assignment4-Access - ITM 309 Spring 2011...

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

View Full Document Right Arrow Icon
ITM 309 Spring 2011 Assignment #4: Access-DSS Due : At 8 am on the day of YOUR recitation #13, (04/13/2011 or 04/14/2011), in your Section’s Drop Box on Angel (Access file). Points: 60 (15 point penalty if less than 8 hours late, 30 point penalty if less than 24 hours late, 60 point penalty if more than 24 hours late.) Purpose: Be familiar with a) linking Excel with Access and b) creating tables and queries in Access Scenario : A manufacturing company, Teleworks, has been a leader in the cellphone market for the last 10 years. Other firms have imitated its product with some degree of success but Teleworks is dominant in its market since it has been around for a longer time and has a very innovative culture. Recently, Teleworks began selling a new type of cellphone, which is more durable and has better features. Because of new phone is so advanced, Teleworks expects more calls to the customer support hotline. Thus, it needs a database to record and track customer calls. Teleworks’ Customer Service Manager currently uses an Excel sheet for recording call center information. However, since it doesn’t support queries, she finds it difficult to answer questions about the state of customer support or to analyze common customer issues. Also, there is some redundant information present, and users are
Background image of page 1

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

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

Page1 / 4

ITM309-Spring2011-Assignment4-Access - ITM 309 Spring 2011...

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