Comm 391 Final Sample

Name: ......................................................... Student No.: ................................. Section No.: ...........

THE UNIVERSITY OF BRITISH COLUMBIA

Sauder School of Business

COMMERCE 391 Introduction to Management Information Systems Final Examination June 2011

Time: 2½ Hours

Read This Now!

The examination consists of 11 pages in this booklet (including this cover sheet). Check to ensure that your copy is complete. Please hand back all 11 pages at the end of the examination. The value of each question is stated in the examination paper.

Question A. (28) B. (72) _____ _____

Total (100) _____

All questions are to be answered in the spaces provided on the examination paper.

Writing elsewhere on the paper will be ignored. Do not write on the backs of pages or in the margins. Plan your answers carefully before starting to write. It is the quality of your response that counts, not its length. Neat, easy to read printing or writing helps to ensure that the content of your answers will get through to the reader. When answering questions related to a case, be sure to deal with the specific situation of that company.

Comm 391 Final Exam (Summer 2011)

Page 2 of 11

A. Microsoft Access (28 marks) Use the "database" represented in the diagram below to help develop the queries below

1. Based on the database shown in the above diagram create a query that shows information about songs for a particular artist that is entered by the user. The query should only display the name, rating, bitrate, duration of the track. [8 marks] Write down the tables used to develop the query: Field: Table: Total:

Sort:

Show: Criteria:

Comm 391 Final Exam (Summer 2011)

Page 3 of 11

2. Write a query that will show information about albums by the artists "Missy Elliot". The query should only display the name, rating and year of the album. [10 marks]

Write down the tables used to develop the query: Field: Table: Total:

Sort:...